Projet

Général

Profil

Script BDD » Module script.sql

Issam Abdelhafidh, 27/06/2024 18:11

 
1
/* Insert into menuSolution */
2
INSERT INTO `socle`.`menu_solution` (`id`, `menuCode`, `menuLibelle`, `parentId`, `type`) 
3
VALUES ('27', 'request', 'request', '0', 'menu');
4

    
5
INSERT INTO `socle`.`menu_solution` (`id`, `menuCode`, `menuLibelle`, `parentId`, `type`) 
6
VALUES ('28', 'deliveryNote', 'deliveryNote', '0', 'menu');
7

    
8
/* Insert into menuSolutionCompany */
9
INSERT INTO `socle`.`menu_solution_company` (`id`, `state`, `companyId`, `menuId`) 
10
VALUES ('27', '1', '1', '27');
11

    
12
INSERT INTO `socle`.`menu_solution_company` (`id`, `state`, `companyId`, `menuId`) 
13
VALUES ('28', '1', '1', '28');
14

    
15
/* Insert into menuSolutionProfile */
16
INSERT INTO `socle`.`menu_solution_profils` (`id`, `state`, `profileId`, `menuSolutionCompanyId`) 
17
VALUES ('27', '1', '1', '27');
18

    
19
INSERT INTO `socle`.`menu_solution_profils` (`id`, `state`, `profileId`, `menuSolutionCompanyId`) 
20
VALUES ('28', '1', '1', '28');
(2-2/3)