rkBT12fn

1DROP TABLE IF EXISTS`wideworldimporters`.`orderwwi`;
2CREATE TABLE IF NOT EXISTS `wideworldimporters`.`orderwwi` (
3  `OrderID` INT(11) NOT NULL AUTO_INCREMENT,
4  `AccountID` INT(11) NOT NULL,
5  `OrderDate` DATETIME NOT NULL,
6  `ExpectedDeliveryDate` DATETIME NOT NULL,
7  `DiscountID` INT(11) NULL DEFAULT NULL,
8  `Comment` VARCHAR(45) NULL DEFAULT NULL,
9  PRIMARY KEY (`OrderID`),
10  INDEX `fk_OrderWWI_user1` (`AccountID` ASC) VISIBLE,
11  INDEX `fk_OrderWWI_discount1` (`DiscountID` ASC) VISIBLE,
12  CONSTRAINT `fk_OrderWWI_discount1`
13    FOREIGN KEY (`DiscountID`)
14    REFERENCES `wideworldimporters`.`discount` (`DiscountID`)
15    ON DELETE NO ACTION
16    ON UPDATE NO ACTION,
17  CONSTRAINT `fk_OrderWWI_user1`
18    FOREIGN KEY (`AccountID`)
19    REFERENCES `wideworldimporters`.`user` (`AccountID`)
20    ON DELETE NO ACTION
21    ON UPDATE NO ACTION)
22ENGINE = InnoDB
23AUTO_INCREMENT = 4
24DEFAULT CHARACTER SET = latin1;
25DROP TABLE IF EXISTS`wideworldimporters`.`orderlinewwi`;
26CREATE TABLE IF NOT EXISTS `wideworldimporters`.`orderlinewwi` (
27  `OrderlineID` INT(11) NOT NULL AUTO_INCREMENT,
28  `OrderID` INT(11) NOT NULL,
29  `StockItemID` INT(11) NOT NULL,
30  `ItemQuantity` INT(11) NOT NULL,
31  `UnitPrice` DECIMAL(18,3) NOT NULL,
32  `TaxRate` DECIMAL(18,3) NOT NULL,
33  `Comment` VARCHAR(45) NULL DEFAULT NULL,
34  PRIMARY KEY (`OrderlineID`),
35  INDEX `fk_OrderlineWWI_OrderWWI1` (`OrderID` ASC) VISIBLE,
36  INDEX `fk_OrderlineWWI_stockitems1` (`StockItemID` ASC) VISIBLE,
37  CONSTRAINT `fk_OrderlineWWI_OrderWWI1`
38    FOREIGN KEY (`OrderID`)
39    REFERENCES `wideworldimporters`.`orderwwi` (`OrderID`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION,
42  CONSTRAINT `fk_OrderlineWWI_stockitems1`
43    FOREIGN KEY (`StockItemID`)
44    REFERENCES `wideworldimporters`.`stockitems` (`StockItemID`)
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION)
47ENGINE = InnoDB
48AUTO_INCREMENT = 4
49DEFAULT CHARACTER SET = latin1;