Kod
Error
SQL query:
CREATE TABLE `accounts` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`USERNAME` VARCHAR( 16 ) NOT NULL ,
`PASSWORD` VARCHAR( 40 ) NOT NULL ,
`EMAIL` VARCHAR( 40 ) NOT NULL ,
`ACTIVE` INT( 11 ) NOT NULL ,
`ACTIVATIONCODE` VARCHAR( 40 ) NOT NULL ,
`BUCKUPPASS` VARCHAR( 40 ) NOT NULL
) ENGINE = MYISAM
MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
Czy ktoś może zna rozwiązanie problemu?
SQL query:
CREATE TABLE `accounts` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`USERNAME` VARCHAR( 16 ) NOT NULL ,
`PASSWORD` VARCHAR( 40 ) NOT NULL ,
`EMAIL` VARCHAR( 40 ) NOT NULL ,
`ACTIVE` INT( 11 ) NOT NULL ,
`ACTIVATIONCODE` VARCHAR( 40 ) NOT NULL ,
`BUCKUPPASS` VARCHAR( 40 ) NOT NULL
) ENGINE = MYISAM
MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key