Salary Market

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;