|
1
|
use socle;
|
|
2
|
|
|
3
|
INSERT INTO `socle`.`menu_solution` (`id`, `menuCode`, `menuLibelle`, `parentId`, `type`)
|
|
4
|
VALUES ('28', 'deliveryNote', 'deliveryNote', '0', 'menu');
|
|
5
|
|
|
6
|
INSERT INTO `socle`.`menu_solution_company` (`id`, `state`, `companyId`, `menuId`)
|
|
7
|
VALUES ('28', '1', '1', '28');
|
|
8
|
|
|
9
|
INSERT INTO `socle`.`menu_solution_profils` (`id`, `state`, `profileId`, `menuSolutionCompanyId`)
|
|
10
|
VALUES ('28', '1', '1', '28');
|
|
11
|
|
|
12
|
CREATE TABLE delivery_note (
|
|
13
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
14
|
provider VARCHAR(255) NOT NULL,
|
|
15
|
airport VARCHAR(255) NOT NULL,
|
|
16
|
terminal VARCHAR(255) NOT NULL,
|
|
17
|
date DATETIME NOT NULL,
|
|
18
|
bagsNumber VARCHAR(255) NOT NULL,
|
|
19
|
createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
20
|
updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
21
|
);
|
|
22
|
|
|
23
|
-- Create DeliveryBag table
|
|
24
|
CREATE TABLE delivery_bag (
|
|
25
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
26
|
ahl VARCHAR(255) NOT NULL,
|
|
27
|
passenger VARCHAR(255) NOT NULL,
|
|
28
|
address VARCHAR(255) NOT NULL,
|
|
29
|
mainPhone VARCHAR(255) NOT NULL,
|
|
30
|
secondPhone VARCHAR(255) NOT NULL,
|
|
31
|
color VARCHAR(255) NOT NULL,
|
|
32
|
route VARCHAR(255) NOT NULL,
|
|
33
|
tag VARCHAR(255) NOT NULL,
|
|
34
|
ld01 VARCHAR(255) NOT NULL,
|
|
35
|
ld02 VARCHAR(255) NOT NULL,
|
|
36
|
bagsNumber VARCHAR(255) NOT NULL,
|
|
37
|
fileId INT NOT NULL,
|
|
38
|
deliveryNotesId INT,
|
|
39
|
FOREIGN KEY (deliveryNotesId) REFERENCES delivery_note(id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
40
|
FOREIGN KEY (fileId) REFERENCES files(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
41
|
);
|