回复 27# 绝对疯子 - SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- 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,
- `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(1) NOT NULL DEFAULT '0',
- `levelup` int(11) NOT NULL DEFAULT '200',
- `flower` text,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
复制代码 这个是全新安装数据库,看清了 |