原帖由 joykiller 于 2006-9-12 19:37 发表
升级错误,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=gbk AUTO_INCREMENT=2' at ...
DROP TABLE IF EXISTS cdb_paymoney;
CREATE TABLE `cdb_paymoney` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`username` char(15) NOT NULL default '',
`basic` int(10) unsigned NOT NULL default '0',
`online` int(10) unsigned NOT NULL default '0',
`notonlinetime` int(10) unsigned NOT NULL default '0',
`salarydelete` int(10) unsigned NOT NULL default '0',
`salarymove` int(10) unsigned NOT NULL default '0',
`salaryhighlight` int(10) unsigned NOT NULL default '0',
`salaryclose` int(10) unsigned NOT NULL default '0',
`salarystick` int(10) unsigned NOT NULL default '0',
`salarydigest` int(10) unsigned NOT NULL default '0',
`salarytype` int(10) unsigned NOT NULL default '0',
`salaryedit` int(10) unsigned NOT NULL default '0',
`salarypostdel` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM; |