Rbr0w6ch

1Executing SQL script in server
2ERROR: Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key
3SQL Code:
4        -- -----------------------------------------------------
5        -- Table `mydb`.`Order`
6        -- -----------------------------------------------------
7        CREATE TABLE IF NOT EXISTS `mydb`.`Order` (
8          `id` INT NOT NULL AUTO_INCREMENT,
9          `orderID` INT NOT NULL,
10          `createDate` DATE NOT NULL,
11          `createBY` VARCHAR(45) NOT NULL,
12          `isPromotion` TINYINT(1) NOT NULL,
13          `MeberShipDiscount` TINYINT(1) NOT NULL,
14          `transactionID` INT NOT NULL,
15          `userID` INT NULL,
16          PRIMARY KEY (`orderID`),
17          UNIQUE INDEX `orderID_UNIQUE` (`orderID` ASC),
18          UNIQUE INDEX `transactionID_UNIQUE` (`transactionID` ASC),
19          INDEX `userID_idx` (`userID` ASC))
20        ENGINE = InnoDB