升级mysql错误_Mysql 执行升级语句出错

DROPTABLEIFEXISTS`bbs_vip_members`;CREATETABLE`bbs_vip_members`(`uid`mediumint(8)unsignedNOTNULLauto_increment,`username`char(15)default'',`groupid`smallint(6)default'0',...

DROP TABLE IF EXISTS `bbs_vip_members`;

CREATE TABLE `bbs_vip_members` (

`uid` mediumint(8) unsigned NOT NULL auto_increment,

`username` char(15) default '',

`groupid` smallint(6) default '0',

`vip` int(10) default '0',

`level` int(10) default '0',

`exp` int(10) default '0',

`tiem` int(10) default '0',

PRIMARY KEY (`uid`),

) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=gbk;

DROP TABLE IF EXISTS `cdb_vipsetting`;

CREATE TABLE `cdb_vipsetting` (

`level` int(10) NOT NULL auto_increment,

`name` char(10) default 0,

`v1` mediumint(2) default 0,

`v2` mediumint(2) default 0,

`v3` mediumint(2) default 0,

`v4` mediumint(2) default 0,

`v5` mediumint(2) default 0,

`v6` mediumint(2) default 0,

PRIMARY KEY (`level`)

) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;

INSERT INTO `cdb_vipsetting` VALUES ('1', 'VIP1', '1', '0', '0', '0', '0', '0');

INSERT INTO `cdb_vipsetting` VALUES ('2', 'VIP2', '1', '1', '0', '0', '0', '0');

INSERT INTO `cdb_vipsetting` VALUES ('3', 'VIP3', '1', '1', '1', '0', '0', '0');

INSERT INTO `cdb_vipsetting` VALUES ('4', 'VIP4', '1', '1', '1', '1', '0', '0');

INSERT INTO `cdb_vipsetting` VALUES ('5', 'VIP5', '1', '1', '1', '1', '1', '0');

INSERT INTO `cdb_vipsetting` VALUES ('6', 'VIP6', '1', '1', '1', '1', '1', '1');

INSERT INTO cdb_crons VALUES ('','1','uesr','成长体系','vip.inc.php','1210308719','1210348800','-1','-1','0','0');

以上是升级语句

以下是错误提示

升级错误，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 ') ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=gbk' at line 1 ，请返回。

展开