UkD5QcH4

1ALTER TABLE CustomsInvoice
2          CHANGE deliveryDate registrationDate date,
3          ADD isChecked                        int UNSIGNED   NOT NULL DEFAULT FALSE,
4          ADD cargoWaybill                     varchar(255),
5          ADD weightNet                        float UNSIGNED NOT NULL DEFAULT 0,
6          ADD weightGross                      float UNSIGNED NOT NULL DEFAULT 0,
7          ADD priceLoad                        float UNSIGNED NOT NULL DEFAULT 0
8
9CREATE TABLE IF NOT EXISTS CustomsInvoicePositionPriceRule
10          (
11            id   INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
12            name VARCHAR(32)  NOT NULL
13          ) ENGINE = innodb
14            CHARSET 'UTF8'
15
16INSERT IGNORE INTO CustomsInvoicePositionPriceRule
17          VALUES (1, 'Ручное'),
18                 (2, 'По индикативам'),
19                 (3, 'По мин. цене'),
20                 (4, 'Занижение')
21
22CREATE TABLE IF NOT EXISTS `CustomsInvoicePosition`
23          (
24            `invoicePositionId` int(10) UNSIGNED NOT NULL,
25            `classifierId`      int(10) UNSIGNED NOT NULL,
26            `weightNet`         float UNSIGNED   NOT NULL,
27            `weightGross`       float UNSIGNED   NOT NULL,
28            `weightNetManual`   float UNSIGNED   NOT NULL,
29            `weightGrossManual` float UNSIGNED   NOT NULL,
30            `volume`            float UNSIGNED   NOT NULL,
31            `priceRuleId`       int(10) UNSIGNED NOT NULL,
32            PRIMARY KEY (`invoicePositionId`),
33            KEY `fkCustomsInvoicePositionClassifier1_idx` (`classifierId`),
34            KEY `fkCustomsInvoicePositionPriceRule1_idx` (`priceRuleId`),
35            CONSTRAINT `fkCustomsInvoicePositionInvoicePosition1` FOREIGN KEY (`invoicePositionId`) REFERENCES `InvoicePosition` (`id`) ON UPDATE CASCADE ON DELETE CASCADE,
36            CONSTRAINT `fkCustomsInvoicePositionClassifier1` FOREIGN KEY (`classifierId`) REFERENCES `Classifier` (`id`),
37            CONSTRAINT `fkCustomsInvoicePositionPriceRule1` FOREIGN KEY (`priceRuleId`) REFERENCES `CustomsInvoicePositionPriceRule` (`id`)
38          ) ENGINE = InnoDB
39            DEFAULT CHARSET = utf8
40
41CREATE TABLE `CustomsInvoicePositionPrice`
42          (
43            `invoicePositionId` int(10) UNSIGNED NOT NULL,
44            `priceRuleId`       int(10) UNSIGNED NOT NULL,
45            `price`             float UNSIGNED DEFAULT NULL,
46            UNIQUE KEY `CustomsInvoicePositionPriceInvoicePositionIdPriceRuleId_idx` (`invoicePositionId`, `priceRuleId`),
47            KEY `fkCustomsInvoicePositionPriceRule1_idx` (`priceRuleId`),
48            CONSTRAINT `fkCustomsInvoicePositionPriceInvoicePosition1` FOREIGN KEY (`invoicePositionId`) REFERENCES `InvoicePosition` (`id`) ON UPDATE CASCADE ON DELETE CASCADE,
49            CONSTRAINT `fkCustomsInvoicePositionPricePriceRule1` FOREIGN KEY (`priceRuleId`) REFERENCES `CustomsInvoicePositionPriceRule` (`id`)
50          ) ENGINE = InnoDB
51            DEFAULT CHARSET = utf8