谢谢楼上的大侠,呵呵
以下是uchome_plug_newfarm.txt的内容
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,
`log` text character set gbk NOT NULL,
`wenzi` text character set gbk NOT NULL,
`bad` INT(11) NOT NULL,
`MC_CHAT` text character set gbk NOT NULL,
`repertory` text character set gbk NOT NULL,
`expLimit` VARCHAR(30) NOT NULL DEFAULT '',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |