Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

安装纯绿色开心农场的 时候 sql运行错误

[复制链接]
yese520 发表于 2009-12-8 08:54:05 | 显示全部楼层 |阅读模式
郁闷啊 ,我下载了纯绿色的开心农场  里面要求运行这段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
哪个好心人帮帮忙!!!!!!!!!!!!!!!!!!!
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-20 11:28 , Processed in 0.020862 second(s), 3 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表