Adding Fields to Tables

[mkabwilliams]

Hi I'm trying to add tables to my database using phpmyadmin on my mysql but i keep getting this 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 ')' at line 13

 

Here is the SQL im trying to run

 

 CREATE TABLE `xoops_users` (
`pn_thold` tinyint( 1 ) NOT NULL default '0',
`pn_noscore` tinyint( 1 ) NOT NULL default '0',
`pn_ublockon` tinyint( 1 ) NOT NULL default '0',
`pn_ublock` text COLLATE latin1_general_ci NOT NULL ,
`pn_theme` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`pn_commentmax` int( 11 ) NOT NULL default '4096',
`pn_counter` int( 11 ) NOT NULL default '0',
`pn_timezone_offset` float( 3, 1 ) NOT NULL default '0.0',
`pn_femail` varchar( 60 ) COLLATE latin1_general_ci NOT NULL default '',
`pn_user_theme` tinyint( 3 ) default NULL ,
`pn_storynum` tinyint( 4 ) NOT NULL default '10',
) 

[Yesideez]

Try removing the comma at the end of line 13.

[fenway]

That is, the trailing comma before the close paren.