/*
Navicat MySQL Data Transfer

Source Server         : coin47.97.27.96
Source Server Version : 50559
Source Host           : 47.97.27.96:3306
Source Database       : db_coin

Target Server Type    : MYSQL
Target Server Version : 50559
File Encoding         : 65001

Date: 2018-03-21 14:46:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dtb_activity_record
-- ----------------------------
DROP TABLE IF EXISTS `dtb_activity_record`;
CREATE TABLE `dtb_activity_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '玩家ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建牌局时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活跃用户记录表';

-- ----------------------------
-- Table structure for dtb_alliance
-- ----------------------------
DROP TABLE IF EXISTS `dtb_alliance`;
CREATE TABLE `dtb_alliance` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '联盟ID',
  `alliance_name` varchar(20) DEFAULT '' COMMENT '联盟名称',
  `alliance_introduce` text COMMENT '联盟简介',
  `clubs_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的俱乐部数量',
  `creater_club_id` int(11) unsigned DEFAULT '0' COMMENT '创建联盟的俱乐部ID',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `creater_club_id` (`creater_club_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=101195 DEFAULT CHARSET=utf8 COMMENT='俱乐部信息表';

-- ----------------------------
-- Table structure for dtb_alliance_apply
-- ----------------------------
DROP TABLE IF EXISTS `dtb_alliance_apply`;
CREATE TABLE `dtb_alliance_apply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `alliance_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `club_name` varchar(20) DEFAULT '' COMMENT '昵称',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `creater_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部创始人ID',
  `apply_msg` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  `chk_status` tinyint(1) unsigned DEFAULT '0' COMMENT '审核状态 0未通过 1通过',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '申请时间',
  `chk_time` int(10) unsigned DEFAULT '0' COMMENT '通过审核时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2186 DEFAULT CHARSET=utf8 COMMENT='俱乐部添加成员审核表';

-- ----------------------------
-- Table structure for dtb_alliance_member
-- ----------------------------
DROP TABLE IF EXISTS `dtb_alliance_member`;
CREATE TABLE `dtb_alliance_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `alliance_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `creater_club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '会员ID',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  `max_buyin_limit` int(11) DEFAULT '-1' COMMENT '最大买入限制',
  `cur_buyin_limit` int(11) unsigned DEFAULT '0' COMMENT '已经批准的额度限制',
  `control_buyin` tinyint(1) unsigned DEFAULT '1' COMMENT '控制买入 1:开放带入 2:禁止带入',
  PRIMARY KEY (`id`),
  KEY `club_id` (`creater_club_id`) USING BTREE,
  KEY `member_id` (`club_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3571 DEFAULT CHARSET=utf8 COMMENT='俱乐部会员信息表';

-- ----------------------------
-- Table structure for dtb_area
-- ----------------------------
DROP TABLE IF EXISTS `dtb_area`;
CREATE TABLE `dtb_area` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '地区ID',
  `area_name` varchar(20) DEFAULT '' COMMENT '地区名称',
  `is_hot` tinyint(1) unsigned DEFAULT '0' COMMENT '是否热门 0未定义 1热门 2不热门',
  PRIMARY KEY (`id`),
  KEY `is_hot` (`is_hot`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='地区表';

-- ----------------------------
-- Table structure for dtb_club
-- ----------------------------
DROP TABLE IF EXISTS `dtb_club`;
CREATE TABLE `dtb_club` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '俱乐部ID',
  `club_name` varchar(20) DEFAULT '' COMMENT '俱乐部名称',
  `club_introduce` text COMMENT '俱乐部简介',
  `club_level` tinyint(1) unsigned DEFAULT '0' COMMENT '俱乐部等级 0未定义 1一星级 2二星级 3三星级 4四星级 5五星级 6六星级 7七星级',
  `club_img` varchar(255) DEFAULT '' COMMENT '俱乐部头像原图',
  `club_thumb` varchar(255) DEFAULT '' COMMENT '俱乐部头像缩略图',
  `club_gold` int(11) unsigned DEFAULT '0' COMMENT '俱乐部金币数量',
  `members_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的俱乐部会员数量',
  `current_members` int(11) unsigned DEFAULT '0' COMMENT '当前创建的俱乐部会员数量',
  `admins_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的俱乐部管理员数量',
  `current_admins` int(11) unsigned DEFAULT '0' COMMENT '当前创建的俱乐部管理员数量',
  `is_private` tinyint(1) unsigned DEFAULT '0' COMMENT '是否私密：1 私密 0 公开 2 推荐',
  `creater_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部创始人ID',
  `area_id` int(11) unsigned DEFAULT '0' COMMENT '所在地区ID',
  `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  `expire_time` int(10) unsigned DEFAULT '0' COMMENT '到期时间',
  `club_area` varchar(20) DEFAULT '' COMMENT '俱乐部地域',
  `oprate_gold` tinyint(1) unsigned DEFAULT '1' COMMENT '是否操作金币,1:操作金币,2:不操作金币',
  `created_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的联盟数量',
  `joined_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的联盟数量',
  PRIMARY KEY (`id`),
  KEY `creater_id` (`creater_id`) USING BTREE,
  KEY `area_id` (`area_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=101318 DEFAULT CHARSET=utf8 COMMENT='俱乐部信息表';

-- ----------------------------
-- Table structure for dtb_club_admin
-- ----------------------------
DROP TABLE IF EXISTS `dtb_club_admin`;
CREATE TABLE `dtb_club_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `admin_id` int(11) unsigned DEFAULT '0' COMMENT '管理员ID',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`),
  KEY `club_id` (`club_id`) USING BTREE,
  KEY `admin_id` (`admin_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1645 DEFAULT CHARSET=utf8 COMMENT='俱乐部管理员信息表';

-- ----------------------------
-- Table structure for dtb_club_apply
-- ----------------------------
DROP TABLE IF EXISTS `dtb_club_apply`;
CREATE TABLE `dtb_club_apply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `avatar` varchar(255) DEFAULT '' COMMENT '用户头像',
  `avatar_thumb` varchar(255) DEFAULT '' COMMENT '头像(来自APP端) 缩略图',
  `nick_name` varchar(20) DEFAULT '' COMMENT '昵称',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `creater_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部创始人ID',
  `apply_msg` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  `chk_status` tinyint(1) unsigned DEFAULT '0' COMMENT '审核状态 0未通过 1通过',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '申请时间',
  `chk_time` int(10) unsigned DEFAULT '0' COMMENT '通过审核时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2106 DEFAULT CHARSET=utf8 COMMENT='俱乐部添加成员审核表';

-- ----------------------------
-- Table structure for dtb_club_member
-- ----------------------------
DROP TABLE IF EXISTS `dtb_club_member`;
CREATE TABLE `dtb_club_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `member_id` int(11) unsigned DEFAULT '0' COMMENT '会员ID',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`),
  KEY `club_id` (`club_id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3823 DEFAULT CHARSET=utf8 COMMENT='俱乐部会员信息表';

-- ----------------------------
-- Table structure for dtb_diamond_price
-- ----------------------------
DROP TABLE IF EXISTS `dtb_diamond_price`;
CREATE TABLE `dtb_diamond_price` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `diamond_num` int(11) unsigned DEFAULT '0' COMMENT '钻石数量',
  `diamond_price` decimal(11,0) unsigned DEFAULT '0' COMMENT '钻石价格',
  `diamond_desc` varchar(255) DEFAULT '' COMMENT '钻石描述',
  `img_url` varchar(255) DEFAULT '' COMMENT '钻石图片',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态 1可以购买，0下架',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='钻石价格表';

-- ----------------------------
-- Table structure for dtb_goods
-- ----------------------------
DROP TABLE IF EXISTS `dtb_goods`;
CREATE TABLE `dtb_goods` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `goods_type` tinyint(1) unsigned DEFAULT '0' COMMENT '商品类型 0未定义类型  1礼包，2卡片，3星级俱乐部',
  `goods_name` varchar(100) DEFAULT '' COMMENT '商品名称',
  `diamond_num` int(11) unsigned DEFAULT '0' COMMENT '需要钻石数量',
  `gold_num` int(11) unsigned DEFAULT '0' COMMENT '含游戏币数量',
  `gift_gold` int(11) unsigned DEFAULT '0' COMMENT '额外赠送游戏币数量',
  `clubs_max` int(11) unsigned DEFAULT '0' COMMENT '创建俱乐部的上限',
  `club_level` int(11) unsigned DEFAULT '0' COMMENT '俱乐部星级',
  `card_type` tinyint(1) unsigned DEFAULT '0' COMMENT '会员卡类型 0未知类型 1蓝卡 2金卡 3白金卡',
  `games_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  `members_max` int(11) unsigned DEFAULT '0' COMMENT '俱乐部人数上限',
  `admins_max` int(11) unsigned DEFAULT '0' COMMENT '俱乐部管理员上限',
  `expire_time` int(11) unsigned DEFAULT '0' COMMENT '过期时间 0为不过期',
  `img_url` varchar(255) DEFAULT '' COMMENT '商品图片',
  `goods_desc` varchar(255) DEFAULT '' COMMENT '描述',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态 1可以购买，0下架',
  `created_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  `joined_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  PRIMARY KEY (`id`),
  KEY `goods_type` (`goods_type`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Table structure for dtb_goods_en
-- ----------------------------
DROP TABLE IF EXISTS `dtb_goods_en`;
CREATE TABLE `dtb_goods_en` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `goods_type` tinyint(1) unsigned DEFAULT '0' COMMENT '商品类型 0未定义类型  1礼包，2卡片，3星级俱乐部',
  `goods_name` varchar(100) DEFAULT '' COMMENT '商品名称',
  `diamond_num` int(11) unsigned DEFAULT '0' COMMENT '需要钻石数量',
  `gold_num` int(11) unsigned DEFAULT '0' COMMENT '含游戏币数量',
  `gift_gold` int(11) unsigned DEFAULT '0' COMMENT '额外赠送游戏币数量',
  `clubs_max` int(11) unsigned DEFAULT '0' COMMENT '创建俱乐部的上限',
  `club_level` int(11) unsigned DEFAULT '0' COMMENT '俱乐部星级',
  `card_type` tinyint(1) unsigned DEFAULT '0' COMMENT '会员卡类型 0未知类型 1蓝卡 2金卡 3白金卡',
  `games_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  `members_max` int(11) unsigned DEFAULT '0' COMMENT '俱乐部人数上限',
  `admins_max` int(11) unsigned DEFAULT '0' COMMENT '俱乐部管理员上限',
  `expire_time` int(11) unsigned DEFAULT '0' COMMENT '过期时间 0为不过期',
  `img_url` varchar(255) DEFAULT '' COMMENT '商品图片',
  `goods_desc` varchar(255) DEFAULT '' COMMENT '描述',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态 1可以购买，0下架',
  `created_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  `joined_alliance_max` int(11) unsigned DEFAULT '0' COMMENT '可同时组建的牌局数量',
  PRIMARY KEY (`id`),
  KEY `goods_type` (`goods_type`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Table structure for dtb_member_activity
-- ----------------------------
DROP TABLE IF EXISTS `dtb_member_activity`;
CREATE TABLE `dtb_member_activity` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '玩家ID',
  `club_id` int(11) DEFAULT '-1' COMMENT '俱乐部ID',
  `count` tinyint(1) unsigned DEFAULT '0' COMMENT '成员买入次数',
  `active_time` int(10) unsigned DEFAULT '0' COMMENT '成员活跃时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11574682 DEFAULT CHARSET=utf8 COMMENT='成员活跃记录表';

-- ----------------------------
-- Table structure for dtb_order_receipt
-- ----------------------------
DROP TABLE IF EXISTS `dtb_order_receipt`;
CREATE TABLE `dtb_order_receipt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(32) NOT NULL DEFAULT '' COMMENT '充值订单号',
  `receipt` text NOT NULL COMMENT '秘钥',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COMMENT='用户充值订单表';

-- ----------------------------
-- Table structure for dtb_pay_anomaly
-- ----------------------------
DROP TABLE IF EXISTS `dtb_pay_anomaly`;
CREATE TABLE `dtb_pay_anomaly` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '用户id',
  `order_no` varchar(32) DEFAULT '' COMMENT '订单号',
  `total_fee` int(11) unsigned DEFAULT '0' COMMENT '支付宝金额',
  `order_money` int(11) unsigned DEFAULT '0' COMMENT '订单金额',
  `add_time` int(11) unsigned DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='订单数据异常日志';

-- ----------------------------
-- Table structure for dtb_register_device_log
-- ----------------------------
DROP TABLE IF EXISTS `dtb_register_device_log`;
CREATE TABLE `dtb_register_device_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device_uuid` char(32) NOT NULL DEFAULT '' COMMENT '设备ID',
  `num` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '当天剩余注册数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dtb_register_ip_log
-- ----------------------------
DROP TABLE IF EXISTS `dtb_register_ip_log`;
CREATE TABLE `dtb_register_ip_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg_ip` int(10) NOT NULL DEFAULT '0' COMMENT '注册ip',
  `num` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '当天剩余注册数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dtb_remarks
-- ----------------------------
DROP TABLE IF EXISTS `dtb_remarks`;
CREATE TABLE `dtb_remarks` (
  `uid` int(11) NOT NULL,
  `data` text,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dtb_sale_record
-- ----------------------------
DROP TABLE IF EXISTS `dtb_sale_record`;
CREATE TABLE `dtb_sale_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(32) DEFAULT '' COMMENT '兑换订单号',
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '用户编号',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `nick_name` varchar(20) DEFAULT '' COMMENT '昵称',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部编号',
  `club_name` varchar(20) DEFAULT '' COMMENT '俱乐部名称',
  `goods_id` int(11) unsigned DEFAULT '0' COMMENT '商品编号',
  `goods_name` varchar(100) DEFAULT '' COMMENT '商品名称',
  `goods_type` tinyint(1) unsigned DEFAULT '0' COMMENT '商品类型 0未定义类型  1礼包，2卡片，3星级俱乐部',
  `diamond_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前钻石数量',
  `diamond_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后钻石数量',
  `gold_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前金币数量',
  `gold_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后金币数量',
  `games_max_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前可组建的牌局数量',
  `games_max_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后可组建的牌局数量',
  `clubs_max_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前可创建的俱乐部数量',
  `clubs_max_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后可创建的俱乐部数量',
  `card_type_before` tinyint(1) unsigned DEFAULT '0' COMMENT '用户交易前卡片类型 0未定义 1蓝卡，2金卡(月卡)，3白金卡(年卡)',
  `card_type_after` tinyint(1) unsigned DEFAULT '0' COMMENT '用户交易后卡片类型 0未定义 1蓝卡，2金卡(月卡)，3白金卡(年卡)',
  `club_level_before` tinyint(1) unsigned DEFAULT '0' COMMENT '用户交易前俱乐部等级 0未定义 1一星级 2二星级 3三星级 4四星级 5五星级 6六星级 7七星级',
  `club_level_after` tinyint(1) unsigned DEFAULT '0' COMMENT '用户交易后俱乐部等级 0未定义 1一星级 2二星级 3三星级 4四星级 5五星级 6六星级 7七星级',
  `members_max_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前可创建的俱乐部会员数量',
  `members_max_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后可创建的俱乐部会员数量',
  `admins_max_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前可创建的管理员数量',
  `admins_max_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后可创建的管理员数量',
  `club_gold_before` int(11) unsigned DEFAULT '0' COMMENT '用户交易前的俱乐部基金数量',
  `club_gold_after` int(11) unsigned DEFAULT '0' COMMENT '用户交易后的俱乐部基金数量',
  `expire_time` int(11) unsigned DEFAULT '0' COMMENT '过期时间 0为不过期',
  `remark` varchar(255) DEFAULT '' COMMENT '订单备注',
  `pay_time` int(10) unsigned DEFAULT '0' COMMENT '消费时间',
  PRIMARY KEY (`id`),
  KEY `order_sn` (`order_sn`) USING BTREE,
  KEY `pay_time` (`pay_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2446 DEFAULT CHARSET=utf8 COMMENT='用户兑换记录表';

-- ----------------------------
-- Table structure for dtb_user_main
-- ----------------------------
DROP TABLE IF EXISTS `dtb_user_main`;
CREATE TABLE `dtb_user_main` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `areaCode` varchar(10) DEFAULT '' COMMENT '国家区号',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `passwd` char(32) DEFAULT '' COMMENT '密码',
  `avatar` varchar(255) DEFAULT '' COMMENT '用户头像',
  `avatar_thumb` varchar(255) DEFAULT '' COMMENT '头像(来自APP端) 缩略图',
  `nick_name` varchar(40) DEFAULT '' COMMENT '昵称',
  `gender` tinyint(1) unsigned DEFAULT '0' COMMENT '性别 0未定义/保密 1男性 2女性',
  `user_marks` varchar(60) DEFAULT '' COMMENT '个性签名',
  `user_area` varchar(20) DEFAULT '' COMMENT '所在地区',
  `diamond_num` int(11) unsigned DEFAULT '0' COMMENT '钻石数量',
  `user_gold` int(11) unsigned DEFAULT '0' COMMENT '用户金币数量',
  `games_max` int(11) unsigned DEFAULT '0' COMMENT '可组建的牌局数量',
  `clubs_max` int(11) unsigned DEFAULT '0' COMMENT '可创建的俱乐部数量',
  `current_games` int(11) unsigned DEFAULT '0' COMMENT '当前创建的牌局数量',
  `current_clubs` int(11) unsigned DEFAULT '0' COMMENT '当前创建的俱乐部数量',
  `point` int(11) unsigned DEFAULT '0' COMMENT '用户积分',
  `reg_code` varchar(8) DEFAULT '' COMMENT '邀请注册码',
  `sale_code` varchar(8) DEFAULT '' COMMENT '折扣推广码',
  `card_type` tinyint(1) unsigned DEFAULT '0' COMMENT '卡片类型 0未定义 1蓝卡，2金卡(月卡)，3白金卡(年卡)',
  `card_expire` int(11) unsigned DEFAULT '0' COMMENT '会员卡过期时间',
  `token` varchar(200) DEFAULT '' COMMENT '令牌标识',
  `device_type` tinyint(1) unsigned DEFAULT '0' COMMENT '设备类型：0 未知类型 1 ios 2 Android',
  `reg_time` int(10) unsigned DEFAULT '0' COMMENT '注册时间',
  `last_login` int(10) unsigned DEFAULT '0' COMMENT '最后登录时间',
  `is_online` tinyint(1) unsigned DEFAULT '0' COMMENT '是否在线 0 离线  1在线',
  `room_id` int(20) NOT NULL DEFAULT '0' COMMENT '当前的房间ID',
  PRIMARY KEY (`id`),
  KEY `mobile` (`mobile`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12368 DEFAULT CHARSET=utf8 COMMENT='用户信息主表';

-- ----------------------------
-- Table structure for dtb_user_order
-- ----------------------------
DROP TABLE IF EXISTS `dtb_user_order`;
CREATE TABLE `dtb_user_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(32) DEFAULT '' COMMENT '充值订单号',
  `diamond` int(11) unsigned DEFAULT '0' COMMENT '购买的钻石数量',
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '用户编号',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `recommend_id` int(11) unsigned DEFAULT '0' COMMENT '代理商编号',
  `amount` int(11) DEFAULT NULL,
  `pay_type` tinyint(1) unsigned DEFAULT '0' COMMENT '支付方式 0未知  1支付宝 2微信 3银联 4苹果',
  `pay_status` tinyint(1) unsigned DEFAULT '0' COMMENT '支付状态 0未支付 1已支付',
  `remark` varchar(255) DEFAULT '' COMMENT '订单备注',
  `pay_time` int(10) unsigned DEFAULT '0' COMMENT '支付时间',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_sn` (`order_sn`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1149 DEFAULT CHARSET=utf8 COMMENT='用户充值订单表';

-- ----------------------------
-- Table structure for dtb_user_sms
-- ----------------------------
DROP TABLE IF EXISTS `dtb_user_sms`;
CREATE TABLE `dtb_user_sms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '用户编号',
  `mobile` varchar(50) DEFAULT '' COMMENT '手机号',
  `msg` text COMMENT '短信内容',
  `v_code` varchar(20) DEFAULT '' COMMENT '用于手机验证的验证码',
  `stype` tinyint(1) unsigned DEFAULT '1' COMMENT '发送类型  1注册验证，2找回密码，3解除绑定手机号，4重新绑定手机号',
  `return_code` int(11) DEFAULT NULL COMMENT '返回状态码 0成功 1错误',
  `v_status` tinyint(1) unsigned DEFAULT '0' COMMENT '验证状态',
  `is_delete` tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除:0:未删除 1:已删除',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1464 DEFAULT CHARSET=utf8 COMMENT='用户发送短信表';

-- ----------------------------
-- Table structure for dtb_wxpay_anomaly
-- ----------------------------
DROP TABLE IF EXISTS `dtb_wxpay_anomaly`;
CREATE TABLE `dtb_wxpay_anomaly` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `order_no` varchar(50) NOT NULL COMMENT '订单号',
  `total_fee` float NOT NULL COMMENT '支付宝金额',
  `addtime` int(10) NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='订单数据异常日志';

-- ----------------------------
-- Table structure for ey_admin
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin`;
CREATE TABLE `ey_admin` (
  `userid` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `roleid` smallint(5) DEFAULT '0',
  `encrypt` varchar(6) DEFAULT NULL,
  `lastloginip` varchar(15) DEFAULT NULL,
  `lastlogintime` int(10) unsigned DEFAULT '0',
  `email` varchar(40) DEFAULT NULL,
  `realname` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`userid`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_admin_action
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin_action`;
CREATE TABLE `ey_admin_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `admin_id` int(11) unsigned NOT NULL COMMENT '管理员id',
  `model` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '模型',
  `controller` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '控制器',
  `action` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '方法',
  `param` text COLLATE utf8_unicode_ci NOT NULL COMMENT '请求参数',
  `ip` varchar(25) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ip地址',
  `create_time` int(10) unsigned NOT NULL COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='管理员行为记录表';

-- ----------------------------
-- Table structure for ey_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin_role`;
CREATE TABLE `ey_admin_role` (
  `roleid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `rolename` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
  `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`roleid`),
  KEY `listorder` (`listorder`),
  KEY `disabled` (`disabled`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_admin_role_priv
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin_role_priv`;
CREATE TABLE `ey_admin_role_priv` (
  `roleid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `c` char(20) NOT NULL,
  `a` char(20) NOT NULL,
  KEY `roleid` (`roleid`,`c`,`a`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_category
-- ----------------------------
DROP TABLE IF EXISTS `ey_category`;
CREATE TABLE `ey_category` (
  `catid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `parentid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `catname` varchar(30) NOT NULL,
  `description` mediumtext NOT NULL,
  `url` varchar(100) NOT NULL,
  `setting` mediumtext NOT NULL,
  `listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_category_priv
-- ----------------------------
DROP TABLE IF EXISTS `ey_category_priv`;
CREATE TABLE `ey_category_priv` (
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `roleid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `action` char(30) NOT NULL,
  KEY `catid` (`catid`,`roleid`,`is_admin`,`action`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_comment
-- ----------------------------
DROP TABLE IF EXISTS `ey_comment`;
CREATE TABLE `ey_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) DEFAULT '0' COMMENT '用户ID',
  `news_id` int(10) DEFAULT '0' COMMENT '文章ID',
  `content` text COMMENT '评论内容',
  `top_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞记录数',
  `add_time` int(10) DEFAULT '0' COMMENT '评论时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `news_id` (`news_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户评论表';

-- ----------------------------
-- Table structure for ey_comment_top
-- ----------------------------
DROP TABLE IF EXISTS `ey_comment_top`;
CREATE TABLE `ey_comment_top` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '点赞用户ID',
  `comment_id` int(11) DEFAULT '0' COMMENT '点赞的评论ID',
  `add_time` int(10) DEFAULT '0' COMMENT '点赞时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论点赞记录';

-- ----------------------------
-- Table structure for ey_link
-- ----------------------------
DROP TABLE IF EXISTS `ey_link`;
CREATE TABLE `ey_link` (
  `linkid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `linktype` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `introduce` text NOT NULL,
  `listorder` smallint(5) unsigned NOT NULL DEFAULT '0',
  `passed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_log
-- ----------------------------
DROP TABLE IF EXISTS `ey_log`;
CREATE TABLE `ey_log` (
  `logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `controller` varchar(15) NOT NULL,
  `action` varchar(20) NOT NULL,
  `querystring` mediumtext NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`logid`),
  KEY `module` (`controller`,`action`) USING BTREE,
  KEY `username` (`username`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_menu
-- ----------------------------
DROP TABLE IF EXISTS `ey_menu`;
CREATE TABLE `ey_menu` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(40) NOT NULL DEFAULT '',
  `parentid` smallint(6) NOT NULL DEFAULT '0',
  `c` char(20) NOT NULL DEFAULT '',
  `a` char(20) NOT NULL DEFAULT '',
  `data` char(255) NOT NULL DEFAULT '',
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `listorder` smallint(6) unsigned NOT NULL DEFAULT '0',
  `display` enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `listorder` (`listorder`),
  KEY `parentid` (`parentid`),
  KEY `module` (`c`,`a`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_news
-- ----------------------------
DROP TABLE IF EXISTS `ey_news`;
CREATE TABLE `ey_news` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL DEFAULT '',
  `style` char(24) NOT NULL DEFAULT '',
  `thumb` varchar(100) NOT NULL DEFAULT '',
  `cover` varchar(100) NOT NULL DEFAULT '',
  `keywords` char(40) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `content` mediumtext NOT NULL,
  `url` char(100) NOT NULL,
  `listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `islink` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL,
  `top_num` int(10) unsigned NOT NULL DEFAULT '0',
  `comment_num` int(10) unsigned NOT NULL DEFAULT '0',
  `inputtime` int(10) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`,`listorder`,`id`) USING BTREE,
  KEY `listorder` (`catid`,`status`,`listorder`,`id`) USING BTREE,
  KEY `catid` (`catid`,`status`,`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_news_top
-- ----------------------------
DROP TABLE IF EXISTS `ey_news_top`;
CREATE TABLE `ey_news_top` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0' COMMENT '点赞用户ID',
  `news_id` int(11) DEFAULT '0' COMMENT '点赞的新闻ID',
  `add_time` int(10) DEFAULT '0' COMMENT '点赞时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='新闻点赞记录';

-- ----------------------------
-- Table structure for ey_node
-- ----------------------------
DROP TABLE IF EXISTS `ey_node`;
CREATE TABLE `ey_node` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `node_name` varchar(155) NOT NULL DEFAULT '' COMMENT '节点名称',
  `module_name` varchar(155) NOT NULL DEFAULT '' COMMENT '模块名',
  `control_name` varchar(155) NOT NULL DEFAULT '' COMMENT '控制器名',
  `action_name` varchar(155) NOT NULL COMMENT '方法名',
  `is_menu` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否是菜单项 1不是 2是',
  `typeid` int(11) NOT NULL COMMENT '父级节点id',
  `style` varchar(155) DEFAULT '' COMMENT '菜单样式',
  `sort` smallint(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_page
-- ----------------------------
DROP TABLE IF EXISTS `ey_page`;
CREATE TABLE `ey_page` (
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(160) NOT NULL,
  `keywords` varchar(40) NOT NULL,
  `content` text NOT NULL,
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `catid` (`catid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_role
-- ----------------------------
DROP TABLE IF EXISTS `ey_role`;
CREATE TABLE `ey_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `rolename` varchar(155) NOT NULL COMMENT '角色名称',
  `rule` varchar(255) DEFAULT '' COMMENT '权限节点数据',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_setting
-- ----------------------------
DROP TABLE IF EXISTS `ey_setting`;
CREATE TABLE `ey_setting` (
  `key` varchar(50) NOT NULL,
  `value` varchar(5000) DEFAULT '',
  PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ey_times
-- ----------------------------
DROP TABLE IF EXISTS `ey_times`;
CREATE TABLE `ey_times` (
  `username` char(40) NOT NULL,
  `ip` char(15) NOT NULL,
  `logintime` int(10) unsigned NOT NULL DEFAULT '0',
  `isadmin` tinyint(1) NOT NULL DEFAULT '0',
  `times` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`,`isadmin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_alliance_pending
-- ----------------------------
DROP TABLE IF EXISTS `t_alliance_pending`;
CREATE TABLE `t_alliance_pending` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `alliance_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `club_admin_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `chk_status` tinyint(1) unsigned DEFAULT '1' COMMENT '审核状态 1通过 2未通过',
  `reason` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=738 DEFAULT CHARSET=utf8 COMMENT='存储玩家申请加入俱乐部批复结果';

-- ----------------------------
-- Table structure for t_card_heap
-- ----------------------------
DROP TABLE IF EXISTS `t_card_heap`;
CREATE TABLE `t_card_heap` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(40) DEFAULT '0' COMMENT '牌局的uuid',
  `card_heap` varchar(256) DEFAULT NULL COMMENT '加密后的牌堆',
  PRIMARY KEY (`id`),
  KEY `club_id` (`uuid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2648059 DEFAULT CHARSET=utf8 COMMENT='牌堆信息表';

-- ----------------------------
-- Table structure for t_club_msg_content
-- ----------------------------
DROP TABLE IF EXISTS `t_club_msg_content`;
CREATE TABLE `t_club_msg_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `msg` varchar(256) DEFAULT '' COMMENT '聊天内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2974 DEFAULT CHARSET=utf8 COMMENT='存储俱乐部待发送的聊天内容';

-- ----------------------------
-- Table structure for t_club_pending
-- ----------------------------
DROP TABLE IF EXISTS `t_club_pending`;
CREATE TABLE `t_club_pending` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `chk_status` tinyint(1) unsigned DEFAULT '1' COMMENT '审核状态 1通过 2未通过',
  `reason` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=689 DEFAULT CHARSET=utf8 COMMENT='存储玩家申请加入俱乐部批复结果';

-- ----------------------------
-- Table structure for t_club_pending_msg
-- ----------------------------
DROP TABLE IF EXISTS `t_club_pending_msg`;
CREATE TABLE `t_club_pending_msg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `receiver_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `msg_id` int(11) unsigned zerofill DEFAULT NULL COMMENT '聊天内容id',
  `chat_time` int(10) unsigned DEFAULT '0' COMMENT '聊天时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33747 DEFAULT CHARSET=utf8 COMMENT='存储俱乐部待发送的聊天内容';

-- ----------------------------
-- Table structure for t_jackpot
-- ----------------------------
DROP TABLE IF EXISTS `t_jackpot`;
CREATE TABLE `t_jackpot` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `blind_level` int(3) unsigned DEFAULT '0' COMMENT '盲注级别',
  `amount` int(11) unsigned DEFAULT '0' COMMENT '奖池数额',
  `scale` int(11) unsigned DEFAULT '0' COMMENT '盈利抽成规模',
  `drawin_amount` int(11) unsigned DEFAULT '0' COMMENT '盈利抽成数额',
  PRIMARY KEY (`id`),
  KEY `user_id` (`blind_level`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=489 DEFAULT CHARSET=utf8 COMMENT='jackpot基本信息表';

-- ----------------------------
-- Table structure for t_jackpot_club
-- ----------------------------
DROP TABLE IF EXISTS `t_jackpot_club`;
CREATE TABLE `t_jackpot_club` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部id',
  `reward_percent` int(3) unsigned DEFAULT '0' COMMENT 'jackpot奖励给俱乐部的比例',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8 COMMENT='jackpot牌型比例表';

-- ----------------------------
-- Table structure for t_jackpot_record
-- ----------------------------
DROP TABLE IF EXISTS `t_jackpot_record`;
CREATE TABLE `t_jackpot_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `room_creater_uid` int(11) unsigned DEFAULT '0' COMMENT '牌型奖励比例',
  `room_uintid` int(11) unsigned DEFAULT '0' COMMENT '手牌牌型',
  `card_uintid` int(11) unsigned DEFAULT '0' COMMENT '牌型奖励比例',
  `time` int(11) unsigned DEFAULT NULL,
  `blind_level` tinyint(3) unsigned DEFAULT NULL,
  `hand_level` tinyint(3) unsigned DEFAULT NULL,
  `award_amount` int(11) unsigned DEFAULT '0' COMMENT '牌型奖励比例',
  `award_uid` int(11) unsigned DEFAULT '0' COMMENT '牌型奖励比例',
  PRIMARY KEY (`id`),
  KEY `user_id` (`room_uintid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=716 DEFAULT CHARSET=utf8 COMMENT='jackpot奖金发放记录表';

-- ----------------------------
-- Table structure for t_jackpot_setting
-- ----------------------------
DROP TABLE IF EXISTS `t_jackpot_setting`;
CREATE TABLE `t_jackpot_setting` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `hand_level` int(2) unsigned DEFAULT '0' COMMENT '手牌牌型',
  `reward_percent` int(3) unsigned DEFAULT '0' COMMENT '牌型奖励比例',
  PRIMARY KEY (`id`),
  KEY `user_id` (`hand_level`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8 COMMENT='jackpot牌型比例表';

-- ----------------------------
-- Table structure for t_leavealliance_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_leavealliance_notice`;
CREATE TABLE `t_leavealliance_notice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `alliance_id` int(11) unsigned DEFAULT '0' COMMENT '申请人ID',
  `club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `club_admin_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
  `alliance_name` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  `club_name` varchar(32) DEFAULT '' COMMENT '申请消息内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=717 DEFAULT CHARSET=utf8 COMMENT='存储玩家申请加入俱乐部批复结果';

-- ----------------------------
-- Table structure for t_user_buyin_gold
-- ----------------------------
DROP TABLE IF EXISTS `t_user_buyin_gold`;
CREATE TABLE `t_user_buyin_gold` (
	`user_id` int(11) unsigned DEFAULT '0' COMMENT '玩家ID',
	`left_gold` int(11) unsigned DEFAULT '0' COMMENT '玩家当前剩余买入金币',
	`room_id` int(11) unsigned DEFAULT '0' COMMENT '当前玩家所在房间id',
	PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='存储玩家买入金币的剩余值';

-- ----------------------------
-- Table structure for dtb_grant_gold_record
-- ----------------------------
DROP TABLE IF EXISTS `dtb_grant_gold_record`;
CREATE TABLE `dtb_grant_gold_record` (
	`id_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
	`club_name` varchar(32) DEFAULT '' COMMENT '俱乐部名称',
	`creater_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐创建者ID',
	`target_id` int(11) unsigned DEFAULT '0' COMMENT '转账目标ID',
	`operator_id` int(11) unsigned DEFAULT '0' COMMENT '转账者ID',
	`amount` int(11) unsigned DEFAULT '0' COMMENT '转账数量',
	`grant_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '批准时间',
	`operator_name` varchar(155) NOT NULL COMMENT '操作者角色名称',
	`target_name` varchar(155) NOT NULL COMMENT '目标角色名称',
	PRIMARY KEY (`id_index`)

) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='存储俱乐部转账记录';

-- ----------------------------
-- Table structure for dtb_grant_gold_notify_record
-- ----------------------------
DROP TABLE IF EXISTS `dtb_grant_gold_notify_record`;
CREATE TABLE `dtb_grant_gold_notify_record` (
	`id_index` int(11) unsigned NOT NULL AUTO_INCREMENT,
	`club_id` int(11) unsigned DEFAULT '0' COMMENT '俱乐部ID',
	`target_id` int(11) unsigned DEFAULT '0' COMMENT '转账目标ID',
	`operator_id` int(11) unsigned DEFAULT '0' COMMENT '转账者ID',
	`amount` int(11) unsigned DEFAULT '0' COMMENT '转账数量',
	`current_gold` int(11) unsigned DEFAULT '0' COMMENT '转账后数量',
	PRIMARY KEY (`id_index`)

) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='存储俱乐部转账通知记录';