Codezwiz >> Forums >> General PHP Nuke Help >> Problem creating a user table in MYSQL

Im trying to create a user table with the following code but i get this error message can some tell me what is wrong.

create table users (id int(5) key auto_increment not null,
username varchar(30) not null,
password varchar(50) not null,
email varchar(80) DEFAULT "System",
accesslevel int(1) not null DEFAULT 1,
rank int(1) not null DEFAULT 1,
credit int(20) not null DEFAULT 0,
addedby int(5) not null DEFAULT 0,
lastlogin int(20) not null,
active bool not null DEFAULT true,
);

this is the error

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'key auto_increment not null,
username varchar(30) not nu

Im running mysql 4

Try this:

create table users
(
id int(5) not null KEY auto_increment,
username varchar(30) not null,
password varchar(50) not null,
email varchar(80) DEFAULT 'System',
accesslevel int(1) not null DEFAULT '1',
rank int(1) not null DEFAULT '1',
credit int(20) not null DEFAULT '0',
addedby int(5) not null DEFAULT '0',
lastlogin int(20) not null,
active bool NOT NULL DEFAULT 'true'
)

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY auto_increment,
username varchar(30) not null,
password

Originally posted by DirtySnipe @ Fri Mar 17, 2006 9:14 pm:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY auto_increment,
username varchar(30) not null,
password

I think you are going to need to google that. I was able to run that query successfully from myadmin. Maybe you mysql version?