|
1
|
use salarymarket;
|
|
2
|
INSERT INTO solution_menu (menuCode, menuLibelle, parentId, type) VALUES
|
|
3
|
('home_administration', 'Administration', 1, 'subMenu'),
|
|
4
|
('home_indicateurs', 'Indicateurs', 1, 'subMenu'),
|
|
5
|
('home_administration_clients', 'Clients', 33, 'subMenu'),
|
|
6
|
('home_administration_abonnement', 'Abonnement', 33, 'subMenu'),
|
|
7
|
('home_indicateurs_nbEmployees', 'Nombres des employés', 34, 'subMenu');
|
|
8
|
|
|
9
|
INSERT INTO company_solution_menu (id,state, companyId, menuId) VALUES
|
|
10
|
(141,1, 1, 33),
|
|
11
|
(142,1, 1, 34),
|
|
12
|
(143,1, 1, 35),
|
|
13
|
(144,1, 1, 36),
|
|
14
|
(145,1, 1, 37);
|
|
15
|
|
|
16
|
INSERT INTO company_solution_menu_profils (id,state, profileId, menuSolutionCompanyId) VALUES
|
|
17
|
(128,1, 1, 141),
|
|
18
|
(129,1, 1, 142),
|
|
19
|
(130,1, 1, 143),
|
|
20
|
(131,1, 1, 144),
|
|
21
|
(132,1, 1, 145);
|
|
22
|
|
|
23
|
INSERT INTO solution_subscription (type, menuId,state) VALUES
|
|
24
|
('Participant', 33,1), -- administration
|
|
25
|
('Participant', 34,1), -- indicateurs
|
|
26
|
('Participant', 35,1), -- clients
|
|
27
|
('Participant', 36,1), -- abonnement
|
|
28
|
('Participant', 37,1), -- employees
|
|
29
|
|
|
30
|
('Purchaser', 33,1), -- administration
|
|
31
|
('Purchaser', 34,1), -- indicateurs
|
|
32
|
('Purchaser', 35,1), -- clients
|
|
33
|
('Purchaser', 36,1), -- abonnement
|
|
34
|
('Purchaser', 37,1), -- employees
|
|
35
|
|
|
36
|
('Subscriber', 33 ,1), -- administration
|
|
37
|
('Subscriber', 34,1), -- administration
|
|
38
|
('Subscriber', 35,1), -- clients
|
|
39
|
('Subscriber', 36,1), -- abonnement
|
|
40
|
('Subscriber', 37,1); -- employees;
|