use salarymarket;

INSERT INTO   solution_menu (id,menuCode, menuLibelle, parentId, type, guid) VALUES
(1,'home', 'Home', 0 , 'menu', UUID()),
(2, 'company_compensation', 'Company compensation ', '0', 'menu', UUID()),
(3, 'quiz', 'Quiz  ', '0', 'menu', UUID()),
(4, 'report', 'Report  ', '0', 'menu', UUID()),
(5,'myClients', 'My Clients', 0, 'menu', UUID()),
(6,'myClients_clients', 'Clients', 5, 'menu', UUID()),
(7,'clients_demonstration', 'Demonstration', 5, 'menu', UUID()),
(8,'Informations', 'Informations', 6, 'subMenu', UUID()),
(9,'users', 'Users', 6, 'subMenu', UUID()),
(10,'entites', 'Entites', 6, 'subMenu', UUID()),
(11,'profils', 'Profils', 6, 'subMenu', UUID()),
(12,'configuration', 'Configuration', 6, 'subMenu', UUID()),
 
(13,'myCompany', 'My company', 0, 'menu', UUID()),
(14,'myCompany_informations', 'Informations', 13, 'menu', UUID()),
(15,'myCompany_users', 'Users', 13, 'menu', UUID()),
(16,'myCompany_entities', 'Entities', 13, 'menu', UUID()),
(17,'myCompany_profiles', 'Profiles', 13, 'menu', UUID()),
(18,'myCompany_configuration', 'Configuration', 13, 'menu', UUID()),
(19,'myCompany_settings', 'Settings', '13', 'menu', UUID()),
(20,'language', 'Language', 19, 'subMenu', UUID()),
(21,'administration', 'Administration', 0, 'menu', UUID()),
(22,'administration_settings', 'Settings', 21, 'menu', UUID()),
(23,'settings_languages', 'Languages', 22, 'subMenu', UUID()),
(24,'administration_entities', 'Entities', 21, 'menu', UUID()),
(25,'administration_subscription', 'Subscription', 21, 'menu', UUID()),
(26,'settings_country', 'Country', 22, 'subMenu', UUID()),
(27,'settings_business_sector', 'Business sector', 22, 'subMenu', UUID()),
(28,'settings_ca', 'CA', 22, 'subMenu', UUID()),
(29,'settings_geographic_extent', 'Geographic extent', 22, 'subMenu', UUID()),
(30,'settings_company_size', 'Company size', 22, 'subMenu', UUID()),
(31,'settings_value_chain', 'Value chain', 22, 'subMenu', UUID()),
(32,'home_administration', 'Administration', 1, 'subMenu', UUID()),
(33,'home_indicateurs', 'Indicateurs', 1, 'subMenu', UUID()),
(34,'home_administration_clients', 'Clients', 32, 'widget', UUID()),
(35,'home_administration_abonnement', 'Abonnement', 32, 'widget', UUID()),
(36,'home_indicateurs_nbEmployees', 'Nombres des employés', 33, 'widget', UUID());

INSERT INTO company_solution_menu (id,state, companyId, menuId) VALUES
(1,1, 1, 1),
(2,1, 1, 2),
(3,1, 1, 3),
(4,1, 1, 4),
(5,1, 1, 5),
(6,1, 1, 6),
(7,1, 1, 7),
(8,1, 1, 8),
(9,1, 1, 9),
(10,1, 1, 10),
(11,1, 1, 11),
(12,1, 1, 12),
(13,1, 1, 13),
(14,1, 1, 14),
(15,1, 1, 15),
(16,1, 1, 16),
(17,1, 1, 17),
(18,1, 1, 18),
(19,1, 1, 19),
(20,1, 1, 20),
(21,1, 1, 21),
(22,1, 1, 22),
(23,1, 1, 23),
(24,1, 1, 24),
(25,1, 1, 25),
(26,1, 1, 26),
(27,1, 1, 27),
(28,1, 1, 28),
(29,1, 1, 29),
(30,1, 1, 30),
(31,1, 1, 31),
(32,1, 1, 32),
(33,1, 1, 33),
(34,1, 1, 34),
(35,1, 1, 35),
(36,1, 1, 36);
-- insert into company_menu_solution_profils
INSERT INTO company_solution_menu_profils (id,state, profileId, menuSolutionCompanyId) VALUES
(1,1, 1, 1),
(2,1, 1, 2),
(3,1, 1, 3),
(4,1, 1, 4),
(5,1, 1, 5),
(6,1, 1, 6),
(7,1, 1, 7),
(8,1, 1, 8),
(9,1, 1, 9),
(10,1, 1, 10),
(11,1, 1, 11),
(12,1, 1, 12),
(13,1, 1, 13),
(14,1, 1, 14),
(15,1, 1, 15),
(16,1, 1, 16),
(17,1, 1, 17),
(18,1, 1, 18),
(19,1, 1, 19),
(20,1, 1, 20),
(21,1, 1, 21),
(22,1, 1, 22),
(23,1, 1, 23),
(24,1, 1, 24),
(25,1, 1, 25),
(26,1, 1, 26),
(27,1, 1, 27),
(28,1, 1, 28),
(29,1, 1, 29),
(30,1, 1, 30),
(31,1, 1, 31),
(32,1, 1, 32),
(33,1, 1, 33),
(34,1, 1, 34),
(35,1, 1, 35),
(36,1, 1, 36);
INSERT INTO solution_subscription (type, menuId,state) VALUES
('On The Menu', 1,1),   -- home
('On The Menu', 2,1),   -- company_compensation
('On The Menu', 13,1),  -- myCompany
('On The Menu', 14,1),  -- Informations 
('On The Menu', 15,1),  -- users 
('On The Menu', 16,1),  -- entites 
('On The Menu', 17,1),  -- profils 
('On The Menu', 18,1),  -- configuration 
('On The Menu', 19,1),  -- setting 
('On The Menu', 20,1),  -- language (language)
('On The Menu', 32,1),   -- administration
('On The Menu', 33,1),   -- indicateurs
('On The Menu', 34,1),  -- clients
('On The Menu', 35,1),  -- abonnement
('On The Menu', 36,1),  -- employees
('Advanced', 1,1),   -- home
('Advanced',4 ,1),   -- report
('Advanced',  13,1),  -- myCompany
('Advanced', 14,1),  -- Informations  
('Advanced',  15,1),  -- users  
('Advanced',  16,1),  -- entites  
('Advanced',  17,1),  -- profils  
('Advanced', 18,1) ,  -- configuration  
('Advanced', 19,1),  -- setting  
('Advanced', 20,1),  -- language  
('Advanced', 32,1),   -- administration
('Advanced', 33,1),   -- indicateurs
('Advanced', 34,1),  -- clients
('Advanced', 35,1),  -- abonnement
('Advanced', 36,1),  -- employees  
('Essential',  1,1),   -- home
('Essential',  2,1),   -- company_compensation
('Essential',  3,1),   -- quiz
('Essential',  4,1),   -- report
('Essential',  13,1),  -- myCompany
('Essential', 14,1),  -- Informations 
('Essential',  15,1),  -- users 
('Essential',  16,1),  -- entites 
('Essential',  17,1),  -- profils 
('Essential', 18,1) ,-- configuration 
('Essential', 19,1),  -- setting 
('Essential', 20,1),  -- language (language); 
('Essential', 32 ,1),   -- administration
('Essential', 33,1),   -- administration
('Essential', 34,1),   -- clients
('Essential', 35,1),   -- abonnement
('Essential', 36,1);  -- employees;