回复 1502# iiiuuuiii - SET names '{dbcharset}';
- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- DROP TABLE IF EXISTS `{tablepre}qqfarm_config`;
- CREATE TABLE `{tablepre}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={dbcharset};
- DROP TABLE IF EXISTS `{tablepre}qqfarm_mc`;
- CREATE TABLE `{tablepre}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={dbcharset};
- DROP TABLE IF EXISTS `{tablepre}qqfarm_mclogs`;
- CREATE TABLE `{tablepre}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={dbcharset};
- DROP TABLE IF EXISTS `{tablepre}qqfarm_nc`;
- CREATE TABLE `{tablepre}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={dbcharset};
复制代码 导入3.2的4个表到数据库就行了 |