Nu moins :)
Tev jāievieto tas PRIMARY KEY ( `id` ) tur kur Grey_Wolf ir norādījis.
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,
PRIMARY KEY ( `id` )
) ENGINE = innodb