kknongchang_2506/database/online.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 47.96.0.212.56
 Source Server Type    : MySQL
 Source Server Version : 50651 (5.6.51)
 Source Host           : 47.96.0.212:3356
 Source Schema         : online

 Target Server Type    : MySQL
 Target Server Version : 50651 (5.6.51)
 File Encoding         : 65001

 Date: 22/04/2025 13:36:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


-- ----------------------------
-- Table structure for dhc_article_raiders
-- ----------------------------
DROP TABLE IF EXISTS `dhc_article_raiders`;
CREATE TABLE `dhc_article_raiders` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `operator` int(11) DEFAULT NULL COMMENT '操作员id',
  `auth` varchar(100) NOT NULL COMMENT '用户帐号',
  `title` varchar(100) NOT NULL COMMENT '攻略标题',
  `content` longtext NOT NULL COMMENT '攻略内容',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '审核状态',
  `createtime` int(11) unsigned NOT NULL COMMENT '发表日期',
  `readtimes` int(11) unsigned DEFAULT '1' COMMENT '阅读次数',
  `reward` int(11) unsigned DEFAULT '0' COMMENT '打赏',
  `praise` int(11) unsigned DEFAULT '0' COMMENT '好评',
  `comments` int(11) unsigned DEFAULT '0' COMMENT '中评',
  `bad` int(11) unsigned DEFAULT '0' COMMENT '差评',
  `type` tinyint(4) NOT NULL COMMENT '阅读类型',
  `reason` varchar(100) DEFAULT '' COMMENT '审核原因',
  `rewardproduct` int(11) DEFAULT NULL COMMENT '打赏产品',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='攻略表';


