SQL error check

[Hobbes]

ok i ran

[sql]CREATE TABLE `useralias` ( `userid` INT(10) UNSIGNED NOT NULL DEFAULT '0' , `alias` VARCHAR(50) NOT NULL ); [/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 );
mysql error: You have an error in your SQL syntax near '; ' at line 1

mysql error number: 1064[/sql]