[SOLVED] Create Table query error

[MasterACE14]

Hi Guys,

 

I am trying to create a table in PHPMyAdmin, I've created 4 other tables in this database the same way and they all worked. But this query I'm trying to run doesn't want to work, and I have no idea why?

 

Any help is greatly appreciated.

 

Error

 

SQL query:

 

CREATE TABLE `rf_users` (

`id` int( 100 ) unsigned NOT NULL AUTO_INCREMENT ,

`username` varchar( 50 ) NOT NULL default '',

`password` varchar( 50 ) NOT NULL default '',

`email` varchar( 100 ) NOT NULL default '',

`regdate` datetime NOT NULL default '0000-00-00 00:00:00',

`onlinetime` datetime NOT NULL default '0000-00-00 00:00:00',

`authlevel` int( 10 ) unsigned NOT NULL default '0',

`postcount` int( 100 ) unsigned NOT NULL default '0' PRIMARY KEY ( `id` )

) TYPE = MYISAM

 

MySQL said: Documentation

#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`)

) TYPE=MyISAM' at line 10

 

Regards ACE

 

EDIT: after 2 hours, I finally got it. So simple too :S needed a comma after default '0' in post count.