Ok, here is what I get when I run the query.
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 newmessage
int(4) unsigned NOT NULL DEFAULT0
,companyi' at line 4
Here is what it says is wrong.
CREATE TABLE `user` ( `userid` char(50) NOT NULL default '', `password` char(12) NOT NULL default '', `lastlogin` timestamp(14) NOT NULL, `newmessage`int(4) unsigned NOT NULL DEFAULT `0`, `companyid` char(10) default NULL, `departmentid` char(10) default NULL, `status` char(50) default NULL, PRIMARY KEY (`userid`), KEY `loginuser` (`userid`,`lastlogin`) ) ENGINE=MyISAM;
It is very frustrating because I know it is going to be something simple. Any suggestions would be greatly appreciated.