CREATE TABLE `users` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 30 ) NOT NULL ,
`password` CHAR( 40 ) NOT NULL ,
`email` VARCHAR( 70 ) NOT NULL ,
`active` CHAR( 32 ) NOT NULL
) ENGINE = innodb
MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key