· 6 years ago · Jan 02, 2020, 03:28 PM
1DROP TABLE IF EXISTS `wideworldimporters`.`discount`;
2CREATE TABLE IF NOT EXISTS `wideworldimporters`.`discount` (
3 `DiscountID` INT(11) NOT NULL,
4 `DiscountPercentage` INT(11) NOT NULL,
5 `DiscountCode` VARCHAR(20) NOT NULL,
6 `Active` TINYINT(4) NOT NULL,
7 `DiscountStartDate` DATETIME NOT NULL,
8 `DiscountEndDate` DATETIME NOT NULL,
9 `Comment` VARCHAR(45) NULL DEFAULT NULL,
10 PRIMARY KEY (`DiscountID`, `DiscountCode`))
11ENGINE = InnoDB
12DEFAULT CHARACTER SET = latin1