|
BigDump: Staggered MySQL Dump Importer ver. 0.19b
Processing file: user.sql
Starting at the line: 1
Error at the line 53: ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
Query: 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', `importuserid` bigint(20) NOT NULL default '0', PRIMARY KEY (`userid`), KEY `usergroupid` (`usergroupid`), KEY `username` (`username`), KEY `birthday` (`birthday`), KEY `birthday_search` (`birthday_search`) ) ENGINE=MyISAM AUTO_INCREMENT=87192 DEFAULT CHARSET=latin1;
MySQL: 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 'DEFAULT CHARSET=latin1' at line 52
Stopped on error
|
|