· 9 years ago · Nov 08, 2016, 08:12 PM
1CREATE TABLE IF NOT EXISTS `mydb`.`Item` (
2 `idItem` INT NOT NULL,
3 `madeBy` VARCHAR(45) NULL,
4 `productName` VARCHAR(45) NOT NULL,
5 `protuctType` INT NOT NULL,
6 `modelPart` INT NOT NULL,
7 `wight` INT NULL,
8 `Wight` INT NULL,
9 `height` INT NULL,
10 `isImported` TINYINT(1) NOT NULL,
11 `isDangeruse` TINYINT(1) NOT NULL,
12 `countyCodel` INT NOT NULL,
13 PRIMARY KEY (`idItem`),
14 UNIQUE INDEX `idItem_UNIQUE` (`idItem` ASC),
15 CONSTRAINT ``
16 FOREIGN KEY ()
17 REFERENCES `mydb`.`User` ()
18 ON DELETE NO ACTION
19 ON UPDATE NO ACTION)
20ENGINE = InnoDB
21DEFAULT CHARACTER SET = dec8