郁闷啊 ,我下载了纯绿色的开心农场 里面要求运行这段sql
主数据库SQL:
CREATE TABLE `uchome_plug_newfarm` (
`uid` mediumint(8) NOT NULL,
`farmlandstatus` text character set gbk NOT NULL,
`animal` text character set gbk NOT NULL,
`taskid` int(2) NOT NULL default '1',
`charm` int(10) NOT NULL default '0',
`money` int(10) NOT NULL default '0',
`exp` int(10) NOT NULL default '0',
`mc_exp` int(10) NOT NULL default '0',
`fb` int(10) NOT NULL default '0',
`reclaim` smallint(2) NOT NULL default '6',
`package` text character set gbk NOT NULL,
`mc_package` text character set gbk NOT NULL,
`fertilizer` text character set gbk NOT NULL,
`decorative` text character set gbk NOT NULL,
`fruit` text character set gbk NOT NULL,
`dog` text character set gbk NOT NULL,
`nosegay` text character set gbk NOT NULL,
`message` text character set gbk NOT NULL,
`mc_taskid` int(2) NOT NULL default '0',
`mc_taskid1` int(2) NOT NULL default '0',
`mc_log` text character set gbk NOT NULL,
`mc_chat` text character set gbk NOT NULL,
`wenzi` text character set gbk NOT NULL,
`log` text character set gbk NOT NULL,
`bad` text character set gbk NOT NULL,
`repertory` text character set gbk NOT NULL,
`expLimit` VARCHAR(30) NOT NULL DEFAULT '',
`parade` text character set gbk NOT NULL,
`dabian` TINYINT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
===========================
日志部分SQL:
先执行
CREATE TABLE `uchome_plug_newfarm_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`count` tinyint(4) NOT NULL,
`fromid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`cropid` int(11) NOT NULL,
`isread` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
再执行
update uchome_plug_newfarm set log="";
===========================
VIP部分SQL:
CREATE TABLE `uchome_plug_newfarm_vip` (
`uid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`level` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`vipstatus` TINYINT UNSIGNED NOT NULL DEFAULT 0,
`validtime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`jointime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`vippoint` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`endtime` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`rsign` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`uid`)
)
ENGINE=MyISAM DEFAULT CHARSET=gbk;
可是一开始运行,就提示错误,大家看看是怎么回事嘛 我菜鸟一个,实在不懂,请求帮忙
错误
SQL 查询:
CREATE TABLE `uchome_plug_newfarm` ( `uid` mediumint(8) NOT NULL, `farmlandstatus` text character set gbk NOT NULL, `animal` text character set gbk NOT NULL, `taskid` int(2) NOT NULL default '1', `charm` int(10) NOT NULL default '0', `money` int(10) NOT NULL default '0', `exp` int(10) NOT NULL default '0', `mc_exp` int(10) NOT NULL default '0', `fb` int(10) NOT NULL default '0', `reclaim` smallint(2) NOT NULL default '6', `package` text character set gbk NOT NULL, `mc_package` text character set gbk NOT NULL, `fertilizer` text character set gbk NOT NULL, `decorative` text character set gbk NOT NULL, `fruit` text character set gbk NOT NULL, `dog` text character set gbk NOT NULL, `nosegay` text character set gbk NOT NULL, `message` text character set gbk NOT NULL, `mc_taskid` int(2) NOT NULL default '0', `mc_taskid1` int(2) NOT NULL default '0', `mc_log` text character set gbk NOT NULL, `mc_chat` text character set gbk NOT[...]
MySQL 返回:
#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 'character set gbk NOT NULL,
`animal` text character set gbk
哪个好心人帮帮忙!!!!!!!!!!!!!!!!!!! |