Error in SQL query
hi
i am getting an error when i am trying to add this code . can any one fix it for me ?
PHP Code:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` varchar(50) NOT NULL default '',
`homepage` varchar(100) NOT NULL default '',
`icq` varchar(20) NOT NULL default '',
`aim` varchar(20) NOT NULL default '',
`yahoo` varchar(32) NOT NULL default '',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`timezoneoffset` varchar(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`birthday` varchar(10) NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` varchar(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`passworddate` date NOT NULL default '0000-00-00',
`salt` char(3) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`msn` varchar(100) NOT NULL default '',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`membergroupids` varchar(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`languageid` smallint(5) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`birthday_search` date NOT NULL default '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`skype` varchar(32) NOT NULL default '',
`adminoptions` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`)
) ENGINE=MyISAM AUTO_INCREMENT=36472 DEFAULT CHARSET=latin1;
PHP Code:
Error
SQL query:
CREATE TABLE `user` ( `userid` int(10) unsigned NOT NULL auto_increment, `membergroupids` varchar(250) NOT NULL default '', `displaygroupid` smallint(5) unsigned NOT NULL default '0', `password` varchar(32) NOT NULL default '', `passworddate` date NOT NULL default '0000-00-00', `email` varchar(100) NOT NULL default '', `styleid` smallint(5) unsigned NOT NULL default '0', `parentemail` varchar(50) NOT NULL default '', `homepage` varchar(100) NOT NULL default '', `icq` varchar(20) NOT NULL default '', `aim` varchar(20) NOT NULL default '', `yahoo` varchar(32) NOT NULL default '', `msn` varchar(100) NOT NULL default '', `skype` varchar(32) NOT NULL default '', `showvbcode` smallint(5) unsigned NOT NULL default '0', `showbirthday` smallint(5) unsigned NOT NULL default '2', `usertitle` varchar(250) NOT NULL default '', `customtitle` smallint(6) NOT NULL default '0', `joindate` int(10) unsigned NOT NULL default '0', `daysprune` sm[...]
MySQL said:
#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 ')ENGINE=MyISAM DEFAULT CHARSET='latin1'' at line 130
Thanks & Regards
|
01-21-2009, 06:57 PM
Threaded Mode