-- ----------------------------
-- Table structure for dhc_card_collect_activity
-- ----------------------------
DROP TABLE IF EXISTS `dhc_card_collect_activity`;
CREATE TABLE `dhc_card_collect_activity` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `apple` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '苹果数量',
  `pumpkin` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '南瓜数量',
  `radish` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '萝卜',
  `pepper` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '辣椒',
  `strawberry` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '草莓',
  `reunion` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '团圆',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `type` (`apple`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8165 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_card_collect_num
-- ----------------------------
DROP TABLE IF EXISTS `dhc_card_collect_num`;
CREATE TABLE `dhc_card_collect_num` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `num` int(11) unsigned NOT NULL COMMENT '次数',
  `real_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动期间实名人数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;




-- ----------------------------
-- Table structure for dhc_distribution_list
-- ----------------------------
DROP TABLE IF EXISTS `dhc_distribution_list`;
CREATE TABLE `dhc_distribution_list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL,
  `cUid` int(11) unsigned NOT NULL COMMENT '下级uid',
  `level` tinyint(1) unsigned NOT NULL COMMENT '层级',
  `gold` float(11,4) NOT NULL COMMENT '金币变化',
  `type` tinyint(1) unsigned NOT NULL COMMENT '返佣类型: 兑换钻石=1 大盘手续费=2',
  `disType` enum('common','channel') NOT NULL COMMENT '分销商类型1',
  `rebate` float(11,2) unsigned NOT NULL COMMENT '当前分佣比例',
  `amount` float(11,4) unsigned NOT NULL COMMENT '佣金数量',
  `effectTime` int(11) unsigned NOT NULL COMMENT '生效时间',
  `createTime` int(11) unsigned NOT NULL COMMENT '创建时间',
  `updateTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '领取时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=未到账 1=已到账',
  `log` varchar(255) NOT NULL COMMENT '日志备注',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `createTime` (`createTime`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_game_commodity
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_commodity`;
CREATE TABLE `dhc_game_commodity` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gid` int(11) unsigned NOT NULL COMMENT '果实id',
  `gname` varchar(255) NOT NULL COMMENT '果实名称',
  `price` decimal(10,3) unsigned NOT NULL COMMENT '市场单价',
  `min_buy_price` decimal(10,3) NOT NULL COMMENT '最低购买价格',
  `max_num` int(11) unsigned NOT NULL COMMENT '单笔订单最大值',
  `total_num` int(11) NOT NULL COMMENT '历史成交数量',
  `flow_num` int(11) NOT NULL COMMENT '可交易数量',
  `del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除0否1是',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='交易市场商品指导价格';

-- ----------------------------
-- Table structure for dhc_game_notice
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_notice`;
CREATE TABLE `dhc_game_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '公告内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='游戏公告(新)';

-- ----------------------------
-- Table structure for dhc_game_transaction
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_transaction`;
CREATE TABLE `dhc_game_transaction` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `gid` int(11) NOT NULL COMMENT '果实id',
  `num` int(11) unsigned NOT NULL COMMENT '果实数量',
  `gname` varchar(20) NOT NULL DEFAULT '0' COMMENT '果实名称',
  `price` decimal(10,3) unsigned NOT NULL COMMENT '果实单价',
  `total_price` decimal(10,3) NOT NULL COMMENT '真实总价',
  `actual_price` int(10) NOT NULL COMMENT '整数总价',
  `type` tinyint(1) NOT NULL COMMENT '类型0买如1卖出',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态0待审核1已完成2已撤销',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `u` (`uid`,`gid`) USING BTREE,
  KEY `gid` (`gid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=269753 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='农贸市场订单表';

-- ----------------------------
-- Table structure for dhc_game_transaction_err_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_transaction_err_log`;
CREATE TABLE `dhc_game_transaction_err_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(1000) NOT NULL COMMENT '日志内容',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='计划任务有错误内容时存储表';

-- ----------------------------
-- Table structure for dhc_game_transaction_statistics
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_transaction_statistics`;
CREATE TABLE `dhc_game_transaction_statistics` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ymd` int(11) NOT NULL COMMENT '时间',
  `k_sell` int(11) NOT NULL DEFAULT '0' COMMENT '卖出k钻的数量',
  `k_buy` int(11) NOT NULL DEFAULT '0' COMMENT '买入k钻的数量',
  `content` text NOT NULL COMMENT '果实相关数据',
  `create_at` date NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ymd` (`ymd`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_game_video
-- ----------------------------
DROP TABLE IF EXISTS `dhc_game_video`;
CREATE TABLE `dhc_game_video` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL COMMENT '视频标题',
  `content` varchar(255) NOT NULL COMMENT '内容',
  `author` varchar(20) NOT NULL COMMENT '作者',
  `img_url` varchar(255) NOT NULL COMMENT '图片地址',
  `video_url` varchar(255) NOT NULL COMMENT '视频地址',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型1游戏攻略',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_k
-- ----------------------------
DROP TABLE IF EXISTS `dhc_k`;
CREATE TABLE `dhc_k` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `surplus` int(11) unsigned NOT NULL COMMENT '剩余k钻',
  `retained` int(11) unsigned NOT NULL COMMENT '平台留存k钻',
  `consume` int(11) unsigned NOT NULL COMMENT '用户消耗k钻',
  `produce` int(11) unsigned NOT NULL COMMENT '用户持有k钻',
  `release` int(11) unsigned NOT NULL COMMENT '平台释放k钻',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='平台k钻数据汇总';

-- ----------------------------
-- Table structure for dhc_lnvitation_code
-- ----------------------------
DROP TABLE IF EXISTS `dhc_lnvitation_code`;
CREATE TABLE `dhc_lnvitation_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` char(20) NOT NULL COMMENT '邀请码',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被使用0否1是',
  `time` datetime DEFAULT NULL COMMENT '使用时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='内测邀请码(新)';

-- ----------------------------
-- Table structure for dhc_menus
-- ----------------------------
DROP TABLE IF EXISTS `dhc_menus`;
CREATE TABLE `dhc_menus` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  `title` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_message_error_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_message_error_log`;
CREATE TABLE `dhc_message_error_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(255) NOT NULL COMMENT '内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6656 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='短信发送失败日志表';

-- ----------------------------
-- Table structure for dhc_operator_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_operator_log`;
CREATE TABLE `dhc_operator_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `title` varchar(255) NOT NULL COMMENT '操作内容',
  `operator` int(11) NOT NULL COMMENT '操作员',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='后台操作员操作日志';

-- ----------------------------
-- Table structure for dhc_orchard_animal
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_animal`;
CREATE TABLE `dhc_orchard_animal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `aid` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `nums` int(11) unsigned NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL,
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  `days` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '剩余天数',
  `info` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `feedtime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `feednums` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`,`aid`,`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='农场 牧场信息表';

-- ----------------------------
-- Table structure for dhc_orchard_background
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_background`;
CREATE TABLE `dhc_orchard_background` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `backId` tinyint(11) unsigned NOT NULL DEFAULT '1',
  `backName` varchar(50) NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`backId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44986 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='果园背景管理';

-- ----------------------------
-- Table structure for dhc_orchard_chest
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_chest`;
CREATE TABLE `dhc_orchard_chest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `tId` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `nums` int(11) unsigned NOT NULL DEFAULT '0',
  `price` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '钻石价格',
  `uidStr` varchar(500) DEFAULT NULL COMMENT '会员信息',
  `starttime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`tId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='宝箱记录';

-- ----------------------------
-- Table structure for dhc_orchard_chestlist
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_chestlist`;
CREATE TABLE `dhc_orchard_chestlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned DEFAULT '0',
  `tId` int(11) unsigned DEFAULT '0',
  `cid` int(11) unsigned DEFAULT '0',
  `disUid` int(11) unsigned DEFAULT '0',
  `price` decimal(11,2) unsigned DEFAULT '0.00',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `starttime` int(11) unsigned DEFAULT '0' COMMENT '开始时间',
  `endtime` int(11) unsigned DEFAULT '0',
  `createtime` int(11) unsigned DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  `isRed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`tId`,`cid`,`createtime`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='宝箱邀请记录表';

-- ----------------------------
-- Table structure for dhc_orchard_config
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_config`;
CREATE TABLE `dhc_orchard_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `total` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '库存种子',
  `diamond` text NOT NULL COMMENT '果实兑换钻石信息',
  `upGrade` tinyint(2) unsigned NOT NULL DEFAULT '12' COMMENT '用户最高等级',
  `landInfo` text NOT NULL COMMENT '土地信息',
  `landFruit` varchar(500) NOT NULL DEFAULT '0' COMMENT '产生果实信息',
  `landUpInfo` varchar(600) NOT NULL DEFAULT '0' COMMENT '土地升级信息',
  `duiInfo` varchar(500) NOT NULL DEFAULT '0' COMMENT '兑换设置',
  `houseInfo` text NOT NULL COMMENT '房屋升级耗材',
  `dogInfo` text NOT NULL COMMENT '宠物升级经验信息',
  `statueInfo` varchar(500) NOT NULL DEFAULT '0' COMMENT '神像设置',
  `recharge` varchar(500) NOT NULL DEFAULT '0' COMMENT '充值信息',
  `background` varchar(500) NOT NULL DEFAULT '0' COMMENT '背景信息',
  `rebate` varchar(500) NOT NULL DEFAULT '0' COMMENT '充值返佣金额',
  `package` varchar(300) DEFAULT '0' COMMENT '礼包信息',
  `indemnify` varchar(300) NOT NULL DEFAULT '0' COMMENT '补偿礼包',
  `newGiftPack` varchar(300) DEFAULT NULL COMMENT '新人礼包信息',
  `realName` varchar(500) NOT NULL COMMENT '认证礼包',
  `sign` varchar(500) NOT NULL DEFAULT '0' COMMENT '签到信息',
  `steal` text NOT NULL COMMENT '好友互偷信息',
  `downgrade` text COMMENT '土地降级信息',
  `EMG` varchar(100) DEFAULT NULL COMMENT 'emg授权',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  `Ouid` int(11) unsigned NOT NULL DEFAULT '0',
  `pasture` text NOT NULL COMMENT '牧场信息',
  `SDiamondHave` int(11) unsigned DEFAULT NULL COMMENT '推荐人需拥有钻石',
  `authCodeInfo` varchar(500) DEFAULT NULL COMMENT '商城对接授权信息',
  `team` text NOT NULL COMMENT '推广设置',
  `teamPoster` text NOT NULL COMMENT '推广海报',
  `teamRule` text NOT NULL COMMENT '团队规则',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园参数';

-- ----------------------------
-- Table structure for dhc_orchard_dog
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_dog`;
CREATE TABLE `dhc_orchard_dog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户编号',
  `nickname` varchar(50) NOT NULL COMMENT '用户昵称',
  `mobile` varchar(50) NOT NULL COMMENT '用户电话',
  `goodsId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id或0',
  `dogName` varchar(50) NOT NULL COMMENT '宠物昵称',
  `dogLevel` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '宠物等级',
  `experience` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '宠物经验值',
  `power` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '体力活力动力值',
  `powerUlimit` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '体力生活上限',
  `otherInfo` varchar(500) NOT NULL DEFAULT '0' COMMENT '宠物其他基本信息',
  `harvestTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收货时效',
  `sowingTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '播种时效',
  `speed` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '进度玫瑰1000 规0',
  `score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评分',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `optime` int(11) unsigned NOT NULL DEFAULT '0',
  `isDel` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态 1',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44260 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园宠物记录表';

-- ----------------------------
-- Table structure for dhc_orchard_double_effect
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_double_effect`;
CREATE TABLE `dhc_orchard_double_effect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `types` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
  `mark` varchar(50) NOT NULL DEFAULT '0',
  `nums` int(11) unsigned NOT NULL DEFAULT '0',
  `msg` varchar(500) NOT NULL DEFAULT '0' COMMENT '消息',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `lasttime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '到期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4202 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_orchard_downgrade
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_downgrade`;
CREATE TABLE `dhc_orchard_downgrade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `types` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型 1房屋 2 土地 3记录',
  `houseLv` int(11) unsigned NOT NULL DEFAULT '0',
  `grade` int(11) unsigned NOT NULL DEFAULT '0',
  `htime` int(11) unsigned NOT NULL DEFAULT '0',
  `info` varchar(500) NOT NULL,
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`houseLv`,`grade`,`htime`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='房屋掉级记录';

-- ----------------------------
-- Table structure for dhc_orchard_goods
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_goods`;
CREATE TABLE `dhc_orchard_goods` (
  `tId` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '定义类型',
  `tName` varchar(50) NOT NULL COMMENT '商品名字',
  `depict` varchar(500) NOT NULL COMMENT '商品简介',
  `price` decimal(10,3) unsigned NOT NULL DEFAULT '0.000' COMMENT '商品价格',
  `effect` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '效果值',
  `pack` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '一次性购买量 打包购买',
  `buyOut` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '购买上限',
  `cost` varchar(500) NOT NULL COMMENT '宝箱需要信息',
  `chanceInfo` varchar(2000) NOT NULL COMMENT '各商品概率',
  `giftDetail` varchar(500) NOT NULL COMMENT '推荐礼包详细信息',
  `reclaimLimit` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '会员购买需等级',
  `seedUser` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '赠送种子用户',
  `seedShop` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '返回平台种子数量',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态0禁用1启用',
  `isDel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园商品表';

-- ----------------------------
-- Table structure for dhc_orchard_hail_fellow
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_hail_fellow`;
CREATE TABLE `dhc_orchard_hail_fellow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `huid` int(11) unsigned NOT NULL DEFAULT '0',
  `nickname` varchar(50) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1 通过 0 审核 9 拒绝',
  `isAdd` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发起身份',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  `isDel` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2201 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园好友记录表';

-- ----------------------------
-- Table structure for dhc_orchard_land
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_land`;
CREATE TABLE `dhc_orchard_land` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `nickname` varchar(50) NOT NULL DEFAULT '无昵称',
  `mobile` varchar(50) NOT NULL DEFAULT '0',
  `landLevel` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '土地类型 1普 2红 3 黑 4 金',
  `landId` tinyint(2) NOT NULL DEFAULT '1',
  `goodsId` int(11) NOT NULL DEFAULT '0' COMMENT '产生种子ID',
  `goodsNums` int(11) NOT NULL DEFAULT '0' COMMENT '产生种子数量',
  `goodsName` varchar(50) NOT NULL DEFAULT '无',
  `fertilize` varchar(500) NOT NULL DEFAULT '0' COMMENT '施肥次数状态',
  `plowing` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '翻地状态',
  `landStatus` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '土地状态0未种植1种子2嫩芽期3生长期4成熟期5枯萎期',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次更新时间',
  `optime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户操作时间',
  `seedtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '种子播种时间',
  `wcan` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '浇水状态',
  `hcide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '除草状态',
  `icide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '除虫状态',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid_2` (`uid`,`landId`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45305 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='土地信息';

-- ----------------------------
-- Table structure for dhc_orchard_logs
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_logs`;
CREATE TABLE `dhc_orchard_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `mobile` varchar(50) NOT NULL,
  `disUid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源uid',
  `landId` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '土地编号',
  `types` varchar(50) NOT NULL,
  `nums` decimal(11,2) NOT NULL DEFAULT '0.00',
  `msg` varchar(500) NOT NULL,
  `dataInfo` varchar(5000) NOT NULL DEFAULT '0' COMMENT '附带数据存储',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除1否2是',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `uid_2` (`uid`,`landId`,`types`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5776043 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园日志表';

-- ----------------------------
-- Table structure for dhc_orchard_order
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_order`;
CREATE TABLE `dhc_orchard_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员uid',
  `nickname` varchar(50) NOT NULL COMMENT '会员信息',
  `mobile` varchar(50) NOT NULL COMMENT '会员信息',
  `orderId` varchar(50) NOT NULL COMMENT '订单号',
  `types` varchar(50) NOT NULL COMMENT '类型',
  `coing` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '扣除数量',
  `fruit` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '获得数量',
  `payStatus` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态',
  `payTime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=52899 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='淘金果园订单记录表';

-- ----------------------------
-- Table structure for dhc_orchard_package
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_package`;
CREATE TABLE `dhc_orchard_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL,
  `types` varchar(50) NOT NULL,
  `info` varchar(500) NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='果园礼包';

-- ----------------------------
-- Table structure for dhc_orchard_sign
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_sign`;
CREATE TABLE `dhc_orchard_sign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0',
  `config` varchar(500) NOT NULL DEFAULT '0',
  `signLevel` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `info` varchar(500) NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=163571 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='果园签到记录表';

-- ----------------------------
-- Table structure for dhc_orchard_statue
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_statue`;
CREATE TABLE `dhc_orchard_statue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) NOT NULL COMMENT '神像id',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'uid',
  `model` varchar(50) NOT NULL DEFAULT '0' COMMENT '类型',
  `statueName` varchar(50) NOT NULL DEFAULT '0' COMMENT '名称',
  `nums` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换数量',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `lasttime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid_2` (`uid`,`tid`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='果园神像记录表';

-- ----------------------------
-- Table structure for dhc_orchard_steal
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_steal`;
CREATE TABLE `dhc_orchard_steal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `huid` int(11) NOT NULL,
  `dogInfo` text NOT NULL,
  `dogStatus` tinyint(1) NOT NULL DEFAULT '0' COMMENT '宠物状态',
  `chance` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `mt` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `landInfo` varchar(5000) NOT NULL DEFAULT '0',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22662 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_orchard_user
-- ----------------------------
DROP TABLE IF EXISTS `dhc_orchard_user`;
CREATE TABLE `dhc_orchard_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '会员uid',
  `nickname` varchar(50) NOT NULL DEFAULT '无' COMMENT '昵称',
  `mobile` varchar(50) NOT NULL DEFAULT '0',
  `avatar` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '头像选择id',
  `diamonds` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '钻石',
  `skin` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '皮肤',
  `wood` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '木材',
  `stone` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '石材',
  `steel` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '钢材',
  `grade` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '房屋等级',
  `dogFood1` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '普通狗粮',
  `dogFood2` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优质狗粮2',
  `roseSeed` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '玫瑰花种子',
  `seed` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '普通种子 废弃',
  `choe` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '铜锄头',
  `shoe` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '银锄头',
  `cchest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '铜宝箱',
  `schest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '银宝箱',
  `gchest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '金宝箱',
  `dchest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '钻石宝箱',
  `ccchest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '超级铜宝箱',
  `cschest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '超级银宝箱',
  `cgchest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '超级金宝箱',
  `cfert` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '化肥',
  `wcan` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '洒水壶',
  `hcide` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '除草剂',
  `icide` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '除虫剂',
  `emerald` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '绿宝石',
  `purplegem` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '紫宝石',
  `sapphire` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '蓝宝石',
  `topaz` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '黄宝石',
  `gifts` int(11) NOT NULL DEFAULT '0' COMMENT '推荐礼包个数',
  `kuguazhi` int(11) unsigned NOT NULL DEFAULT '0',
  `feed` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '饲料',
  `pasture` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '牧场等级',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1正常 9 禁用',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45110 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='果园会员信息表';

-- ----------------------------
-- Table structure for dhc_pay
-- ----------------------------
DROP TABLE IF EXISTS `dhc_pay`;
CREATE TABLE `dhc_pay` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `price` decimal(10,2) unsigned NOT NULL COMMENT '价格',
  `num` int(11) unsigned NOT NULL COMMENT '钻石数量',
  `additional` int(11) unsigned NOT NULL COMMENT '赠送的钻石数',
  `all` int(11) NOT NULL COMMENT '钻石总数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户购买钻石列表(新)';

-- ----------------------------
-- Table structure for dhc_raiders_reward
-- ----------------------------
DROP TABLE IF EXISTS `dhc_raiders_reward`;
CREATE TABLE `dhc_raiders_reward` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `rid` int(11) unsigned NOT NULL COMMENT '攻略id',
  `uid` int(11) unsigned NOT NULL COMMENT '打赏用户id',
  `auth` int(11) unsigned NOT NULL COMMENT '作者id',
  `productid` int(11) unsigned NOT NULL COMMENT '打赏产品id',
  `productnum` int(11) unsigned NOT NULL COMMENT '打赏产品数量',
  `createtime` int(11) unsigned NOT NULL COMMENT '打赏时间',
  `discuss` varchar(100) NOT NULL COMMENT '评论',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='打赏记录表';

-- ----------------------------
-- Table structure for dhc_strategy
-- ----------------------------
DROP TABLE IF EXISTS `dhc_strategy`;
CREATE TABLE `dhc_strategy` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL COMMENT '分类id',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `thumb` varchar(255) NOT NULL COMMENT '图片',
  `content` text NOT NULL COMMENT '内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='游戏攻略内容(新)';

-- ----------------------------
-- Table structure for dhc_strategy_category
-- ----------------------------
DROP TABLE IF EXISTS `dhc_strategy_category`;
CREATE TABLE `dhc_strategy_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='游戏攻略分类(新)';

-- ----------------------------
-- Table structure for dhc_test
-- ----------------------------
DROP TABLE IF EXISTS `dhc_test`;
CREATE TABLE `dhc_test` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL COMMENT '测试内容',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8718 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='存放测试数据的表(新)';

-- ----------------------------
-- Table structure for dhc_trade_dailydate
-- ----------------------------
DROP TABLE IF EXISTS `dhc_trade_dailydate`;
CREATE TABLE `dhc_trade_dailydate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sid` int(11) unsigned NOT NULL COMMENT '产品id',
  `OpeningPrice` decimal(10,5) unsigned DEFAULT '0.00000' COMMENT '开盘价格',
  `ClosingPrice` decimal(10,5) unsigned DEFAULT '0.00000' COMMENT '收盘价格',
  `HighestPrice` decimal(10,5) unsigned NOT NULL COMMENT '最高价格',
  `LowestPrice` decimal(10,5) unsigned NOT NULL COMMENT '最低价格',
  `Volume` int(11) unsigned DEFAULT '0' COMMENT '成交数量',
  `Date` int(11) unsigned NOT NULL COMMENT '当日时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='日数据表';

-- ----------------------------
-- Table structure for dhc_trade_dailydates
-- ----------------------------
DROP TABLE IF EXISTS `dhc_trade_dailydates`;
CREATE TABLE `dhc_trade_dailydates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sid` int(11) unsigned NOT NULL COMMENT '产品id',
  `OpeningPrice` decimal(10,5) unsigned DEFAULT '0.00000' COMMENT '开盘价格',
  `ClosingPrice` decimal(10,5) unsigned DEFAULT '0.00000' COMMENT '收盘价格',
  `HighestPrice` decimal(10,5) unsigned NOT NULL COMMENT '最高价格',
  `LowestPrice` decimal(10,5) unsigned NOT NULL COMMENT '最低价格',
  `Volume` int(11) unsigned DEFAULT '0' COMMENT '成交数量',
  `Date` int(11) unsigned NOT NULL COMMENT '当日时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='日数据表';

-- ----------------------------
-- Table structure for dhc_trade_logs
-- ----------------------------
DROP TABLE IF EXISTS `dhc_trade_logs`;
CREATE TABLE `dhc_trade_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `mobile` varchar(100) NOT NULL COMMENT '手机号',
  `num` decimal(10,5) NOT NULL COMMENT '数量',
  `logs` varchar(255) NOT NULL COMMENT '操作内容',
  `createtime` int(11) unsigned NOT NULL COMMENT '操作时间',
  `status` tinyint(4) unsigned NOT NULL COMMENT '状态',
  `type` varchar(100) NOT NULL COMMENT '操作类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='大盘日志表';

-- ----------------------------
-- Table structure for dhc_trade_order
-- ----------------------------
DROP TABLE IF EXISTS `dhc_trade_order`;
CREATE TABLE `dhc_trade_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) unsigned NOT NULL COMMENT '挂单用户id',
  `sid` int(11) unsigned NOT NULL COMMENT '产品id',
  `number` int(11) unsigned NOT NULL COMMENT '挂单数量',
  `price` decimal(10,5) unsigned NOT NULL COMMENT '挂单价格',
  `goods` varchar(255) NOT NULL COMMENT '挂单货物名称',
  `createtime` int(11) unsigned NOT NULL COMMENT '挂单时间',
  `type` tinyint(4) NOT NULL COMMENT '挂单类型',
  `status` int(11) unsigned NOT NULL COMMENT '挂单状态',
  `endtime` int(11) unsigned DEFAULT NULL COMMENT '结束时间',
  `dealnum` int(11) unsigned DEFAULT '0' COMMENT '已成交数量',
  `bid` int(11) unsigned DEFAULT NULL COMMENT '交易用户id',
  `fee` decimal(10,5) DEFAULT '0.00000' COMMENT '手续费',
  `dealprice` decimal(10,5) DEFAULT NULL COMMENT '成交价格',
  `dealMoney` decimal(11,5) DEFAULT '0.00000' COMMENT '成交价格',
  `crontabtime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `sid` (`sid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='挂单表';

-- ----------------------------
-- Table structure for dhc_trade_product
-- ----------------------------
DROP TABLE IF EXISTS `dhc_trade_product`;
CREATE TABLE `dhc_trade_product` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `thumb` varchar(255) NOT NULL COMMENT '产品缩略图',
  `startprice` decimal(10,5) unsigned NOT NULL COMMENT '初始价格',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `status` tinyint(4) NOT NULL COMMENT '状态0停用1启用',
  `title` varchar(255) NOT NULL COMMENT '产品名称',
  `depict` varchar(500) DEFAULT NULL COMMENT '简介',
  `rise` decimal(10,4) NOT NULL COMMENT '涨幅',
  `fall` decimal(10,4) NOT NULL COMMENT '跌幅',
  `poundage` decimal(10,4) NOT NULL COMMENT '交易手续费',
  `seedTime` decimal(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '种子周期',
  `sproutingTime` decimal(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '发芽周期',
  `growTime` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '生长周期',
  `displayorder` int(11) unsigned DEFAULT '0',
  `tradeStatus` tinyint(4) DEFAULT '1' COMMENT '开盘状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=90005 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品表';

-- ----------------------------
-- Table structure for dhc_user
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user`;
CREATE TABLE `dhc_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `is_real` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已经实名0否1是',
  `user` varchar(50) NOT NULL COMMENT '用户账号',
  `superior` varchar(2000) NOT NULL DEFAULT '0' COMMENT '导师推广码',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态(1启用 9 停用)',
  `salt` varchar(100) NOT NULL COMMENT '盐值',
  `token` varchar(500) DEFAULT NULL COMMENT 'token 验证信息',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `balance` int(11) DEFAULT '0' COMMENT '用户余额',
  `coing` decimal(12,5) unsigned DEFAULT '0.00000' COMMENT '用户金币数量',
  `level` int(11) DEFAULT '1' COMMENT '用户等级',
  `realname` varchar(255) DEFAULT '' COMMENT '用户真实姓名',
  `idcard` varchar(255) DEFAULT '' COMMENT '用户身份证号',
  `idcardFront` varchar(255) DEFAULT NULL COMMENT '身份证正面照片',
  `idcardback` varchar(255) DEFAULT NULL COMMENT '身份证反面照片',
  `Frozen` decimal(15,5) unsigned DEFAULT '0.00000' COMMENT '金币冻结数量',
  `spread` int(11) DEFAULT '0' COMMENT '推广码',
  `tencent` varchar(100) DEFAULT NULL COMMENT 'qq号',
  `wechet` varchar(100) DEFAULT NULL COMMENT '微信',
  `telphone` varchar(100) DEFAULT NULL COMMENT '手机号',
  `phone` varchar(100) DEFAULT NULL COMMENT '联系手机号',
  `dueBankAccount` varchar(255) DEFAULT NULL COMMENT '开户行用户名',
  `dueBank` varchar(255) DEFAULT NULL COMMENT '提现银行',
  `accountNumber` varchar(255) DEFAULT NULL COMMENT '提现账户',
  `province` varchar(100) DEFAULT NULL COMMENT '省/直辖市',
  `city` varchar(100) DEFAULT NULL COMMENT '市/县',
  `country` varchar(100) DEFAULT NULL COMMENT '开户区',
  `bankaccount` varchar(100) DEFAULT NULL COMMENT '开户行',
  `channelRebate` float(10,2) unsigned DEFAULT '0.00' COMMENT '渠道分佣比例',
  `salesmanRebate` varchar(500) DEFAULT NULL COMMENT '推广佣金',
  `usergroup` varchar(100) DEFAULT '普通用户' COMMENT '用户组',
  `spreadfee` decimal(10,5) DEFAULT NULL COMMENT '推广手续费',
  `spreadCount` int(11) NOT NULL DEFAULT '0' COMMENT '淘金推荐礼包推荐人数统计',
  `smallfruit` tinyint(4) DEFAULT '0' COMMENT '小额果实赠送开关（1开启 0 关闭）',
  `authLevel` tinyint(4) DEFAULT '0' COMMENT '作者认证等级',
  `idcardStatus` tinyint(4) DEFAULT '0' COMMENT '用户身份证图片验证状态(0为空或失败2审核中1审核通过)',
  `lasttime` int(11) DEFAULT NULL COMMENT '登录时间',
  `createTime` int(11) NOT NULL COMMENT '注册时间',
  `trade_limit_level` int(11) DEFAULT '0' COMMENT '领取大礼包等级',
  `payPassword` varchar(100) DEFAULT NULL COMMENT '支付密码',
  `userCode` varchar(50) DEFAULT NULL COMMENT 'EMG编号',
  `openid` varchar(255) DEFAULT NULL COMMENT '微信openid',
  `voucher` text COMMENT '收款凭证',
  `repassword` varchar(500) DEFAULT NULL COMMENT '记住密码',
  `is_infinite` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否拥有无限代分佣资格0否1是',
  `extend_level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '分佣等级',
  `invitation_code` char(6) NOT NULL DEFAULT '' COMMENT '邀请码',
  `invitation_img` varchar(5000) DEFAULT NULL COMMENT '推广图片的地址',
  `pid` int(11) NOT NULL COMMENT '直推用户id',
  `wallet_token` char(32) NOT NULL COMMENT '钱包app绑定用的token',
  `is_bind_wallet` tinyint(1) NOT NULL DEFAULT '0' COMMENT '该用户是否绑定钱包0否1是',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user` (`user`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49009 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';

-- ----------------------------
-- Table structure for dhc_user_config
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_config`;
CREATE TABLE `dhc_user_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `payType` varchar(100) NOT NULL COMMENT '支付类型',
  `merchant_no` varchar(100) DEFAULT NULL COMMENT '商户号',
  `terminal_id` varchar(100) DEFAULT NULL COMMENT '终端号',
  `status` tinyint(4) DEFAULT NULL COMMENT '支付启用状态',
  `access_token` varchar(100) DEFAULT NULL COMMENT '签名',
  `other` text COMMENT '其他配置参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='支付配置表';

-- ----------------------------
-- Table structure for dhc_user_contribution_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_contribution_log`;
CREATE TABLE `dhc_user_contribution_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `time` int(11) NOT NULL COMMENT '日期',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型0三代1无限代',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `utt` (`uid`,`time`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=415886 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_copy
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_copy`;
CREATE TABLE `dhc_user_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `is_real` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已经实名0否1是',
  `user` varchar(50) NOT NULL COMMENT '用户账号',
  `superior` varchar(2000) NOT NULL DEFAULT '0' COMMENT '导师推广码',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态(1启用 9 停用)',
  `salt` varchar(100) NOT NULL COMMENT '盐值',
  `token` varchar(500) DEFAULT NULL COMMENT 'token 验证信息',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `balance` int(11) DEFAULT '0' COMMENT '用户余额',
  `coing` decimal(12,5) unsigned DEFAULT '0.00000' COMMENT '用户金币数量',
  `level` int(11) DEFAULT '1' COMMENT '用户等级',
  `realname` varchar(255) DEFAULT '' COMMENT '用户真实姓名',
  `idcard` varchar(255) DEFAULT '' COMMENT '用户身份证号',
  `idcardFront` varchar(255) DEFAULT NULL COMMENT '身份证正面照片',
  `idcardback` varchar(255) DEFAULT NULL COMMENT '身份证反面照片',
  `Frozen` decimal(15,5) unsigned DEFAULT '0.00000' COMMENT '金币冻结数量',
  `spread` int(11) DEFAULT '0' COMMENT '推广码',
  `tencent` varchar(100) DEFAULT NULL COMMENT 'qq号',
  `wechet` varchar(100) DEFAULT NULL COMMENT '微信',
  `telphone` varchar(100) DEFAULT NULL COMMENT '手机号',
  `phone` varchar(100) DEFAULT NULL COMMENT '联系手机号',
  `dueBankAccount` varchar(255) DEFAULT NULL COMMENT '开户行用户名',
  `dueBank` varchar(255) DEFAULT NULL COMMENT '提现银行',
  `accountNumber` varchar(255) DEFAULT NULL COMMENT '提现账户',
  `province` varchar(100) DEFAULT NULL COMMENT '省/直辖市',
  `city` varchar(100) DEFAULT NULL COMMENT '市/县',
  `country` varchar(100) DEFAULT NULL COMMENT '开户区',
  `bankaccount` varchar(100) DEFAULT NULL COMMENT '开户行',
  `channelRebate` float(10,2) unsigned DEFAULT '0.00' COMMENT '渠道分佣比例',
  `salesmanRebate` varchar(500) DEFAULT NULL COMMENT '推广佣金',
  `usergroup` varchar(100) DEFAULT '普通用户' COMMENT '用户组',
  `spreadfee` decimal(10,5) DEFAULT NULL COMMENT '推广手续费',
  `spreadCount` int(11) NOT NULL DEFAULT '0' COMMENT '淘金推荐礼包推荐人数统计',
  `smallfruit` tinyint(4) DEFAULT '0' COMMENT '小额果实赠送开关（1开启 0 关闭）',
  `authLevel` tinyint(4) DEFAULT '0' COMMENT '作者认证等级',
  `idcardStatus` tinyint(4) DEFAULT '0' COMMENT '用户身份证图片验证状态(0为空或失败2审核中1审核通过)',
  `lasttime` int(11) DEFAULT NULL COMMENT '登录时间',
  `createTime` int(11) NOT NULL COMMENT '注册时间',
  `trade_limit_level` int(11) DEFAULT '0' COMMENT '领取大礼包等级',
  `payPassword` varchar(100) DEFAULT NULL COMMENT '支付密码',
  `userCode` varchar(50) DEFAULT NULL COMMENT 'EMG编号',
  `openid` varchar(255) DEFAULT NULL COMMENT '微信openid',
  `voucher` text COMMENT '收款凭证',
  `repassword` varchar(500) DEFAULT NULL COMMENT '记住密码',
  `is_infinite` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否拥有无限代分佣资格0否1是',
  `extend_level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '分佣等级',
  `invitation_code` char(6) NOT NULL DEFAULT '' COMMENT '邀请码',
  `invitation_img` varchar(5000) DEFAULT NULL COMMENT '推广图片的地址',
  `pid` int(11) NOT NULL COMMENT '直推用户id',
  `wallet_token` char(32) DEFAULT NULL COMMENT '钱包app绑定用的token',
  `is_bind_wallet` tinyint(1) NOT NULL DEFAULT '0' COMMENT '该用户是否绑定钱包0否1是',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user` (`user`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25844 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';

-- ----------------------------
-- Table structure for dhc_user_cost
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_cost`;
CREATE TABLE `dhc_user_cost` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `orderNumber` varchar(255) NOT NULL COMMENT '订单号',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `endtime` int(11) unsigned DEFAULT NULL COMMENT '结束时间',
  `sum` decimal(10,5) NOT NULL COMMENT '消费金额',
  `charge` decimal(10,5) DEFAULT '0.00000' COMMENT '手续费',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态1 成功 0 审核 2失败',
  `type` varchar(100) NOT NULL COMMENT '消费类型',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15678 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户消费表';

-- ----------------------------
-- Table structure for dhc_user_give
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_give`;
CREATE TABLE `dhc_user_give` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) unsigned NOT NULL COMMENT '赠送用户id',
  `accept` varchar(100) NOT NULL COMMENT '接受用户id或者帐号',
  `productid` int(11) unsigned NOT NULL COMMENT '产品id',
  `number` int(11) unsigned NOT NULL COMMENT '产品数量',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '赠送状态1结束（接受或者2退回撤销），0等待接受',
  `title` varchar(100) NOT NULL COMMENT '产品名称',
  `createtime` int(11) NOT NULL COMMENT '赠送时间',
  `fee` decimal(10,5) NOT NULL COMMENT '手续费',
  `giveGold` int(11) unsigned DEFAULT '0' COMMENT '索取金币数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户赠送产品表';

-- ----------------------------
-- Table structure for dhc_user_gold
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_gold`;
CREATE TABLE `dhc_user_gold` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `oid` int(11) unsigned NOT NULL COMMENT '操作员id',
  `uid` int(11) unsigned NOT NULL COMMENT '充值用户id',
  `gold` float(11,2) DEFAULT '0.00' COMMENT '充值金币数量',
  `frozen` float(11,2) DEFAULT '0.00' COMMENT '冻结金币数量',
  `createtime` int(11) unsigned NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='充值操作表';

-- ----------------------------
-- Table structure for dhc_user_level_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_level_log`;
CREATE TABLE `dhc_user_level_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `conetnt` varchar(255) NOT NULL COMMENT '内容',
  `level` tinyint(1) NOT NULL COMMENT '新的等级',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否通知用户0否1是',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_log`;
CREATE TABLE `dhc_user_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `user` varchar(100) NOT NULL COMMENT '用户帐号',
  `ip` varchar(100) NOT NULL COMMENT '用户ip',
  `logintime` int(11) NOT NULL COMMENT '用户登录时间',
  `info` text NOT NULL COMMENT '用户信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户登录表';

-- ----------------------------
-- Table structure for dhc_user_message
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_message`;
CREATE TABLE `dhc_user_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mobile` char(11) NOT NULL COMMENT '手机号',
  `sendTime` int(11) NOT NULL COMMENT '发送时间',
  `code` char(6) NOT NULL COMMENT '验证码',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未使用1已使用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26964 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户验证短信表';

-- ----------------------------
-- Table structure for dhc_user_pay_order
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_pay_order`;
CREATE TABLE `dhc_user_pay_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `order_sn` varchar(100) NOT NULL COMMENT '订单编号',
  `money` decimal(11,2) NOT NULL COMMENT '金额',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态0待支付1已经支付2支付失败-1未进行支付',
  `pay_id` tinyint(1) NOT NULL DEFAULT '0' COMMENT '钻石表id',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型0身份认证1购买钻石',
  `number` int(11) NOT NULL DEFAULT '0' COMMENT '充值的钻石数量',
  `pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付类型0支付宝',
  `pay_time` datetime DEFAULT NULL COMMENT '回调通知时间',
  `sn` varchar(255) DEFAULT '' COMMENT '第三方订单号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20158 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户支付日志表(新)';

-- ----------------------------
-- Table structure for dhc_user_pay_order_bak
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_pay_order_bak`;
CREATE TABLE `dhc_user_pay_order_bak` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `order_sn` varchar(100) NOT NULL COMMENT '订单编号',
  `money` decimal(11,2) NOT NULL COMMENT '金额',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态0待支付1已经支付2支付失败',
  `is_certify_id` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否获取过支付宝身份认证信息0否1是',
  `pay_id` tinyint(1) NOT NULL DEFAULT '0' COMMENT '钻石表id',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型0身份认证1购买钻石',
  `number` int(11) NOT NULL DEFAULT '0' COMMENT '充值的钻石数量',
  `pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付类型0支付宝',
  `token` varchar(255) NOT NULL COMMENT '用户保持在线的身份认证',
  `pay_time` datetime DEFAULT NULL COMMENT '回调通知时间',
  `sn` varchar(255) DEFAULT '' COMMENT '第三方订单号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_product
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_product`;
CREATE TABLE `dhc_user_product` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `sid` int(11) unsigned NOT NULL COMMENT '产品id',
  `number` int(11) unsigned DEFAULT '0' COMMENT '产品数量果实',
  `frozen` int(11) unsigned DEFAULT '0' COMMENT '产品冻结数量',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`,`sid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=108103 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户产品仓库表';

-- ----------------------------
-- Table structure for dhc_user_real
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_real`;
CREATE TABLE `dhc_user_real` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `pid` int(11) NOT NULL COMMENT 'user_pay_order表id',
  `name` varchar(255) NOT NULL COMMENT '用户真实姓名',
  `idcard` char(18) NOT NULL COMMENT '用户身份证号码 ',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否成功0待认证1成功2失败',
  `certify_id` varchar(255) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20158 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户实名认证信息(新)';

-- ----------------------------
-- Table structure for dhc_user_real_bak
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_real_bak`;
CREATE TABLE `dhc_user_real_bak` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `order_sn` varchar(100) NOT NULL COMMENT '订单编号',
  `pid` int(11) NOT NULL COMMENT 'user_pay_order表id',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否成功0待认证1成功2失败',
  `token` varchar(255) NOT NULL DEFAULT '' COMMENT '用户保持在线的身份认证',
  `certify_id` varchar(255) NOT NULL DEFAULT '',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_real_data
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_real_data`;
CREATE TABLE `dhc_user_real_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `order_sn` varchar(100) NOT NULL COMMENT '订单号',
  `pid` int(11) NOT NULL COMMENT '支付表id',
  `name` varchar(100) NOT NULL COMMENT '用户名',
  `card_no` char(18) NOT NULL COMMENT '身份证',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `order_sn` (`order_sn`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户实名时输入的身份信息(新)';

-- ----------------------------
-- Table structure for dhc_user_recharge
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_recharge`;
CREATE TABLE `dhc_user_recharge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `orderNumber` varchar(100) NOT NULL COMMENT '订单号',
  `number` int(11) NOT NULL COMMENT '充值数量',
  `payType` varchar(100) NOT NULL COMMENT '支付类型',
  `payStatus` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '支付状态（1支付成功2待支付3支付失败）',
  `createTime` int(11) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户充值表';

-- ----------------------------
-- Table structure for dhc_user_renascence
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_renascence`;
CREATE TABLE `dhc_user_renascence` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) NOT NULL COMMENT '重生用户',
  `title` varchar(100) NOT NULL COMMENT '产品名称',
  `price` decimal(10,5) NOT NULL COMMENT '当前价格',
  `number` varchar(100) NOT NULL COMMENT '重生数量',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `charge` decimal(10,5) NOT NULL COMMENT '手续费',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户产品重生表';

-- ----------------------------
-- Table structure for dhc_user_service
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_service`;
CREATE TABLE `dhc_user_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `title` varchar(100) NOT NULL COMMENT '服务名称',
  `way` varchar(100) NOT NULL COMMENT '联系方式',
  `type` varchar(20) DEFAULT '0' COMMENT '服务类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='前台服务联系方式展示';

-- ----------------------------
-- Table structure for dhc_user_team
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team`;
CREATE TABLE `dhc_user_team` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `parents` text NOT NULL COMMENT '所有级用户',
  `direct_amount` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户直推人数',
  `team_amount` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户团队推广人数',
  `effective_direct` int(11) NOT NULL DEFAULT '0' COMMENT '直推有效用户人数',
  `effective_team` int(11) NOT NULL DEFAULT '0' COMMENT '团队有效用户人数',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47105 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_data
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_data`;
CREATE TABLE `dhc_user_team_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '注册用户id',
  `pid` int(11) NOT NULL COMMENT '上级id',
  `level` tinyint(1) NOT NULL COMMENT '第几级上级1直推2二级以此类推',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`,`level`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=345756 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_infinite
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_infinite`;
CREATE TABLE `dhc_user_team_infinite` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `gid` int(11) NOT NULL COMMENT '果实类型id(1化肥，其他一一对应)',
  `number` int(11) NOT NULL COMMENT '果实数量',
  `xiaoshu` int(11) DEFAULT '0' COMMENT '小数部分',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_infinite_date
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_infinite_date`;
CREATE TABLE `dhc_user_team_infinite_date` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `gid` int(11) NOT NULL COMMENT '果实类型id(1化肥，其他一一对应)',
  `number` int(11) NOT NULL COMMENT '果实数量',
  `xiaoshu` int(11) DEFAULT '0' COMMENT '小数部分',
  `create_at` date NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_product
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_product`;
CREATE TABLE `dhc_user_team_product` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `gid` int(11) NOT NULL COMMENT '果实类型id(1化肥，其他一一对应)',
  `number` int(11) NOT NULL COMMENT '果实数量',
  `xiaoshu` int(4) DEFAULT '0' COMMENT '小数部分',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=204252 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_product_date
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_product_date`;
CREATE TABLE `dhc_user_team_product_date` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `gid` int(11) NOT NULL COMMENT '果实类型id(1化肥，其他一一对应)',
  `number` int(11) NOT NULL COMMENT '果实数量',
  `xiaoshu` int(11) DEFAULT '0' COMMENT '小数部分',
  `create_at` date NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=304426 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_team_statistics
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_team_statistics`;
CREATE TABLE `dhc_user_team_statistics` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户',
  `direct_amount` int(11) DEFAULT '0' COMMENT '直推今日新增',
  `team_amount` int(11) DEFAULT '0' COMMENT '团队今日新增',
  `create_at` date NOT NULL COMMENT '日期',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uid_time` (`uid`,`create_at`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8683 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Table structure for dhc_user_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `dhc_user_withdraw`;
CREATE TABLE `dhc_user_withdraw` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `createtime` int(11) NOT NULL COMMENT '创建时间',
  `accountnumber` varchar(100) NOT NULL COMMENT '银行帐号',
  `goldnumber` int(11) NOT NULL COMMENT '提现金币数量',
  `fee` decimal(10,5) NOT NULL COMMENT '手续费',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态1审核通过 0 审核中 2已完成 3返回信息有误',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `bankaccount` varchar(100) NOT NULL COMMENT '收款开户银行',
  `withdrawtype` varchar(4) DEFAULT NULL COMMENT '提现类型（1行内转账 2 同城跨行3异地跨行）',
  `province` varchar(100) NOT NULL COMMENT '省份/直辖市',
  `city` varchar(100) NOT NULL COMMENT '市/县',
  `costname` varchar(100) NOT NULL COMMENT '消费类型',
  `realname` varchar(100) DEFAULT NULL COMMENT '提现用户',
  `voucher` text COMMENT '支付凭证',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户提现表';

-- ----------------------------
-- Table structure for dhc_virtual_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `dhc_virtual_withdraw`;
CREATE TABLE `dhc_virtual_withdraw` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) NOT NULL COMMENT '用户id',
  `goldnumber` decimal(11,5) NOT NULL COMMENT '提现金币数量',
  `number` decimal(11,5) NOT NULL COMMENT '提现数量',
  `address` varchar(255) NOT NULL COMMENT '收货地址',
  `createtime` int(11) NOT NULL COMMENT '提现时间',
  `rebate` decimal(10,2) NOT NULL COMMENT '兑换比例',
  `status` tinyint(4) DEFAULT '0' COMMENT '审核状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='虚拟币提现表';

-- ----------------------------
-- Table structure for dhc_wallet_log
-- ----------------------------
DROP TABLE IF EXISTS `dhc_wallet_log`;
CREATE TABLE `dhc_wallet_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `num` int(11) NOT NULL COMMENT 'k钻数量',
  `actual_num` int(11) NOT NULL COMMENT '实际数量(减去手续费)',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0转入到农场1转出到钱包',
  `content` varchar(255) NOT NULL COMMENT '参数',
  `create_at` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31986 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='农场-钱包转入转出记录';

-- ----------------------------
-- Table structure for dhc_withdraw_address
-- ----------------------------
DROP TABLE IF EXISTS `dhc_withdraw_address`;
CREATE TABLE `dhc_withdraw_address` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) unsigned NOT NULL COMMENT '用户id',
  `address` varchar(255) NOT NULL COMMENT '收货地址',
  `createtime` int(11) NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户虚拟币提现收货地址表';

SET FOREIGN_KEY_CHECKS = 1;