use salarymarket;
INSERT INTO solution_menu (menuCode, menuLibelle, parentId, type) VALUES
('home_administration', 'Administration', 1, 'subMenu'),
('home_indicateurs', 'Indicateurs', 1, 'subMenu'),
('home_administration_clients', 'Clients', 33, 'subMenu'),
('home_administration_abonnement', 'Abonnement', 33, 'subMenu'),
('home_indicateurs_nbEmployees', 'Nombres des employés', 34, 'subMenu');

INSERT INTO company_solution_menu (id,state, companyId, menuId) VALUES
(141,1, 1, 33),
(142,1, 1, 34),
(143,1, 1, 35),
(144,1, 1, 36),
(145,1, 1, 37);

INSERT INTO company_solution_menu_profils (id,state, profileId, menuSolutionCompanyId) VALUES
(128,1, 1, 141),
(129,1, 1, 142),
(130,1, 1, 143),
(131,1, 1, 144),
(132,1, 1, 145);

INSERT INTO solution_subscription (type, menuId,state) VALUES
('Participant', 33,1),   -- administration
('Participant', 34,1),   -- indicateurs
('Participant', 35,1),  -- clients
('Participant', 36,1),  -- abonnement
('Participant', 37,1),  -- employees

('Purchaser', 33,1),   -- administration
('Purchaser', 34,1),   -- indicateurs
('Purchaser', 35,1),  -- clients
('Purchaser', 36,1),  -- abonnement
('Purchaser', 37,1),  -- employees  

('Subscriber', 33 ,1),   -- administration
('Subscriber', 34,1),   -- administration
('Subscriber', 35,1),   -- clients
('Subscriber', 36,1),   -- abonnement
('Subscriber', 37,1);  -- employees;