Creating the user table again, any ideas?

[Giveit2u43]

Try this query instead:

CREATE TABLE user (
'userid' int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
'usergroupid' smallint(5) unsigned DEFAULT '0' NOT NULL,
'username' varchar(50) NOT NULL,
'password' varchar(50) NOT NULL,
'email' varchar(50) NOT NULL,
'styleid' smallint(5) unsigned DEFAULT '0' NOT NULL,
'parentemail' varchar(50) NOT NULL,
'coppauser' smallint(6) DEFAULT '0' NOT NULL,
'homepage' varchar(100) NOT NULL,
'icq' varchar(20) NOT NULL,
'aim' varchar(20) NOT NULL,
'yahoo' varchar(20) NOT NULL,
'signature' mediumtext NOT NULL,
'adminemail' smallint(6) DEFAULT '0' NOT NULL,
'showemail' smallint(6) DEFAULT '0' NOT NULL,
'invisible' smallint(6) DEFAULT '0' NOT NULL,
'usertitle' varchar(250) NOT NULL,
'customtitle' smallint(6) DEFAULT '0' NOT NULL,
'joindate' int(10) unsigned DEFAULT '0' NOT NULL,
'cookieuser' smallint(6) DEFAULT '0' NOT NULL,
'daysprune' smallint(6) DEFAULT '0' NOT NULL,
'lastvisit' int(10) unsigned DEFAULT '0' NOT NULL,
'lastactivity' int(10) unsigned DEFAULT '0' NOT NULL,
'lastpost' int(10) unsigned DEFAULT '0' NOT NULL,
'posts' smallint(5) unsigned DEFAULT '0' NOT NULL,
'timezoneoffset' varchar(4) NOT NULL,
'emailnotification' smallint(6) DEFAULT '0' NOT NULL,
'buddylist' mediumtext NOT NULL,
'ignorelist' mediumtext NOT NULL,
'pmfolders' mediumtext NOT NULL,
'receivepm' smallint(6) DEFAULT '0' NOT NULL,
'emailonpm' smallint(6) DEFAULT '0' NOT NULL,
'pmpopup' smallint(6) DEFAULT '0' NOT NULL,
'avatarid' smallint(6) DEFAULT '0' NOT NULL,
'options' smallint(6) DEFAULT '15' NOT NULL,
'birthday' date DEFAULT '0000-00-00' NOT NULL,
'maxposts' smallint(6) DEFAULT '-1' NOT NULL,
'startofweek' smallint(6) DEFAULT '1' NOT NULL,
'ipaddress' varchar(20) NOT NULL,
'referrerid' int(10) unsigned DEFAULT '0' NOT NULL,
'nosessionhash' smallint(6) DEFAULT '0' NOT NULL,
'inforum' SMALLINT UNSIGNED DEFAULT '0' not null,
PRIMARY KEY ('userid'),
KEY 'usergroupid' ('usergroupid'),
KEY 'username' ('username'),
KEY `inforum` (`inforum`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

I often find SQL doesn`t like it when the names aren`t in quotes