帮帮忙

安装开心农场时第一步执行SQL就犯难了。。

错误
SQL 查询:

CREATE TABLE `uchome_plug_newfarm` (

`uid` mediumint( 8 ) NOT NULL ,
`farmlandstatus` text CHARACTER SET utf8 NOT NULL ,
`animal` text CHARACTER SET utf8 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 utf8 NOT NULL ,
`mc_package` text CHARACTER SET utf8 NOT NULL ,
`fertilizer` text CHARACTER SET utf8 NOT NULL ,
`decorative` text CHARACTER SET utf8 NOT NULL ,
`fruit` text CHARACTER SET utf8 NOT NULL ,
`dog` text CHARACTER SET utf8 NOT NULL ,
`nosegay` text CHARACTER SET utf8 NOT NULL ,
`message` text CHARACTER SET utf8 NOT NULL ,
`mc_taskid` int( 2 ) NOT NULL default '0',
`mc_taskid1` int( 2 ) NOT NULL default '0',
`mc_log` text CHARACTER SET utf8 NOT NULL ,
`log` text CHARACTER SET utf8 NOT NULL ,
PRIMARY KEY ( `uid` )
) ENGINE = MYISAM DEFAULT CHARSET = gbk;



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 utf8 NOT NULL,
  `animal` text character set utf



怎么办？

MYSQL版本是4.0.26