#1 SQL Error

[Ian Roynon]

Upon running the SQL file (both Patched and Unpatched
versions) on PHPMyAdmin it throws up the error:

Error

SQL-query :

CREATE TABLE players(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
user varchar( 15 ) NOT NULL default '',
email varchar( 60 ) NOT NULL default '',
pass varchar( 15 ) NOT NULL default '',
rank varchar( 10 ) NOT NULL default 'Member',
LEVEL int( 11 ) NOT NULL default '1',
exp int( 11 ) NOT NULL default '0',
credits int( 11 ) NOT NULL default '1000',
energy double( 11, 2 ) NOT NULL default '5.00',
max_energy double( 11, 2 ) NOT NULL default '5.00',
strength double( 11, 3 ) NOT NULL default '3.000',
agility double( 11, 3 ) NOT NULL default '3.000',
ap int( 11 ) NOT NULL default '3',
age int( 11 ) NOT NULL default '1',
logins int( 11 ) NOT NULL default '0',
hp int( 11 ) NOT NULL default '15',
max_hp int( 11 ) NOT NULL default '15',
lpv bigint( 20 ) NOT NULL default '0',
page varchar( 100 ) NOT NULL default '',
ip varchar( 50 ) NOT NULL default '',
bank int( 50 ) NOT NULL default '0' UNIQUE KEY id( id )
) TYPE = MYISAM

MySQL said:

#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 'id (id)
) TYPE=MyISAM' at line 23

[Ian Roynon]

Logged In: YES
user_id=850917

Follow up:
I created the table by hand and then went to PHPMYAdmin
and exported it and it produced following SQL code
forcreated table:

CREATE TABLE `players` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(15) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`pass` varchar(15) NOT NULL default '',
`rank` varchar(10) NOT NULL default 'member',
`level` int(11) NOT NULL default '1',
`exp` int(11) NOT NULL default '0',
`credits` int(11) NOT NULL default '1000',
`energy` double(11,2) NOT NULL default '5.00',
`max_energy` double(11,2) NOT NULL default '5.00',
`strength` double(11,3) NOT NULL default '3.000',
`agility` double(11,3) NOT NULL default '3.000',
`ap` int(11) NOT NULL default '3',
`age` int(11) NOT NULL default '1',
`logins` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '15',
`max_hp` int(11) NOT NULL default '15',
`lpv` bigint(20) NOT NULL default '0',
`page` varchar(100) NOT NULL default '',
`ip` int(50) NOT NULL default '0',
`bank` int(50) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Dont ask me why this works and other didnt because i cant
see any real difference myself, but that works for me.

I just thought i would report my findings if there are any bugs
or if anyone else gets same problems.

IaN

[Nobody/Anonymous]

Logged In: NO

I tried this and the error is after;
bank int( 50 ) NOT NULL default '0'
You forgot to include the ",".