dccP1GZJ

1CREATE TABLE IF NOT EXISTS `SalesAnalysisPositionProperty` (
2            `salesAnalysisId` int(10) unsigned NOT NULL,
3            `productId` int(10) unsigned NOT NULL,
4            `propertyId` int(10) unsigned NOT NULL,
5            `isLong` int(10) unsigned NOT NULL,
6            PRIMARY KEY (`salesAnalysisId`,`productId`,`propertyId`,`isLong`),
7            KEY `fkSalesAnalysisPositionPropertySalesAnalysis1_idx` (`salesAnalysisId`),
8            KEY `fkSalesAnalysisPositionPropertyProduct1_idx` (`productId`),
9            KEY `fkSalesAnalysisPositionPropertySalesAnalysisProperty1_idx` (`propertyId`),
10            CONSTRAINT `fkSalesAnalysisPositionPropertyProduct1` FOREIGN KEY (`productId`) REFERENCES `Product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
11            CONSTRAINT `fkSalesAnalysisPositionPropertySalesAnalysis1` FOREIGN KEY (`salesAnalysisId`) REFERENCES `SalesAnalysis` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
12            CONSTRAINT `fkSalesAnalysisPositionPropertySalesAnalysisProperty1` FOREIGN KEY (`propertyId`) REFERENCES `SalesAnalysisProperty` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
13          ) ENGINE=InnoDB DEFAULT CHARSET=utf8
14
15ALTER TABLE SalesAnalysisPositionData ADD COLUMN orderCountBase int(10) unsigned NOT NULL AFTER orderCount