XnhJu3fF

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