· 6 years ago · Jan 02, 2020, 03:34 PM
1DROP TABLE IF EXISTS `wideworldimporters`.`user`;
2CREATE TABLE IF NOT EXISTS `wideworldimporters`.`user` (
3 `AccountID` INT(11) NOT NULL AUTO_INCREMENT,
4 `FirstName` VARCHAR(45) NOT NULL,
5 `LastName` VARCHAR(45) NOT NULL,
6 `Address` VARCHAR(45) NOT NULL,
7 `Password` VARCHAR(255) NULL DEFAULT NULL,
8 `Emailadres` VARCHAR(45) NOT NULL,
9 `PostalCode` VARCHAR(45) NOT NULL,
10 `Active` TINYINT(4) NOT NULL,
11 `Comment` VARCHAR(45) NULL DEFAULT NULL,
12 PRIMARY KEY (`AccountID`))
13ENGINE = InnoDB
14AUTO_INCREMENT = 32
15DEFAULT CHARACTER SET = latin1