SQL error check

[Hobbes]

alright im really illiterate, please forgive me filburt1....least i'm not PMing you XD!

anyway...

i ran...

[sql]CREATE TABLE `useralias` ( `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `alias` VARCHAR(50) NOT NULL DEFAULT '0' ); [/sql]

and got...

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `useralias` ( `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `alias` VARCHAR(50) NOT NULL DEFAULT '0' );
mysql error: You have an error in your SQL syntax near '; ' at line 1

mysql error number: 1064[/sql]

*dies*


also, i tried putting the DEFAULT 0 befor NOT NULL in both instances and still no luck :bunny: