我也碰到这个问题!最新版本的脚本写的有问题,
这个是我自己修改的,给你参考一下!
DROP TABLE IF EXISTS `uchome_qqfarm_config`;
CREATE TABLE `uchome_qqfarm_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`username` varchar(20) NOT NULL,
`money` int(11) DEFAULT '0',
`YB` int(11) DEFAULT '0',
`JB` int(11) DEFAULT '0',
`Message` text NOT NULL,
`setting1` text NOT NULL,
`setting2` text NOT NULL,
`setting3` text NOT NULL,
`setting4` text NOT NULL,
`setting5` text NOT NULL,
`setting6` text NOT NULL,
`pf` int(11) DEFAULT '0',
`vip` int(11) DEFAULT '1',
`tianqi` int(11) NOT NULL DEFAULT '1',
`exchange` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `uchome_qqfarm_mc`;
CREATE TABLE `uchome_qqfarm_mc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`Status` text NOT NULL,
`exp` int(11) DEFAULT '0',
`taskid` int(11) NOT NULL,
`package` text NOT NULL,
`tools` text NOT NULL,
`decorative` text NOT NULL,
`bad` text NOT NULL,
`badnum` int(11) NOT NULL,
`badtime` int(11) NOT NULL DEFAULT '0',
`parade` text NOT NULL,
`repertory` text NOT NULL,
`dabian` tinyint(4) NOT NULL,
`sfeedleft` int(11) NOT NULL DEFAULT '30',
`zong` mediumint(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `uchome_qqfarm_mclogs`;
CREATE TABLE `uchome_qqfarm_mclogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` tinyint(4) NOT NULL,
`uid` int(11) NOT NULL,
`fromid` int(11) NOT NULL,
`count` text NOT NULL,
`iid` text NOT NULL,
`money` text NOT NULL,
`isread` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `uchome_qqfarm_nc`;
CREATE TABLE `uchome_qqfarm_nc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`Status` text NOT NULL,
`reclaim` int(11) NOT NULL DEFAULT '6',
`exp` int(11) NOT NULL DEFAULT '0',
`taskid` int(11) NOT NULL DEFAULT '0',
`package` text,
`flower` text,
`fruit` text,
`tools` text,
`decorative` text,
`dog` text,
`Weed` text,
`pest` text,
`water` text,
`badnum` int(11) NOT NULL DEFAULT '50',
`activeItem` int(11) NOT NULL DEFAULT '90001',
`repertory` text NOT NULL,
`log` text NOT NULL,
`healthmode` text NOT NULL,
`chris` int(11) NOT NULL DEFAULT '0',
`zong` mediumint(9) NOT NULL DEFAULT '0',
`mc_a` tinyint(3) unsigned NOT NULL DEFAULT '0',
`nc_d` int(1) NOT NULL DEFAULT '1',
`nc_e` int(11) NOT NULL DEFAULT '0',
`levelup` int(11) NOT NULL DEFAULT '200',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk; |