[capslock]

this is the error:
Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE `teams` (
`teamid` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`posts` tinyint(10) NOT NULL default '0',
`reputation` tinyint(10) NOT NULL default '0',
`avatarurl` varchar(100) NOT NULL default 'images/teamavatars/no-avatar.gif',
`words` text NOT NULL,
`adminmsg` text NOT NULL,
`ircserver` varchar(50) NOT NULL default '',
`ircport` int(4) NOT NULL default '6667',
`chan` varchar(50) NOT NULL default '',
`chanpass` varchar(50) NOT NULL default '',
`notes` text NOT NULL,
`email` varchar(100) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`teamid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 18

mysql error number: 1064

Date: Friday 03rd of December 2004 05:57:07 PM