/*
 Navicat Premium Data Transfer

 Source Server         : real-km-live
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : hk-cdb-7zzosz55.sql.tencentcdb.com:63686
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 08/04/2021 14:44:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cmf_admin_log
-- ----------------------------
CREATE TABLE `cmf_admin_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL COMMENT '管理员ID',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '管理员',
  `action` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '操作内容',
  `ip` bigint(20) NOT NULL COMMENT 'IP地址',
  `addtime` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_admin_menu
-- ----------------------------
CREATE TABLE `cmf_admin_menu`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父菜单id',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态;1:显示,0:不显示',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `app` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用名',
  `controller` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '控制器名',
  `action` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作名称',
  `param` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '额外参数',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `icon` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `status`(`status`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `controller`(`controller`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '后台菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_agent
-- ----------------------------
CREATE TABLE `cmf_agent`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `one_uid` int(11) NOT NULL DEFAULT 0 COMMENT '上级用户id',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_agent_code
-- ----------------------------
CREATE TABLE `cmf_agent_code`  (
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '邀请码',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_agent_profit
-- ----------------------------
CREATE TABLE `cmf_agent_profit`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT 0 COMMENT '用户ID',
  `one_profit` decimal(65, 2) DEFAULT 0.00 COMMENT '一级收益',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_agent_profit_recode
-- ----------------------------
CREATE TABLE `cmf_agent_profit_recode`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT 0 COMMENT '用户ID',
  `total` int(11) DEFAULT 0 COMMENT '消费总数',
  `one_uid` int(11) DEFAULT 0 COMMENT '一级ID',
  `one_profit` decimal(65, 2) DEFAULT 0.00 COMMENT '一级收益',
  `addtime` int(11) DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_anchor_auth
-- ----------------------------
CREATE TABLE `cmf_anchor_auth`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：1正常  0禁用',
  `addtime` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_asset
-- ----------------------------
CREATE TABLE `cmf_asset`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
  `file_size` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小,单位B',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上传时间',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态;1:可用,0:不可用',
  `download_times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '下载次数',
  `file_key` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件惟一码',
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
  `file_path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径,相对于upload目录,可以为url',
  `file_md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件md5值',
  `file_sha1` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `suffix` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '文件后缀名,不包括点',
  `more` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '其它详细信息,JSON格式',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '资源表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_auth_access
-- ----------------------------
CREATE TABLE `cmf_auth_access`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` int(10) UNSIGNED NOT NULL COMMENT '角色',
  `rule_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `rule_name`(`rule_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限授权表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_auth_rule
-- ----------------------------
CREATE TABLE `cmf_auth_rule`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否有效(0:无效,1:有效)',
  `app` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '规则所属app',
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '权限规则分类，请加应用前缀,如admin_',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `param` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '额外url参数',
  `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则描述',
  `condition` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  INDEX `module`(`app`, `status`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '权限规则表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_avatar
-- ----------------------------
CREATE TABLE `cmf_avatar`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户头像',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户头像表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_backpack
-- ----------------------------
CREATE TABLE `cmf_backpack`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `giftid` int(11) NOT NULL DEFAULT 0 COMMENT '礼物ID',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_balance_charge_admin
-- ----------------------------
CREATE TABLE `cmf_balance_charge_admin`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '充值对象ID',
  `balance` int(20) NOT NULL DEFAULT 0 COMMENT '金额',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '管理员',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'IP',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_car
-- ----------------------------
CREATE TABLE `cmf_car`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片链接',
  `swf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '动画链接',
  `swftime` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '动画时长',
  `needcoin` int(20) NOT NULL DEFAULT 0 COMMENT '价格',
  `score` int(11) NOT NULL DEFAULT 0 COMMENT '积分价格',
  `list_order` int(10) NOT NULL DEFAULT 9999 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `words` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '进场话术',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_car_user
-- ----------------------------
CREATE TABLE `cmf_car_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `carid` int(11) NOT NULL DEFAULT 0 COMMENT '坐骑ID',
  `endtime` int(11) NOT NULL DEFAULT 0 COMMENT '到期时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_cash_account
-- ----------------------------
CREATE TABLE `cmf_cash_account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型，1表示支付宝，2表示微信，3表示银行卡',
  `account_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '银行名称',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '账号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id_uid`(`id`, `uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_cash_record
-- ----------------------------
CREATE TABLE `cmf_cash_record`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `money` int(20) NOT NULL DEFAULT 0 COMMENT '提现金额',
  `votes` int(20) NOT NULL DEFAULT 0 COMMENT '提现映票数',
  `orderno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `trade_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方订单号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态，0审核中，1审核通过，2审核拒绝',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '账号类型',
  `account_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '银行名称',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '帐号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_charge_admin
-- ----------------------------
CREATE TABLE `cmf_charge_admin`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '充值对象ID',
  `coin` int(20) NOT NULL DEFAULT 0 COMMENT '钻石数',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '管理员',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'IP',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_charge_rules
-- ----------------------------
CREATE TABLE `cmf_charge_rules`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '钻石数',
  `coin_ios` int(11) NOT NULL DEFAULT 0 COMMENT '苹果钻石数',
  `money` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '安卓金额',
  `product_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '苹果项目ID',
  `give` int(11) NOT NULL DEFAULT 0 COMMENT '赠送钻石数',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_charge_user
-- ----------------------------
CREATE TABLE `cmf_charge_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '充值对象ID',
  `money` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '钻石数',
  `coin_give` int(11) NOT NULL DEFAULT 0 COMMENT '赠送钻石数',
  `orderno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商家订单号',
  `trade_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方平台订单号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '支付类型',
  `ambient` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付环境',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_battle_live
-- ----------------------------
CREATE TABLE `cmf_csgo_battle_live`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `counter_terrorist_team_id` bigint(20) DEFAULT 0 COMMENT 'CT方战队ID',
  `counter_terrorist_team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'CT方战队名称',
  `counter_terrorist_team_score` int(11) DEFAULT 0 COMMENT 'CT方战队得分',
  `terrorist_team_id` bigint(20) DEFAULT 0 COMMENT 'T方战队ID',
  `terrorist_team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'T方战队名称',
  `terrorist_team_score` int(11) DEFAULT 0 COMMENT 'T方战队得分',
  `map_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '地图名称',
  `is_frozen` tinyint(1) DEFAULT 0 COMMENT '是否冻结',
  `is_bomb_planted` tinyint(1) DEFAULT 0 COMMENT '炸弹是否放置',
  `current_round` int(11) DEFAULT 0 COMMENT '当前轮次',
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `counter_terrorist_players` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'CT方队员数据',
  `terrorist_players` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'T方队员数据',
  `counter_terrorist_round_history_first_half` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'CT方上半场胜利记录lost：输；CTs_win：CT方获胜； Terrorists_Win：T方获胜；Target_Bombed：炸弹爆炸；Bomb_Defused：炸弹拆除；target_saved：解救人质',
  `counter_terrorist_round_history_second_half` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'CT方下半场胜利记录lost：输；CTs_win：CT方获胜； Terrorists_Win：T方获胜；Target_Bombed：炸弹爆炸；Bomb_Defused：炸弹拆除；target_saved：解救人质',
  `terrorist_round_history_first_half` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'T方上半场胜利记录lost：输；CTs_win：CT方获胜； Terrorists_Win：T方获胜；Target_Bombed：炸弹爆炸；Bomb_Defused：炸弹拆除',
  `terrorist_round_history_second_half` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'T方下半场胜利记录lost：输；CTs_win：CT方获胜； Terrorists_Win：T方获胜；Target_Bombed：炸弹爆炸；Bomb_Defused：炸弹拆除',
  `first_win_five_round_team_id` bigint(20) DEFAULT 0 COMMENT '率先获得五回合胜利的队伍ID',
  `first_half_pistol_game_winner_team_id` bigint(20) DEFAULT 0 COMMENT '获得上半场手枪局胜利的队伍ID',
  `second_half_pistol_game_winner_team_id` bigint(20) DEFAULT 0 COMMENT '获得下半场手枪局胜利的队伍ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比分事件（实时）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_league
-- ----------------------------
CREATE TABLE `cmf_csgo_league`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛Logo',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛名称',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '举办国家',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '举办地',
  `prize_pool` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '奖池',
  `prizes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '获奖名单',
  `start_time` int(11) DEFAULT 0 COMMENT '联赛开始时间',
  `end_time` int(11) DEFAULT 0 COMMENT '联赛结束时间',
  `team_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '参赛战队ID列表',
  `group_stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '小组赛赛制',
  `playoffs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '淘汰赛赛制',
  `map_pool` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '地图池',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未开始 1:进行中 2:已结束 3:延期 4:已删除}',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match
-- ----------------------------
CREATE TABLE `cmf_csgo_match`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `bo` int(11) DEFAULT 0 COMMENT '赛制',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未开始 1:进行中 2:已结束 3:延时 4:已删除}',
  `match_time` int(11) DEFAULT 0 COMMENT '比赛时间',
  `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '赛程阶段名称',
  `map_bp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '地图ban pick',
  `battle_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '对局IDs',
  `is_forfeit` tinyint(1) DEFAULT 0 COMMENT '1:弃权 0:不弃权',
  `live_battle_index` int(11) DEFAULT 0 COMMENT '实时比赛的局数局数≥0，当局数=0时表示比赛没开始或无该局数据',
  `team_a_score` int(11) DEFAULT 0 COMMENT '主队得分',
  `team_a_id` bigint(20) DEFAULT 0 COMMENT '主队ID',
  `team_b_score` int(11) DEFAULT 0 COMMENT '客队得分',
  `team_b_id` bigint(20) DEFAULT 0 COMMENT '客队ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `viewnum` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '播放次数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛列表（进行中）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_battle
-- ----------------------------
CREATE TABLE `cmf_csgo_match_battle`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle_id` bigint(20) DEFAULT 0 COMMENT '战役ID',
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `map_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '该局的地图名称',
  `team_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '主队信息',
  `first_win_five_round_team_id` bigint(20) DEFAULT 0 COMMENT '率先赢得5回合队伍ID',
  `first_half_pistol_game_winner_team_id` bigint(20) DEFAULT 0 COMMENT '上半场手枪局胜利队伍ID',
  `second_half_pistol_game_winner_team_id` bigint(20) DEFAULT 0 COMMENT '下半场手枪局胜利队伍ID',
  `team_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '客队信息',
  `team_a_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '主队名称',
  `team_a_id` bigint(20) DEFAULT 0 COMMENT '主队ID',
  `team_b_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '客队名称',
  `team_b_id` bigint(20) DEFAULT 0 COMMENT '客队ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比分事件（赛后）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_battle_log
-- ----------------------------
CREATE TABLE `cmf_csgo_match_battle_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `logs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '比赛日志',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文字直播\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_bet_info
-- ----------------------------
CREATE TABLE `cmf_csgo_match_bet_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bet_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '竞猜ID',
  `match_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '比赛ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
  `end_time` bigint(20) DEFAULT 0 COMMENT '停止竞猜时间',
  `status` tinyint(1) DEFAULT 0 COMMENT '状态0:比赛尚未开始，正常更新；1:比赛开始进行，停止更新；2:结束；3:取消',
  `result_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '竞猜结果判断是否跟bet_item_id相同，返回0和空则视为null',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '来源网站',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '竞猜选项',
  `bet_type` int(11) DEFAULT 0 COMMENT '1: 全场获胜；2: 输赢（单局）；3: 全场让分；41: 全场获胜；2: 输赢（单局）；3: 手枪局获胜；4: 全场让分； 5: 让分（单局）；6: 大小分（回合总数大小）；7: 人头总数单双；8: 回合总数单双；9：第四回合胜者；10：第六回合胜者；11：第八回合胜者；12：第十回合胜者；13：是否出现加时；14：C4炸弹爆炸获胜次数最多（不含加时）；15：C4炸弹爆炸获得胜利总数大小（不含加时)；16：C4炸弹拆除次数最多队伍（不含加时）；17：C4炸弹拆除总数单双（不含加时）18：C4炸弹拆除总数大小（不含加时）；19：首先赢得五个回合；20：首先赢得十个回合；21：全场正确比分；22：全场地图总数大小',
  `board_num` int(11) DEFAULT 0 COMMENT '局数',
  `type_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '类型描述',
  `handicap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '盘口',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '早盘指数' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_bet_info_rolling
-- ----------------------------
CREATE TABLE `cmf_csgo_match_bet_info_rolling`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bet_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '竞猜ID',
  `match_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '比赛ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
  `end_time` bigint(20) DEFAULT 0 COMMENT '停止竞猜时间',
  `status` tinyint(1) DEFAULT 0 COMMENT '1:比赛开始进行，正常更新；2:结束；3:取消；4:封盘',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '来源网站',
  `result_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '竞猜结果判断是否跟bet_item_id相同，返回0和空则视为null',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '竞猜选项',
  `bet_type` int(11) DEFAULT 0 COMMENT '1: 全场获胜；2: 输赢（单局）；3: 手枪局获胜；4: 全场让分； 5: 让分（单局）；6: 大小分（回合总数大小）；7: 人头总数单双；8: 回合总数单双；9：第四回合胜者；10：第六回合胜者；11：第八回合胜者；12：第十回合胜者；13：是否出现加时；14：C4炸弹爆炸获胜次数最多（不含加时）；15：C4炸弹爆炸获得胜利总数大小（不含加时)；16：C4炸弹拆除次数最多队伍（不含加时）；17：C4炸弹拆除总数单双（不含加时）18：C4炸弹拆除总数大小（不含加时）；19：首先赢得五个回合；20：首先赢得十个回合；21：全场正确比分；22：全场地图总数大小',
  `board_num` int(11) DEFAULT 0 COMMENT '局数',
  `type_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '类型描述',
  `handicap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '盘口',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '滚球指数' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_live
-- ----------------------------
CREATE TABLE `cmf_csgo_match_live`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播平台名称',
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '直播链接',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播平台英文名称',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '赛事直播地址' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_live_score
-- ----------------------------
CREATE TABLE `cmf_csgo_match_live_score`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '比赛ID',
  `league_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '联赛id',
  `bo` int(11) NOT NULL DEFAULT 0 COMMENT '赛制',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未开始 1:进行中 2:已结束 }',
  `match_time` int(11) NOT NULL DEFAULT 0 COMMENT '比赛时间',
  `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '赛程阶段名称',
  `map_bp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '地图ban pick',
  `map_names` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '地图名称',
  `battle_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '战役IDs',
  `is_forfeit` tinyint(1) DEFAULT 0 COMMENT '1:弃权 0不弃权',
  `live_battle_index` int(11) DEFAULT 0 COMMENT '实时比赛的局数',
  `live_battle_map` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '实时比赛的地图',
  `live_map_score` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '实时地图得分',
  `team_a_score` int(11) NOT NULL DEFAULT 0 COMMENT '主队得分',
  `team_a_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '主队ID',
  `team_b_score` int(11) NOT NULL DEFAULT 0 COMMENT '客队得分',
  `team_b_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '客队ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛列表（进行中）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_match_prospect
-- ----------------------------
CREATE TABLE `cmf_csgo_match_prospect`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `past_matches` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '比赛记录',
  `vs_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '交手记录',
  `map_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '地图数据',
  `lineup` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '选手数据',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '前瞻分析' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_player
-- ----------------------------
CREATE TABLE `cmf_csgo_player`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '玩家ID',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '玩家昵称',
  `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '玩家姓名',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '头像',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '国籍',
  `age` int(11) NOT NULL DEFAULT 0 COMMENT '年龄',
  `team_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '战队ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '选手列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_player_battles
-- ----------------------------
CREATE TABLE `cmf_csgo_player_battles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle_id` bigint(20) DEFAULT 0 COMMENT '战役ID',
  `player_id` bigint(20) DEFAULT 0 COMMENT '选手ID',
  `player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '选手名称',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `kill_count` int(11) DEFAULT 0 COMMENT '杀人数',
  `death_count` int(11) DEFAULT 0 COMMENT '死亡数',
  `assist_count` int(11) DEFAULT 0 COMMENT '助攻数',
  `first_kill` int(11) DEFAULT 0 COMMENT '首杀',
  `first_death` int(11) DEFAULT 0 COMMENT '首次死亡',
  `damage_average` double(10, 3) DEFAULT 0.000 COMMENT '局均伤害',
  `kast` double(10, 3) DEFAULT 0.000 COMMENT 'KAST=kill assist survive trade 也就是 杀敌、助攻、存活、人数互换。指的是该选手完成这四项指标中任意一项的回合数与总回合数的比率。这个“人数互换”就是指选手死后不论造成伤害的多少，只要能使队友在短时间内将敌方杀死即可。举例来说就是队伍的突破手用生命拉出了一片天，就算他没重伤敌人，只要队友抓住时机补枪完成人数互换，突破手就算“换人成功”。由此我们可以得知，KAST比率越高，表示这名选手对团队贡献的效率越高。',
  `fk_diff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'first kill/death 差值',
  `kd_diff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'kill/death 差值',
  `rating` double(10, 3) DEFAULT 0.000 COMMENT '评分',
  `headshot_count` int(11) DEFAULT 0 COMMENT '爆头数',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛统计（战队）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_player_rank
-- ----------------------------
CREATE TABLE `cmf_csgo_player_rank`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` bigint(20) DEFAULT 0 COMMENT '玩家ID',
  `player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '选手名称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '头像',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '国籍',
  `rating` double(10, 3) DEFAULT 0.000 COMMENT '评分',
  `maps_count` int(11) DEFAULT 0 COMMENT '地图数量',
  `rank` int(11) DEFAULT 0 COMMENT '排名',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '选手排行榜\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_player_stat
-- ----------------------------
CREATE TABLE `cmf_csgo_player_stat`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` bigint(20) DEFAULT 0 COMMENT '选手ID',
  `kill_count` int(11) DEFAULT 0 COMMENT '杀人次数',
  `death_count` int(11) DEFAULT 0 COMMENT '死亡数',
  `kill_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均杀人数',
  `assist_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均助攻数',
  `death_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均死亡数',
  `kd_ratio` double(10, 3) DEFAULT 0.000 COMMENT '杀人数/死亡数比率',
  `damage_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均伤害',
  `grenade_damage_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均手雷伤害',
  `saved_by_teammate_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均被队友救起',
  `saved_teammate_average` double(10, 3) DEFAULT 0.000 COMMENT '轮均救起队友',
  `rating` double(10, 3) DEFAULT 0.000 COMMENT '评分',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '综合统计（选手）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_player_stats
-- ----------------------------
CREATE TABLE `cmf_csgo_player_stats`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `player_id` bigint(20) DEFAULT 0 COMMENT '选手ID',
  `player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '选手名称',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `kill_count` int(11) DEFAULT 0 COMMENT '杀人数',
  `death_count` int(11) DEFAULT 0 COMMENT '死亡数',
  `assist_count` int(11) DEFAULT 0 COMMENT '助攻数',
  `first_kill` int(11) DEFAULT 0 COMMENT '首杀',
  `first_death` int(11) DEFAULT 0 COMMENT '首次死亡',
  `flash_assist_count` int(11) DEFAULT 0 COMMENT '闪光弹助攻数',
  `headshot_count` int(11) DEFAULT 0 COMMENT '爆头数',
  `damage_average` double(10, 3) DEFAULT 0.000 COMMENT '局均伤害',
  `kast` double(10, 3) DEFAULT 0.000 COMMENT 'KAST=kill assist survive trade 也就是 杀敌、助攻、存活、人数互换。指的是该选手完成这四项指标中任意一项的回合数与总回合数的比率。这个“人数互换”就是指选手死后不论造成伤害的多少，只要能使队友在短时间内将敌方杀死即可。举例来说就是队伍的突破手用生命拉出了一片天，就算他没重伤敌人，只要队友抓住时机补枪完成人数互换，突破手就算“换人成功”。由此我们可以得知，KAST比率越高，表示这名选手对团队贡献的效率越高。',
  `fk_diff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'first kill/death 差值',
  `kd_diff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'kill/death 差值',
  `rating` double(10, 3) DEFAULT 0.000 COMMENT '评分',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛统计（选手）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_team
-- ----------------------------
CREATE TABLE `cmf_csgo_team`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队Logo',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队所属国家',
  `world_rank` bigint(20) DEFAULT 0 COMMENT '队名简称',
  `week_in_top30` bigint(20) DEFAULT 0 COMMENT '排名前30所占周数',
  `player_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '选手IDs',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '战队列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_team_rank
-- ----------------------------
CREATE TABLE `cmf_csgo_team_rank`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '战队ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '战队名称',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '战队Logo',
  `points` int(11) NOT NULL DEFAULT 0 COMMENT '战队得分',
  `rank` int(11) NOT NULL DEFAULT 0 COMMENT '战队排名',
  `rank_changed` bigint(20) NOT NULL DEFAULT 0 COMMENT '排名变化',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '战队排行榜\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_team_stats
-- ----------------------------
CREATE TABLE `cmf_csgo_team_stats`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `win_count` int(11) DEFAULT 0 COMMENT '获胜次数',
  `lost_count` int(11) DEFAULT 0 COMMENT '失败次数',
  `draw_count` int(11) DEFAULT NULL COMMENT '平局次数',
  `kill_count` int(11) DEFAULT 0 COMMENT '杀人次数',
  `death_count` int(11) DEFAULT 0 COMMENT '死亡数',
  `round_count` int(11) DEFAULT 0 COMMENT '参加轮次数',
  `map_count` int(11) DEFAULT 0 COMMENT '参加地图数',
  `current_lineup` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '当前阵容（选手IDs）',
  `historic_lineup` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '历史阵容（选手IDs）',
  `standins` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '替补阵容（选手IDs）',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '综合统计（战队）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_csgo_weapon_rank
-- ----------------------------
CREATE TABLE `cmf_csgo_weapon_rank`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '武器名称',
  `pick_rate` double(10, 3) DEFAULT 0.000 COMMENT '选取率',
  `rank` int(11) DEFAULT 0 COMMENT '排名',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '武器排行榜\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic
-- ----------------------------
CREATE TABLE `cmf_dynamic`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
  `thumb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '图片地址：多张图片用分号隔开',
  `video_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '视频封面',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '视频地址',
  `voice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '语音链接',
  `length` int(11) DEFAULT 0 COMMENT '语音时长',
  `likes` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `comments` int(11) NOT NULL DEFAULT 0 COMMENT '评论数',
  `type` int(10) NOT NULL DEFAULT 0 COMMENT '动态类型：0：纯文字；1：文字+图片；2：文字+视频；3：文字+语音',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 1删除（下架）0不下架',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '视频状态 0未审核 1通过 2拒绝',
  `uptime` int(12) DEFAULT 0 COMMENT '审核不通过时间（第一次审核不通过时更改此值，用于判断是否发送极光IM）',
  `xiajia_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '下架原因',
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '维度',
  `lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '经度',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '城市',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '详细地理位置',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '发布时间',
  `fail_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '审核原因',
  `show_val` int(12) NOT NULL DEFAULT 0 COMMENT '曝光值',
  `recommend_val` int(20) DEFAULT 0 COMMENT '推荐值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic_comments
-- ----------------------------
CREATE TABLE `cmf_dynamic_comments`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '评论用户ID',
  `touid` int(10) NOT NULL DEFAULT 0 COMMENT '被评论用户ID',
  `dynamicid` int(10) NOT NULL DEFAULT 0 COMMENT '动态ID',
  `commentid` int(10) NOT NULL DEFAULT 0 COMMENT '评论iD',
  `parentid` int(10) NOT NULL DEFAULT 0 COMMENT '上级评论ID',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '评论内容',
  `likes` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '提交时间',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型，0文字1语音',
  `voice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '语音链接',
  `length` int(11) NOT NULL DEFAULT 0 COMMENT '时长',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic_comments_like
-- ----------------------------
CREATE TABLE `cmf_dynamic_comments_like`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '点赞用户ID',
  `commentid` int(10) NOT NULL DEFAULT 0 COMMENT '评论ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '提交时间',
  `touid` int(12) NOT NULL DEFAULT 0 COMMENT '被喜欢的评论者id',
  `dynamicid` int(12) NOT NULL DEFAULT 0 COMMENT '评论所属动态id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic_like
-- ----------------------------
CREATE TABLE `cmf_dynamic_like`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '点赞用户',
  `dynamicid` int(10) NOT NULL DEFAULT 0 COMMENT '动态id',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '点赞时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '动态是否被删除或被拒绝 0被删除或被拒绝 1 正常',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic_report
-- ----------------------------
CREATE TABLE `cmf_dynamic_report`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '举报用户ID',
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '被举报用户ID',
  `dynamicid` int(11) NOT NULL DEFAULT 0 COMMENT '动态ID',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '举报内容',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0处理中 1已处理  2审核失败',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '提交时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `dynamic_type` int(10) NOT NULL DEFAULT 0 COMMENT '动态类型：0：纯文字；1：文字+图片‘；2：视频+图片；3：语音+图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_dynamic_report_classify
-- ----------------------------
CREATE TABLE `cmf_dynamic_report_classify`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `list_order` int(10) NOT NULL DEFAULT 10000 COMMENT '排序',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '举报类型名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_family
-- ----------------------------
CREATE TABLE `cmf_family`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '家族名称',
  `badge` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '家族图标',
  `apply_pos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '身份证正面',
  `apply_side` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '身份证背面',
  `briefing` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '简介',
  `carded` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '证件号',
  `fullname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
  `state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '申请状态 0未审核 1 审核失败 2 审核通过 3',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '失败原因',
  `disable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用',
  `divide_family` int(11) NOT NULL DEFAULT 0 COMMENT '分成比例',
  `istip` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要通知',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_family_profit
-- ----------------------------
CREATE TABLE `cmf_family_profit`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '主播ID',
  `familyid` int(11) NOT NULL DEFAULT 0 COMMENT '家族ID',
  `time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '格式化日期',
  `profit_anthor` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '主播收益',
  `total` int(11) NOT NULL DEFAULT 0 COMMENT '总收益',
  `profit` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '家族收益',
  `addtime` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_family_user
-- ----------------------------
CREATE TABLE `cmf_family_user`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `familyid` int(11) NOT NULL DEFAULT 0 COMMENT '家族ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原因',
  `state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态',
  `signout` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否退出',
  `istip` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核后是否需要通知',
  `signout_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '踢出或拒绝理由',
  `signout_istip` tinyint(4) NOT NULL DEFAULT 0 COMMENT '踢出或拒绝是否需要通知',
  `divide_family` int(11) NOT NULL DEFAULT -1 COMMENT '家族分成',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_family_user_divide_apply
-- ----------------------------
CREATE TABLE `cmf_family_user_divide_apply`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',
  `familyid` int(11) NOT NULL DEFAULT 0 COMMENT '家族id',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '处理状态 0 等待审核 1 同意 -1 拒绝',
  `divide` int(11) NOT NULL DEFAULT 0 COMMENT '家族分成',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_feedback
-- ----------------------------
CREATE TABLE `cmf_feedback`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '系统版本号',
  `model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '设备',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内容',
  `addtime` int(11) NOT NULL COMMENT '提交时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_game
-- ----------------------------
CREATE TABLE `cmf_game`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` tinyint(1) DEFAULT 0 COMMENT '游戏名称',
  `liveuid` int(11) DEFAULT 0 COMMENT '主播ID',
  `bankerid` int(11) DEFAULT 0 COMMENT '庄家ID，0表示平台',
  `stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播流名',
  `starttime` int(11) DEFAULT 0 COMMENT '本次游戏开始时间',
  `endtime` int(11) DEFAULT 0 COMMENT '游戏结束时间',
  `result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '本轮游戏结果',
  `state` tinyint(1) DEFAULT 0 COMMENT '当前游戏状态（0是进行中，1是正常结束，2是 主播关闭 3意外结束）',
  `banker_profit` int(11) DEFAULT 0 COMMENT '庄家收益',
  `banker_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '庄家牌型',
  `isintervene` tinyint(1) DEFAULT 0 COMMENT '是否进行系统干预',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_gamerecord
-- ----------------------------
CREATE TABLE `cmf_gamerecord`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` tinyint(1) DEFAULT 0 COMMENT '游戏类型',
  `uid` int(11) DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(11) DEFAULT 0 COMMENT '主播ID',
  `gameid` int(11) DEFAULT 0 COMMENT '游戏ID',
  `coin_1` int(11) DEFAULT 0 COMMENT '1位置下注金额',
  `coin_2` int(11) DEFAULT 0 COMMENT '2位置下注金额',
  `coin_3` int(11) DEFAULT 0 COMMENT '3位置下注金额',
  `coin_4` int(11) DEFAULT 0 COMMENT '4位置下注金额',
  `coin_5` int(11) DEFAULT 0 COMMENT '5位置下注金额',
  `coin_6` int(11) DEFAULT 0 COMMENT '6位置下注金额',
  `status` tinyint(1) DEFAULT 0 COMMENT '处理状态 0 未处理 1 已处理',
  `addtime` int(11) DEFAULT 0 COMMENT '下注时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_getcode_limit_ip
-- ----------------------------
CREATE TABLE `cmf_getcode_limit_ip`  (
  `ip` bigint(20) NOT NULL COMMENT 'ip地址',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '时间',
  `times` tinyint(4) NOT NULL DEFAULT 0 COMMENT '次数',
  PRIMARY KEY (`ip`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_gift
-- ----------------------------
CREATE TABLE `cmf_gift`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mark` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标识，0普通，1热门，2守护',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型,0普通礼物，1豪华礼物',
  `sid` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
  `giftname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `needcoin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `gifticon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片',
  `list_order` int(3) NOT NULL DEFAULT 9999 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `swftype` tinyint(1) NOT NULL DEFAULT 0 COMMENT '动画类型，0gif,1svga',
  `swf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '动画链接',
  `swftime` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '动画时长',
  `isplatgift` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否全站礼物：0：否；1：是',
  `sticker_id` int(11) NOT NULL DEFAULT 0 COMMENT '贴纸ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_gift_luck_rate
-- ----------------------------
CREATE TABLE `cmf_gift_luck_rate`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `giftid` int(11) NOT NULL DEFAULT 0 COMMENT '礼物ID',
  `nums` int(10) UNSIGNED NOT NULL COMMENT '数量',
  `times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '倍数',
  `rate` decimal(20, 3) NOT NULL DEFAULT 0.000 COMMENT '中奖概率',
  `isall` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否全站，0否1是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_gift_sort
-- ----------------------------
CREATE TABLE `cmf_gift_sort`  (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `sortname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名',
  `orderno` int(3) NOT NULL DEFAULT 0 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_guard
-- ----------------------------
CREATE TABLE `cmf_guard`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '守护名称',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '守护类型，1普通2尊贵',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `length_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '时长类型，0天，1月，2年',
  `length` int(11) NOT NULL DEFAULT 0 COMMENT '时长',
  `length_time` int(11) NOT NULL DEFAULT 0 COMMENT '时长秒数',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_guard_user
-- ----------------------------
CREATE TABLE `cmf_guard_user`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(11) NOT NULL DEFAULT 0 COMMENT '主播ID',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '守护类型,1普通守护，2尊贵守护',
  `endtime` int(11) NOT NULL DEFAULT 0 COMMENT '到期时间',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `liveuid_index`(`liveuid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_guide
-- ----------------------------
CREATE TABLE `cmf_guide`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片/视频链接',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '跳转链接',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型',
  `list_order` int(11) NOT NULL DEFAULT 10000 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_hook
-- ----------------------------
CREATE TABLE `cmf_hook`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子)',
  `once` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否只允许一个插件运行(0:多个;1:一个)',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '钩子名称',
  `hook` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '钩子',
  `app` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '应用名(只有应用钩子才用)',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统钩子表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_hook_plugin
-- ----------------------------
CREATE TABLE `cmf_hook_plugin`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态(0:禁用,1:启用)',
  `hook` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '钩子名',
  `plugin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '插件',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统钩子插件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_jackpot
-- ----------------------------
CREATE TABLE `cmf_jackpot`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `total` bigint(20) NOT NULL DEFAULT 0 COMMENT '奖池金额',
  `level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '奖池等级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_jackpot_level
-- ----------------------------
CREATE TABLE `cmf_jackpot_level`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `levelid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
  `level_up` int(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '经验下限',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_jackpot_rate
-- ----------------------------
CREATE TABLE `cmf_jackpot_rate`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `giftid` int(11) NOT NULL DEFAULT 0 COMMENT '礼物ID',
  `nums` int(10) UNSIGNED NOT NULL COMMENT '数量',
  `rate_jackpot` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '奖池概率',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_label
-- ----------------------------
CREATE TABLE `cmf_label`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标签名称',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  `colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '颜色',
  `colour2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '尾色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_label_user
-- ----------------------------
CREATE TABLE `cmf_label_user`  (
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '对方ID',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '选择的标签',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  INDEX `uid_touid_index`(`uid`, `touid`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE,
  INDEX `touid`(`touid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_level
-- ----------------------------
CREATE TABLE `cmf_level`  (
  `levelid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
  `levelname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '等级名称',
  `level_up` int(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '经验上限',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标识',
  `colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '昵称颜色',
  `thumb_mark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '头像角标',
  `bg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '背景',
  PRIMARY KEY (`id`, `levelid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_level_anchor
-- ----------------------------
CREATE TABLE `cmf_level_anchor`  (
  `levelid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
  `levelname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '等级名称',
  `level_up` int(20) UNSIGNED DEFAULT 0 COMMENT '等级上限',
  `addtime` int(11) DEFAULT 0 COMMENT '添加时间',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标识',
  `thumb_mark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '头像角标',
  `bg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '背景',
  PRIMARY KEY (`id`, `levelid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_liang
-- ----------------------------
CREATE TABLE `cmf_liang`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '靓号',
  `length` int(11) NOT NULL DEFAULT 0 COMMENT '长度',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `score` int(11) NOT NULL DEFAULT 0 COMMENT '积分价格',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '购买用户ID',
  `buytime` int(11) NOT NULL DEFAULT 0 COMMENT '购买时间',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '靓号销售状态',
  `state` tinyint(4) NOT NULL DEFAULT 0 COMMENT '启用状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_link
-- ----------------------------
CREATE TABLE `cmf_link`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态;1:显示;0:不显示',
  `rating` int(11) NOT NULL DEFAULT 0 COMMENT '友情链接评级',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '友情链接描述',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '友情链接地址',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '友情链接名称',
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '友情链接图标',
  `target` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `rel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '链接与网站的关系',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '友情链接表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live
-- ----------------------------
CREATE TABLE `cmf_live`  (
  `uid` int(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `showid` int(12) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `islive` int(1) NOT NULL DEFAULT 0 COMMENT '直播状态',
  `starttime` int(12) NOT NULL DEFAULT 0 COMMENT '开播时间',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '城市',
  `txzb_order` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用于直播排序',
  `stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '流名',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面图',
  `pull` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '播流地址',
  `third_pull` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '第三方播流地址',
  `lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '经度',
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '维度',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '直播类型',
  `type_val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '类型值',
  `isvideo` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否假视频',
  `wy_cid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '网易房间ID(当不使用网易是默认为空)',
  `goodnum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '靓号',
  `anyway` tinyint(1) NOT NULL DEFAULT 1 COMMENT '横竖屏，0表示竖屏，1表示横屏',
  `liveclassid` int(11) NOT NULL DEFAULT 0 COMMENT '直播分类ID',
  `hotvotes` int(11) NOT NULL DEFAULT 0 COMMENT '热门礼物总额',
  `pkuid` int(11) NOT NULL DEFAULT 0 COMMENT 'PK对方ID',
  `pkstream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'pk对方的流名',
  `ismic` tinyint(1) NOT NULL DEFAULT 0 COMMENT '连麦开关，0是关，1是开',
  `ishot` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否热门',
  `isrecommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐',
  `deviceinfo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '设备信息',
  `isshop` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启店铺',
  `game_action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '游戏类型',
  `banker_coin` bigint(20) DEFAULT 0 COMMENT '庄家余额',
  `isoff` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否断流，0否1是',
  `offtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '断流时间',
  `recom_sort` int(11) NOT NULL DEFAULT 0 COMMENT '推荐排序',
  `notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播公告',
  `match_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联得赛事ID',
  `pic_full_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '当前主播截图',
  `isrecord` tinyint(1) DEFAULT 0 COMMENT '是否录播',
  `recordid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '录播任务ID',
  `is_chat_off` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '直播间聊天室是够关闭，0未关闭，1关闭',
  `is_manual_close` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未推流是否手动关闭，0自动，1手动',
  PRIMARY KEY (`uid`) USING BTREE,
  INDEX `index_islive_starttime`(`islive`, `starttime`) USING BTREE,
  INDEX `index_uid_stream`(`uid`, `stream`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_ban
-- ----------------------------
CREATE TABLE `cmf_live_ban`  (
  `liveuid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主播ID',
  `superid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '超管ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`liveuid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_class
-- ----------------------------
CREATE TABLE `cmf_live_class`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图标',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '描述',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_contract
-- ----------------------------
CREATE TABLE `cmf_live_contract`  (
  `uid` int(12) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `contract` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系方式',
  `type` tinyint(1) UNSIGNED NOT NULL COMMENT '1QQ，2微信',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '显示状态：0（默认）隐藏全部，1显示全部 ，2显示按钮',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  INDEX `idx_uid`(`uid`) USING BTREE,
  INDEX `idx_type`(`type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '直播联系方式' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_kick
-- ----------------------------
CREATE TABLE `cmf_live_kick`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主播ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `actionid` int(11) NOT NULL DEFAULT 0 COMMENT '操作用户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_manager
-- ----------------------------
CREATE TABLE `cmf_live_manager`  (
  `uid` int(12) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(12) NOT NULL DEFAULT 0 COMMENT '主播ID',
  INDEX `uid_touid_index`(`liveuid`, `uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_record
-- ----------------------------
CREATE TABLE `cmf_live_record`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `showid` int(11) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '关播时人数',
  `h5nums` int(11) DEFAULT 0 COMMENT '关播时H5人数',
  `iosnums` int(11) DEFAULT 0 COMMENT '关播时IOS人数',
  `androidnums` int(11) DEFAULT 0 COMMENT '关播时安卓人数',
  `pcnums` int(11) DEFAULT 0 COMMENT '关播时PC人数',
  `starttime` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间',
  `endtime` int(11) NOT NULL DEFAULT 0 COMMENT '结束时间',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '城市',
  `stream` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '流名',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面图',
  `lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '经度',
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '纬度',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '直播类型',
  `type_val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '类型值',
  `votes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '本次直播收益',
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '格式日期',
  `liveclassid` int(11) NOT NULL DEFAULT 0 COMMENT '直播分类ID',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '回放地址',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_uid_start`(`uid`, `starttime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_live_shut
-- ----------------------------
CREATE TABLE `cmf_live_shut`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主播ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `showid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '禁言类型，0永久',
  `actionid` int(11) NOT NULL DEFAULT 0 COMMENT '操作者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_loginbonus
-- ----------------------------
CREATE TABLE `cmf_loginbonus`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `day` int(10) NOT NULL DEFAULT 0 COMMENT '登录天数',
  `coin` int(10) NOT NULL DEFAULT 0 COMMENT '登录奖励',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_hero
-- ----------------------------
CREATE TABLE `cmf_lol_hero`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hero_id` bigint(20) DEFAULT 0 COMMENT '英雄ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '英雄名称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '英雄头像',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '英雄列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_hero_stat
-- ----------------------------
CREATE TABLE `cmf_lol_hero_stat`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛ID',
  `league_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛名称',
  `league_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛英文名称',
  `hero_id` bigint(20) DEFAULT 0 COMMENT '英雄ID',
  `hero_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '英雄名称',
  `hero_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '英雄英文名称',
  `hero_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '英雄头像',
  `pick_rate` double(10, 3) DEFAULT 0.000 COMMENT '选用率',
  `ban_rate` double(10, 3) DEFAULT 0.000 COMMENT '禁选率',
  `win_rate` double(10, 3) DEFAULT 0.000 COMMENT '胜率',
  `kda` double(10, 3) DEFAULT 0.000 COMMENT 'KDA',
  `pick_count` int(11) DEFAULT 0 COMMENT '选用次数',
  `ban_count` int(11) DEFAULT 0 COMMENT '禁用次数',
  `win_count` int(11) DEFAULT 0 COMMENT '胜利次数',
  `range_type` int(11) DEFAULT 0 COMMENT '统计范围0：该联赛所有对局；1：最近5场对局；2：最近10场对局',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛统计（英雄）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_item
-- ----------------------------
CREATE TABLE `cmf_lol_item`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) DEFAULT 0 COMMENT '道具id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '道具名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '道具描述',
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '道具简述',
  `price` bigint(20) DEFAULT 0 COMMENT '售价',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '图标',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '道具列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_league
-- ----------------------------
CREATE TABLE `cmf_lol_league`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛英文名称',
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛简称',
  `start_time` int(11) DEFAULT 0 COMMENT '联赛开始时间',
  `end_time` int(11) DEFAULT 0 COMMENT '联赛结束时间',
  `organizer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '组织者',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛Logo',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '举办地',
  `team_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '参赛战队ID列表',
  `team_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '参赛战队列表',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未开始 1:进行中 2:已结束 3:延期 4:已删除}',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_league_board
-- ----------------------------
CREATE TABLE `cmf_lol_league_board`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `win_count` int(11) DEFAULT 0 COMMENT '胜利次数',
  `lost_count` int(11) DEFAULT 0 COMMENT '失败次数',
  `score` int(11) DEFAULT 0 COMMENT '净胜分',
  `type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '分组名称',
  `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛阶段',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛积分榜' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match
-- ----------------------------
CREATE TABLE `cmf_lol_match`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `league` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '联赛信息',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未开始 1:进行中 2:已结束  3:已延期 4:已删除}',
  `start_time` int(11) DEFAULT 0 COMMENT '开始时间',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '举办地',
  `round_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '轮次名称',
  `round_son_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '子轮次名次',
  `bo` int(11) DEFAULT 0 COMMENT '赛制',
  `battle_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '对局IDs',
  `battle_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '战役列表',
  `team_a_score` int(11) DEFAULT 0 COMMENT '主队得分',
  `team_a_id` bigint(20) DEFAULT 0 COMMENT '主队ID',
  `team_a` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '主队信息',
  `team_b_score` int(11) DEFAULT 0 COMMENT '客队得分',
  `team_b_id` bigint(20) DEFAULT 0 COMMENT '客队ID',
  `team_b` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '客队信息',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `viewnum` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '播放次数',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `start_time`(`start_time`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛列表（进行中）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_analysis
-- ----------------------------
CREATE TABLE `cmf_lol_match_analysis`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛id',
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `range_type` int(11) DEFAULT 0 COMMENT '统计范围0：最近5场比赛；1:最近10场比赛。统计场数不满5/10场，则有多少场统计多少场',
  `battle_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '对局数据',
  `team_a_id` bigint(20) DEFAULT 0 COMMENT 'A队ID',
  `team_a_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'A队名称',
  `team_a_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'A队英文名称',
  `team_a_short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'A队简称',
  `team_b_id` bigint(20) DEFAULT 0 COMMENT 'B队ID',
  `team_b_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'B队名称',
  `team_b_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'B队英文名称',
  `team_b_short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'B队简称',
  `team_a_recent_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'A队近期战绩',
  `team_b_recent_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'B队近期战绩',
  `team_a_hero_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'A队英雄数据',
  `team_b_hero_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '字段同A队英雄数据',
  `team_a_player_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'A队选手对位数据',
  `team_b_player_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '同A队选手对位信息',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '前瞻分析' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_battle_log
-- ----------------------------
CREATE TABLE `cmf_lol_match_battle_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle_id` bigint(20) DEFAULT 0 COMMENT '小局战役ID',
  `duration` int(11) DEFAULT 0 COMMENT '比赛时间',
  `log_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '比赛日志ID',
  `killed_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方类型player：选手；rift_herald：峡谷先锋；drake cloud：云端亚龙；drake ocean：海洋亚龙；drake mountain：山脉亚龙；drake infernal：炼狱亚龙；dragon elder：远古巨龙；baron nashor：纳什男爵；minion super blue：蓝方超级兵；minion super red：红方超级兵；minion seige blue：蓝方炮车；minion siege red：红方炮车；minion caster blue：蓝方远程兵；minion caster red：红方远程兵；minion melee blue：蓝方近战兵；minion melee red：红方近战兵；inhib blue：蓝方水晶；inhib red：红方水晶；tower blue：蓝方防御塔；tower red：红方防御塔；tower azir：沙皇防御塔',
  `killed_object_id` bigint(20) DEFAULT 0 COMMENT '被击杀方ID 只有player才返回ID',
  `killed_object_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被击杀方名称',
  `killed_object_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被击杀方英文名称',
  `killed_object_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被击杀方Logo',
  `killed_player_id` bigint(20) DEFAULT 0 COMMENT '被击杀方选手ID',
  `killed_player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被击杀方选手名称',
  `killed_player_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被击杀方选手头像',
  `killer_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT 'player：选手；rift_herald：峡谷先锋；drake cloud：云端亚龙；drake ocean：海洋亚龙；drake mountain：山脉亚龙；drake infernal：炼狱亚龙；dragon elder：远古巨龙；baron nashor：纳什男爵；minion super blue：蓝方超级兵；minion super red：红方超级兵；minion seige blue：蓝方炮车；minion siege red：红方炮车；minion caster blue：蓝方远程兵；minion caster red：红方远程兵；minion melee blue：蓝方近战兵；minion melee red：红方近战兵；inhib blue：蓝方水晶；inhib red：红方水晶；tower blue：蓝方防御塔；tower red：红方防御塔；tower azir：沙皇防御塔',
  `killer_object_id` bigint(20) DEFAULT 0 COMMENT '击杀方id',
  `killer_object_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方名称',
  `killer_object_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方英文名称',
  `killer_object_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方logo',
  `killer_player_id` bigint(20) DEFAULT 0 COMMENT '击杀方选手id',
  `killer_player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方选手名称',
  `killer_player_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '击杀方选手头像',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文字直播\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_bet_info
-- ----------------------------
CREATE TABLE `cmf_lol_match_bet_info`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bet_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '竞猜ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
  `end_time` bigint(20) DEFAULT 0 COMMENT '停止竞猜时间',
  `status` tinyint(1) DEFAULT 0 COMMENT '状态0:比赛尚未开始，正常更新；1:比赛开始进行，停止更新；2:结束；3:取消',
  `result_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '竞猜结果判断是否跟bet_item_id相同，返回0和空则视为null',
  `match_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '比赛ID',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '来源网站',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '竞猜选项',
  `bet_type` int(11) DEFAULT 0 COMMENT '1: 全场获胜；2: 输赢（单局）；3: 全场让分；4: 1血； 5: 5杀；6: 10杀；7: 首塔；8: 小龙首杀；9: 大龙首杀；10: 人头总数单双；11: 总击杀数大小；12: 比赛时长大小；13：五分钟内是否出现1血；14：击杀数最多；15：第一条小龙元素为；16：第一条小龙元素为“水”；17：第一条小龙元素为”土“ ；18： 第X局 第一条小龙元素为”火“；19：第X局 第一条小龙元素为”风“；20：小龙总击杀单双；21：首杀峡谷先锋；22：十四分钟内是否摧毁首塔；23：摧毁防御塔总数大小；24：摧毁防御塔总数单双；25：哪支队伍首先摧毁水晶兵营；26：10分钟总击杀；27：20分钟总击杀；28：全场正确比分；29：全场地图总数大小',
  `board_num` int(11) DEFAULT 0 COMMENT '局数',
  `type_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '类型描述',
  `handicap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '盘口',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '早盘指数' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_bet_info_rolling
-- ----------------------------
CREATE TABLE `cmf_lol_match_bet_info_rolling`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bet_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '竞猜ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
  `end_time` bigint(20) DEFAULT 0 COMMENT '停止竞猜时间',
  `status` tinyint(1) DEFAULT 0 COMMENT '状态0:比赛尚未开始，正常更新；1:比赛开始进行，停止更新；2:结束；3:取消',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '来源网站',
  `result_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '竞猜结果判断是否跟bet_item_id相同，返回0和空则视为null',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '竞猜选项',
  `bet_type` int(11) DEFAULT 0 COMMENT '1: 全场获胜；2: 输赢（单局）；3: 全场让分；4: 1血； 5: 5杀；6: 10杀；7: 首塔；8: 小龙首杀；9: 大龙首杀；10: 人头总数单双；11: 总击杀数大小；12: 比赛时长大小；13：五分钟内是否出现1血；14：击杀数最多；15：第一条小龙元素为；16：第一条小龙元素为“水”；17：第一条小龙元素为”土“ ；18： 第X局 第一条小龙元素为”火“；19：第X局 第一条小龙元素为”风“；20：小龙总击杀单双；21：首杀峡谷先锋；22：十四分钟内是否摧毁首塔；23：摧毁防御塔总数大小；24：摧毁防御塔总数单双；25：哪支队伍首先摧毁水晶兵营；26：10分钟总击杀；27：20分钟总击杀；28：全场正确比分；29：全场地图总数大小',
  `match_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '比赛ID',
  `board_num` int(11) DEFAULT 0 COMMENT '局数',
  `type_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '类型描述',
  `handicap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '盘口',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '滚球指数' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_live
-- ----------------------------
CREATE TABLE `cmf_lol_match_live`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播平台名称',
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '直播链接',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '直播平台英文名称',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '赛事直播地址' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_live_battle
-- ----------------------------
CREATE TABLE `cmf_lol_match_live_battle`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle_id` bigint(20) DEFAULT 0 COMMENT '小局战役ID',
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `duration` int(11) DEFAULT 0 COMMENT '比赛时间',
  `index` int(11) DEFAULT 0 COMMENT '小局第几场从1开始',
  `economic_diff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '经济差',
  `xp_diff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '经验差',
  `creep_score_diff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '团队中不到差',
  `start_time` int(11) DEFAULT 0 COMMENT '开始时间',
  `player_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '选手对局数据',
  `team_stats` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '对局战队数据',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比分事件（实时/赛后）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_match_push
-- ----------------------------
CREATE TABLE `cmf_lol_match_push`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `match_id` bigint(20) DEFAULT 0 COMMENT '比赛ID',
  `status` tinyint(1) DEFAULT 0 COMMENT '{0:未推送 1:已推送}',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1-电竟 2-蓝球 3-足球',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_match_id_type`(`match_id`, `type`) USING BTREE,
  INDEX `idx_type`(`type`) USING BTREE,
  INDEX `idx_status`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '比赛推送表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_player
-- ----------------------------
CREATE TABLE `cmf_lol_player`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` bigint(20) DEFAULT 0 COMMENT '玩家ID',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '玩家昵称',
  `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '玩家姓名',
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '位置',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '国籍',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '头像',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '战队介绍',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '选手列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_player_stats
-- ----------------------------
CREATE TABLE `cmf_lol_player_stats`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛ID',
  `league_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛名称',
  `league_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛英文名称',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `team_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队英文名称',
  `team_short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队简称',
  `player_id` bigint(20) DEFAULT 0 COMMENT '选手ID',
  `player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '选手名称',
  `player_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '选手头像',
  `game_count` int(11) DEFAULT 0 COMMENT '比赛场次',
  `kda` double(10, 3) DEFAULT 0.000 COMMENT 'KDA',
  `kill_average` double(10, 3) DEFAULT 0.000 COMMENT '场均击杀',
  `assist_average` double(10, 3) DEFAULT 0.000 COMMENT '场均助攻',
  `death_average` double(10, 3) DEFAULT 0.000 COMMENT '场均死亡',
  `last_hit_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均补刀',
  `gold_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '分均经济',
  `last_hit_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '分均补刀',
  `most_kill_per_games` double(10, 3) DEFAULT 0.000 COMMENT '最高击杀',
  `most_death_per_games` double(10, 3) DEFAULT 0.000 COMMENT '最高死亡',
  `most_assist_per_games` double(10, 3) DEFAULT 0.000 COMMENT '最高助攻',
  `range_type` int(11) DEFAULT 0 COMMENT '统计范围0：该联赛所有对局；1：最近5场对局；2：最近10场对局',
  `offered_rate` double(10, 3) DEFAULT 0.000 COMMENT '参团率',
  `damage_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '分均输出',
  `damage_percent` double(10, 3) DEFAULT 0.000 COMMENT '输出占比',
  `damage_taken_minute` double(10, 3) DEFAULT NULL,
  `damage_taken_percent` double(10, 3) DEFAULT 0.000 COMMENT '承伤占比',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛统计（选手）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_rune
-- ----------------------------
CREATE TABLE `cmf_lol_rune`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rune_id` bigint(20) DEFAULT 0 COMMENT '符文ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '符文名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '符文描述',
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '符文详情',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '符文图像',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '符文列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_skill
-- ----------------------------
CREATE TABLE `cmf_lol_skill`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `skill_id` bigint(20) DEFAULT 0 COMMENT '技能id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '技能名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '技能描述',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '技能英文名',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '图标',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '技能列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_team
-- ----------------------------
CREATE TABLE `cmf_lol_team`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队英文名称',
  `short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '队名简称',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队Logo',
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '战队介绍',
  `players` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '战队选手',
  `awards` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '获奖情况',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '战队列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_team_stat
-- ----------------------------
CREATE TABLE `cmf_lol_team_stat`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `league_id` bigint(20) DEFAULT 0 COMMENT '联赛ID',
  `league_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛名称',
  `league_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '联赛英文名称',
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `team_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队英文名称',
  `team_short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队简称',
  `team_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队Logo',
  `game_count` int(11) DEFAULT 0 COMMENT '比赛场数',
  `win_rate` double(10, 3) DEFAULT 0.000 COMMENT '胜率',
  `game_duration` bigint(20) DEFAULT 0 COMMENT '场均时长',
  `deaths_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均死亡',
  `kills_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均击杀',
  `golds_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '每分钟经济',
  `first_blood_rate` double(10, 3) DEFAULT 0.000 COMMENT '一血率',
  `tower_killed` double(10, 3) DEFAULT 0.000 COMMENT '场均推塔',
  `five_kills_rate` double(10, 3) DEFAULT 0.000 COMMENT '五杀率',
  `ten_kills_rate` double(10, 3) DEFAULT 0.000 COMMENT '十杀率',
  `kda` double(10, 3) DEFAULT 0.000 COMMENT 'KDA',
  `range_type` int(11) DEFAULT 0 COMMENT '统计范围0：该联赛所有对局；1：最近5场对局；2：最近10场对局',
  `damage_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均伤害',
  `nash_killed_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均大龙',
  `dragon_killed_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均小龙',
  `first_tower_rate` double(10, 3) DEFAULT 0.000 COMMENT '一塔率',
  `gdm` double(10, 3) DEFAULT 0.000 COMMENT '每分钟经济差',
  `kd` double(10, 3) DEFAULT 0.000 COMMENT '杀死比',
  `damage_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '分均伤害',
  `last_hit_per_minute` double(10, 3) DEFAULT 0.000 COMMENT '分均补刀',
  `golds_per_game` double(10, 3) DEFAULT 0.000 COMMENT '场均经济',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '联赛统计（战队）\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_lol_team_top
-- ----------------------------
CREATE TABLE `cmf_lol_team_top`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) DEFAULT 0 COMMENT '战队ID',
  `team_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队名称',
  `team_name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队英文名称',
  `team_short_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '队名简称',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '战队Logo',
  `rating` double(10, 3) DEFAULT 0.000 COMMENT '积分',
  `rank` int(11) DEFAULT 0 COMMENT '排名',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '国家',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '战队排行' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_music
-- ----------------------------
CREATE TABLE `cmf_music`  (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '音乐名称',
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '演唱者',
  `uploader` int(255) NOT NULL DEFAULT 0 COMMENT '上传者ID',
  `upload_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '上传类型  1管理员上传 2 用户上传',
  `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面地址',
  `length` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '音乐长度',
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '文件地址',
  `use_nums` int(12) NOT NULL DEFAULT 0 COMMENT '被使用次数',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否被删除 0否 1是',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `updatetime` int(12) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `classify_id` int(12) NOT NULL DEFAULT 0 COMMENT '音乐分类ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_music_classify
-- ----------------------------
CREATE TABLE `cmf_music_classify`  (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `list_order` int(12) NOT NULL DEFAULT 9999 COMMENT '排序号',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `updatetime` int(12) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类图标地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_music_collection
-- ----------------------------
CREATE TABLE `cmf_music_collection`  (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` int(12) NOT NULL DEFAULT 0 COMMENT '用户id',
  `music_id` int(12) NOT NULL DEFAULT 0 COMMENT '音乐id',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `updatetime` int(12) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '音乐收藏状态 1收藏 0 取消收藏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_nickname
-- ----------------------------
CREATE TABLE `cmf_nickname`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户昵称表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_notice
-- ----------------------------
CREATE TABLE `cmf_notice`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0禁用 1启用',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `addtime` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_option
-- ----------------------------
CREATE TABLE `cmf_option`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `autoload` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否自动加载;1:自动加载;0:不自动加载',
  `option_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '配置名',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '配置值',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `option_name`(`option_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '全站配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_paidprogram
-- ----------------------------
CREATE TABLE `cmf_paidprogram`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `classid` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容简介',
  `personal_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '个人介绍',
  `money` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '付费内容价格',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '文件类型 0 单视频 1 多视频',
  `videos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频json串',
  `sale_nums` bigint(20) NOT NULL DEFAULT 0 COMMENT '购买数量',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否审核通过 -1 拒绝 0 审核中 1 通过',
  `evaluate_nums` bigint(20) NOT NULL DEFAULT 0 COMMENT '评价总人数',
  `evaluate_total` bigint(20) NOT NULL DEFAULT 0 COMMENT '评价总分',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id_uid`(`id`, `uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_paidprogram_apply
-- ----------------------------
CREATE TABLE `cmf_paidprogram_apply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核状态 -1 拒绝 0 审核中 1 通过',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `percent` int(11) NOT NULL DEFAULT 0 COMMENT '抽水比例',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_paidprogram_class
-- ----------------------------
CREATE TABLE `cmf_paidprogram_class`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0不显示 1 显示',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_paidprogram_comment
-- ----------------------------
CREATE TABLE `cmf_paidprogram_comment`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` bigint(20) NOT NULL DEFAULT 0 COMMENT '项目发布者ID',
  `object_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '付费项目ID',
  `grade` tinyint(1) NOT NULL DEFAULT 0 COMMENT '评价等级',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_paidprogram_order
-- ----------------------------
CREATE TABLE `cmf_paidprogram_order`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` bigint(20) NOT NULL DEFAULT 0 COMMENT '付费项目发布者ID',
  `object_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '付费项目ID',
  `type` tinyint(1) NOT NULL COMMENT '支付方式 1 支付宝 2 微信 3 余额',
  `status` tinyint(1) NOT NULL COMMENT '订单状态 0 未支付 1 已支付',
  `orderno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `trade_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方订单编号',
  `money` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '下单时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0 否 1 是（用于删除付费项目）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid_objectid_status`(`uid`, `object_id`, `status`) USING BTREE,
  INDEX `uid_status`(`uid`, `status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_plugin
-- ----------------------------
CREATE TABLE `cmf_plugin`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '插件类型;1:网站;8:微信',
  `has_admin` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有后台管理,0:没有;1:有',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态;1:开启;0:禁用',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '插件安装时间',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '插件标识名,英文字母(惟一)',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件名称',
  `demo_url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `hooks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '实现的钩子;以“,”分隔',
  `author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件作者',
  `author_url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '插件版本号',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '插件描述',
  `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '插件配置',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '插件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_portal_category
-- ----------------------------
CREATE TABLE `cmf_portal_category`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类父id',
  `post_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类文章数',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:发布,0:不发布',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类描述',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类层级关系路径',
  `seo_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `seo_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  `list_tpl` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类列表模板',
  `one_tpl` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类文章页模板',
  `more` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '扩展属性',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'portal应用 文章分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_portal_category_post
-- ----------------------------
CREATE TABLE `cmf_portal_category_post`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章id',
  `category_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类id',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:发布;0:不发布',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `term_taxonomy_id`(`category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'portal应用 分类文章对应表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_portal_post
-- ----------------------------
CREATE TABLE `cmf_portal_post`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级id',
  `post_type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '类型,1:文章;2:页面',
  `post_format` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '内容格式;1:html;2:md',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发表者用户id',
  `post_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态;1:已发布;0:未发布;',
  `comment_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '评论状态;1:允许;0:不允许',
  `is_top` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否置顶;1:置顶;0:不置顶',
  `recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_hits` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '查看数',
  `post_favorites` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '收藏数',
  `post_like` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞数',
  `comment_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论数',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  `published_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布时间',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',
  `post_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题',
  `post_keywords` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'seo keywords',
  `post_excerpt` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'post摘要',
  `post_source` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '转载文章的来源',
  `thumbnail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '缩略图',
  `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '文章内容',
  `post_content_filtered` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '处理过的文章内容',
  `more` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '扩展属性,如缩略图;格式为json',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '页面类型，0单页面，2关于我们',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `type_status_date`(`post_type`, `post_status`, `create_time`, `id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'portal应用 文章表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_portal_tag
-- ----------------------------
CREATE TABLE `cmf_portal_tag`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:发布,0:不发布',
  `recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '标签文章数',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'portal应用 文章标签表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_portal_tag_post
-- ----------------------------
CREATE TABLE `cmf_portal_tag_post`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tag_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '标签 id',
  `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章 id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:发布;0:不发布',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `post_id`(`post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'portal应用 标签文章对应表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_pushrecord
-- ----------------------------
CREATE TABLE `cmf_pushrecord`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `touid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '推送对象',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '推送内容',
  `adminid` int(11) NOT NULL COMMENT '管理员ID',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '管理员账号',
  `ip` bigint(20) NOT NULL DEFAULT 0 COMMENT '管理员IP地址',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '发送时间',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息类型 0 后台手动发布的系统消息 1 商品消息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_recycle_bin
-- ----------------------------
CREATE TABLE `cmf_recycle_bin`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `object_id` int(11) DEFAULT 0 COMMENT '删除内容 id',
  `create_time` int(10) UNSIGNED DEFAULT 0 COMMENT '创建时间',
  `table_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '删除内容所在表名',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '删除内容名称',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ' 回收站' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_red
-- ----------------------------
CREATE TABLE `cmf_red`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `showid` int(11) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` int(11) NOT NULL DEFAULT 0 COMMENT '主播ID',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '红包类型，0平均，1手气',
  `type_grant` tinyint(1) NOT NULL DEFAULT 0 COMMENT '发放类型，0立即，1延迟',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '钻石数',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '描述',
  `effecttime` int(11) NOT NULL DEFAULT 0 COMMENT '生效时间',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态，0抢中，1抢完',
  `coin_rob` int(11) NOT NULL DEFAULT 0 COMMENT '钻石数',
  `nums_rob` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `liveuid_showid`(`showid`, `liveuid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_red_record
-- ----------------------------
CREATE TABLE `cmf_red_record`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `redid` int(11) NOT NULL DEFAULT 0 COMMENT '红包ID',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '金额',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `redid`(`redid`) USING BTREE COMMENT '红包ID索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_report
-- ----------------------------
CREATE TABLE `cmf_report`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '对方ID',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_report_classify
-- ----------------------------
CREATE TABLE `cmf_report_classify`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `list_order` int(10) NOT NULL DEFAULT 9999 COMMENT '排序',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '举报类型名称',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_role
-- ----------------------------
CREATE TABLE `cmf_role`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父角色ID',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态;0:禁用;1:正常',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  `list_order` float NOT NULL DEFAULT 0 COMMENT '排序',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_role_user
-- ----------------------------
CREATE TABLE `cmf_role_user`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `role_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '角色 id',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色对应表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_route
-- ----------------------------
CREATE TABLE `cmf_route`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态;1:启用,0:不启用',
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
  `full_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '完整url',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '实际显示的url',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'url路由表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_seller_goods_class
-- ----------------------------
CREATE TABLE `cmf_seller_goods_class`  (
  `uid` bigint(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `goods_classid` int(11) NOT NULL DEFAULT 0 COMMENT '商品一级分类id',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示 0 否 1 是'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sendcode
-- ----------------------------
CREATE TABLE `cmf_sendcode`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '消息类型，1表示短信验证码，2表示邮箱验证码',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接收账号',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消息内容',
  `addtime` int(11) NOT NULL COMMENT '提交时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sensitive
-- ----------------------------
CREATE TABLE `cmf_sensitive`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '敏感词名称',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '敏感词表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_address
-- ----------------------------
CREATE TABLE `cmf_shop_address`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '国家',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '市',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '电话',
  `country_code` int(11) NOT NULL DEFAULT 86 COMMENT '国家代号',
  `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为默认地址 0 否 1 是',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_apply
-- ----------------------------
CREATE TABLE `cmf_shop_apply`  (
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '简介',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联系人姓名',
  `cardno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '身份证号码',
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '联系人',
  `country_code` int(11) NOT NULL DEFAULT 86 COMMENT '国家代号',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '电话',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '市',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '地区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '详细地址',
  `service_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '客服电话',
  `receiver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退货收货人',
  `receiver_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退货人联系电话',
  `receiver_province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退货人省份',
  `receiver_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退货人市',
  `receiver_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '退货人地区',
  `receiver_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '退货人详细地址',
  `license` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '许可证',
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '营业执照',
  `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '其他证件',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态，0审核中1通过2拒绝',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原因',
  `order_percent` int(11) NOT NULL DEFAULT 0 COMMENT '订单分成比例',
  `sale_nums` bigint(11) NOT NULL DEFAULT 0 COMMENT '店铺总销量',
  `quality_points` float(11, 1) NOT NULL DEFAULT 0.0 COMMENT '店铺商品质量(商品描述)平均分',
  `service_points` float(11, 1) NOT NULL DEFAULT 0.0 COMMENT '店铺服务态度平均分',
  `express_points` float(11, 1) NOT NULL DEFAULT 0.0 COMMENT '物流服务平均分',
  `shipment_overdue_num` int(11) NOT NULL DEFAULT 0 COMMENT '店铺逾期发货次数',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_bond
-- ----------------------------
CREATE TABLE `cmf_shop_bond`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `bond` int(11) NOT NULL DEFAULT 0 COMMENT '保证金',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态，0已退回1已支付,-1已扣除',
  `addtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付时间',
  `uptime` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_express
-- ----------------------------
CREATE TABLE `cmf_shop_express`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `express_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '快递公司电话',
  `express_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '快递公司客服电话',
  `express_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '快递公司图标',
  `express_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示 0 否 1 是',
  `express_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '快递公司对应三方平台的编码',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '编辑时间',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_goods
-- ----------------------------
CREATE TABLE `cmf_shop_goods`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `one_classid` int(11) NOT NULL DEFAULT 0 COMMENT '商品一级分类',
  `two_classid` int(11) NOT NULL DEFAULT 0 COMMENT '商品二级分类',
  `three_classid` int(11) NOT NULL DEFAULT 0 COMMENT '商品三级分类',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商品视频地址',
  `video_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商品视频封面',
  `thumbs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '封面',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品文字内容',
  `pictures` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品内容图集',
  `specs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品规格',
  `postage` int(11) NOT NULL DEFAULT 0 COMMENT '邮费',
  `addtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '时间',
  `uptime` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `hits` int(11) NOT NULL DEFAULT 0 COMMENT '点击数',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态，0审核中-1商家下架1通过-2管理员下架 2拒绝',
  `isrecom` tinyint(1) NOT NULL DEFAULT 0 COMMENT '推荐，0否1是',
  `sale_nums` int(11) NOT NULL DEFAULT 0 COMMENT '总销量',
  `refuse_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商品拒绝原因',
  `issale` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品是否在直播间销售 0 否 1 是',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品类型 0 站内商品 1 站外商品',
  `original_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '站外商品原价',
  `present_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '站外商品现价',
  `goods_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '站外商品简介',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '站外商品链接',
  `live_isshow` tinyint(1) NOT NULL DEFAULT 0 COMMENT '直播间是否展示商品简介 0 否 1 是 默认0',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid_status`(`uid`, `status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_goods_class
-- ----------------------------
CREATE TABLE `cmf_shop_goods_class`  (
  `gc_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品分类ID',
  `gc_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商品分类名称',
  `gc_parentid` int(11) NOT NULL DEFAULT 0 COMMENT '上级分类ID',
  `gc_one_id` int(11) NOT NULL COMMENT '所属一级分类ID',
  `gc_sort` int(11) NOT NULL DEFAULT 0 COMMENT '商品分类排序号',
  `gc_isshow` tinyint(1) NOT NULL COMMENT '是否展示 0 否 1 是',
  `gc_addtime` int(11) NOT NULL DEFAULT 0 COMMENT '商品分类添加时间',
  `gc_edittime` int(11) NOT NULL DEFAULT 0 COMMENT '商品分类修改时间',
  `gc_grade` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品分类等级',
  PRIMARY KEY (`gc_id`) USING BTREE,
  INDEX `list1`(`gc_parentid`, `gc_isshow`) USING BTREE,
  INDEX `gc_parentid`(`gc_parentid`) USING BTREE,
  INDEX `gc_grade`(`gc_grade`) USING BTREE,
  INDEX `list2`(`gc_one_id`, `gc_grade`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_order
-- ----------------------------
CREATE TABLE `cmf_shop_order`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '购买者ID',
  `shop_uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '卖家用户ID',
  `goodsid` bigint(20) NOT NULL DEFAULT 0 COMMENT '商品id',
  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '商品名称',
  `spec_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品规格ID',
  `spec_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '规格名称',
  `spec_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '规格封面',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '购买数量',
  `price` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '商品单价',
  `total` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '商品总价（包含邮费）',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者姓名',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者联系电话',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '国家',
  `country_code` int(11) NOT NULL DEFAULT 0 COMMENT '国家代号',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者市',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者地区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '购买者详细地址',
  `postage` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '邮费',
  `orderno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单类型 1 支付宝 2 微信 3 余额',
  `trade_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方订单号',
  `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '订单状态  -1 已关闭  0 待付款 1 待发货 2 待收货 3 待评价 4 已评价 5 退款',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '订单添加时间',
  `cancel_time` int(11) NOT NULL DEFAULT 0 COMMENT '订单取消时间',
  `paytime` int(11) NOT NULL DEFAULT 0 COMMENT '订单付款时间',
  `shipment_time` int(11) NOT NULL DEFAULT 0 COMMENT '订单发货时间',
  `receive_time` int(11) NOT NULL DEFAULT 0 COMMENT '订单收货时间',
  `evaluate_time` int(11) NOT NULL DEFAULT 0 COMMENT '订单评价时间',
  `settlement_time` int(11) NOT NULL DEFAULT 0 COMMENT '订单结算时间（款项打给卖家）',
  `is_append_evaluate` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否可追加评价',
  `order_percent` int(11) NOT NULL DEFAULT 0 COMMENT '订单抽成比例',
  `refund_starttime` int(11) NOT NULL DEFAULT 0 COMMENT '订单发起退款时间',
  `refund_endtime` int(11) NOT NULL DEFAULT 0 COMMENT '订单退款处理结束时间',
  `refund_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款处理结果 -2取消申请 -1 失败 0 处理中 1 成功 ',
  `refund_shop_result` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款时卖家处理结果 0 未处理 -1 拒绝 1 同意',
  `express_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '物流公司名称',
  `express_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '物流公司电话',
  `express_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '物流公司图标',
  `express_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '快递公司对应三方平台的编码',
  `express_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '物流单号',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单是否删除 0 否 -1 买家删除 -2 卖家删除 1 买家卖家都删除',
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '买家留言内容',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id_uid`(`id`, `uid`) USING BTREE,
  INDEX `shopuid_status`(`shop_uid`, `status`) USING BTREE,
  INDEX `shopuid_status_refundstatus`(`shop_uid`, `status`, `refund_status`) USING BTREE,
  INDEX `id_shopuid`(`id`, `shop_uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_order_comments
-- ----------------------------
CREATE TABLE `cmf_shop_order_comments`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `orderid` bigint(20) NOT NULL DEFAULT 0 COMMENT '商品订单ID',
  `goodsid` bigint(20) NOT NULL COMMENT '商品ID',
  `shop_uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '店铺用户id',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '文字内容',
  `thumbs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论图片列表',
  `video_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '视频封面',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '视频地址',
  `is_anonym` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否匿名 0否 1是',
  `quality_points` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品描述评分',
  `service_points` tinyint(1) NOT NULL DEFAULT 0 COMMENT '服务态度评分',
  `express_points` tinyint(1) NOT NULL DEFAULT 0 COMMENT '物流速度评分',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `is_append` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是追评0 否 1 是',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `goodsid_isappend`(`goodsid`, `is_append`) USING BTREE,
  INDEX `uid_orderid`(`uid`, `orderid`, `is_append`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_order_message
-- ----------------------------
CREATE TABLE `cmf_shop_order_message`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '消息内容',
  `orderid` bigint(20) NOT NULL DEFAULT 0,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '接受消息用户ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '用户身份 0买家 1卖家',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_order_refund
-- ----------------------------
CREATE TABLE `cmf_shop_order_refund`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '买家id',
  `orderid` bigint(20) NOT NULL DEFAULT 0 COMMENT '订单ID',
  `goodsid` bigint(20) NOT NULL DEFAULT 0 COMMENT '商品ID',
  `shop_uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '商家ID',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退款原因',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退款说明',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '退款图片（废弃）',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款类型 0 仅退款 1退货退款',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `shop_process_time` int(11) NOT NULL DEFAULT 0 COMMENT '店铺处理时间',
  `shop_result` tinyint(1) NOT NULL DEFAULT 0 COMMENT '店铺处理结果 -1 拒绝 0 处理中 1 同意',
  `shop_process_num` tinyint(1) NOT NULL DEFAULT 0 COMMENT '店铺驳回次数',
  `platform_process_time` int(11) NOT NULL DEFAULT 0 COMMENT '平台处理时间',
  `platform_result` tinyint(1) NOT NULL DEFAULT 0 COMMENT '平台处理结果 -1 拒绝 0 处理中 1 同意',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '平台处理账号',
  `ip` bigint(20) NOT NULL DEFAULT 0 COMMENT '平台账号ip',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款处理状态 0 处理中 -1 买家已取消 1 已完成 ',
  `is_platform_interpose` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否平台介入 0 否 1 是',
  `system_process_time` int(11) NOT NULL DEFAULT 0 COMMENT '系统自动处理时间',
  `platform_interpose_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '申请平台介入的理由',
  `platform_interpose_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '申请平台介入的详细原因',
  `platform_interpose_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '申请平台介入的图片举证',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid_orderid`(`uid`, `orderid`) USING BTREE,
  INDEX `orderid_shopuid`(`orderid`, `shop_uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_order_refund_list
-- ----------------------------
CREATE TABLE `cmf_shop_order_refund_list`  (
  `orderid` bigint(11) NOT NULL DEFAULT 0 COMMENT '订单ID',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '处理方 1 买家 2 卖家 3 平台 4 系统',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '处理时间',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '处理说明',
  `handle_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '处理备注说明',
  `refuse_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '卖家拒绝理由'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_platform_reason
-- ----------------------------
CREATE TABLE `cmf_shop_platform_reason`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原因名称',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0不显示 1 显示',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_points
-- ----------------------------
CREATE TABLE `cmf_shop_points`  (
  `shop_uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '店铺用户ID',
  `evaluate_total` bigint(20) NOT NULL DEFAULT 0 COMMENT '评价总数',
  `quality_points_total` int(11) NOT NULL DEFAULT 0 COMMENT '店铺商品质量(商品描述)总分',
  `service_points_total` int(11) NOT NULL DEFAULT 0 COMMENT '店铺服务态度总分',
  `express_points_total` int(11) NOT NULL DEFAULT 0 COMMENT '物流服务总分'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_refund_reason
-- ----------------------------
CREATE TABLE `cmf_shop_refund_reason`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原因名称',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0不显示 1 显示',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_shop_refuse_reason
-- ----------------------------
CREATE TABLE `cmf_shop_refuse_reason`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原因名称',
  `list_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0不显示 1 显示',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `edittime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_slide
-- ----------------------------
CREATE TABLE `cmf_slide`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:显示,0不显示',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',
  `position` tinyint(1) UNSIGNED NOT NULL COMMENT '幻灯片位置：1、PC首页大背景图，2、PC首页左小轮图，3PC首页右小轮图，4、PC顶部广告图，5APP首页轮播',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_position`(`position`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '幻灯片表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_slide_item
-- ----------------------------
CREATE TABLE `cmf_slide_item`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slide_id` int(11) NOT NULL DEFAULT 0 COMMENT '幻灯片id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态,1:显示;0:隐藏',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '幻灯片名称',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '幻灯片图片',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '幻灯片链接',
  `target` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '幻灯片描述',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '幻灯片内容',
  `more` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '扩展信息',
  `click_cnt` int(11) DEFAULT 0 COMMENT '点击数',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `slide_id`(`slide_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '幻灯片子项表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_analysis
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_analysis`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `commonAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '近10场的对往战绩列表',
  `homeAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队近10场的战绩列表',
  `awayAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队近10场的战绩列表',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球比赛分析表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_league
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_league`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `leagueId` int(10) UNSIGNED NOT NULL COMMENT '联赛/杯赛ID    ',
  `leagueNameCnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（中文全称简称）',
  `leagueNameTradShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（繁体全称简称）',
  `leagueNameEnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（英文全称简称）',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_leagueId`(`leagueId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球联赛/杯赛表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_line_up
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_line_up`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `homeTeamLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队首发阵容',
  `awayTeamLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队首发阵容（同主队首发阵容）',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球比赛阵容表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_match
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_match`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `matchId` int(10) DEFAULT NULL COMMENT '比赛ID',
  `leagueId` int(10) DEFAULT NULL COMMENT '联赛/杯赛ID    ',
  `homeId` int(10) DEFAULT NULL COMMENT '主队ID',
  `awayId` int(10) DEFAULT NULL COMMENT '客队ID',
  `homeRank` smallint(10) DEFAULT NULL COMMENT '主队排名',
  `awayRank` smallint(10) DEFAULT NULL COMMENT '客队排名',
  `state` smallint(6) NOT NULL DEFAULT 0 COMMENT '比赛状态:  0：比赛一场，1：未开赛，2：第一节，3：第一节完，4：第二节，5：第二节完，6：第三节，7：第三节完，8：第四节，9：加时，10：完场，11：中断，12：取消，13：延期，14：腰斩，15：待定',
  `matchStartTime` int(10) DEFAULT NULL COMMENT '比赛开始时间(时间戳) ',
  `matchConductTime` mediumint(10) DEFAULT NULL COMMENT '当前小节所剩时间(分钟:秒)',
  `homeScore` int(10) DEFAULT NULL COMMENT '主队全场比分',
  `awayScore` int(10) DEFAULT NULL COMMENT '客队全场比分',
  `nodeCount` smallint(5) DEFAULT NULL COMMENT '总节数',
  `homeNode1Score` smallint(5) DEFAULT NULL COMMENT '主队第一节比分 ',
  `homeNode2Score` smallint(5) DEFAULT NULL COMMENT '主队第二节比分 ',
  `homeNode3Score` smallint(5) DEFAULT NULL COMMENT '主队第三节比分 ',
  `homeNode4Score` smallint(5) DEFAULT NULL COMMENT '主队第四节比分 ',
  `homeNode5Score` smallint(5) DEFAULT NULL COMMENT '主队加时比分 ',
  `awayNode1Score` smallint(5) DEFAULT NULL COMMENT '客队第一节比分 ',
  `awayNode2Score` smallint(5) DEFAULT NULL COMMENT '客队第二节比分 ',
  `awayNode3Score` smallint(5) DEFAULT NULL COMMENT '客队第三节比分 ',
  `awayNode4Score` smallint(5) DEFAULT NULL COMMENT '客队第四节比分 ',
  `awayNode5Score` smallint(5) DEFAULT NULL COMMENT '客队加时比分 ',
  `letgoalHomeOdds` double(5, 2) DEFAULT NULL COMMENT '让球即时主队赔率',
  `letgoalGoal` double(5, 2) DEFAULT NULL COMMENT '让球即时盘口',
  `letgoalAwayOdds` double(5, 2) DEFAULT NULL COMMENT '让球即时客队赔率',
  `letgoalIsEntertained` tinyint(1) DEFAULT 1 COMMENT '亚盘：是否封盘，0：表示没有盘口 ，1：未封盘  ，2：临时性封盘或停止走地 ',
  `europeHomeOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时主队赔率',
  `europeFlatOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时盘口',
  `europeAwayOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时客队赔率',
  `europeIsEntertained` tinyint(1) DEFAULT 1 COMMENT '欧赔：是否封盘，0：表示没有盘口，1：未封盘，2：临时性封盘或停止走地 ',
  `totalScoreHomeOdds` double(5, 2) DEFAULT NULL COMMENT '大小球即时主队赔率  ',
  `totalScoreGoal` double(5, 2) DEFAULT NULL COMMENT '大小球即时盘口  ',
  `totalScoreAwayOdds` double(5, 2) DEFAULT NULL COMMENT '大小球即时客队赔率',
  `totalScoreIsEntertained` tinyint(1) DEFAULT 1 COMMENT '大小球：是否封盘，0：表示没有盘口，1：未封盘，2：临时性封盘或停止走地  ',
  `isSources` tinyint(1) DEFAULT NULL COMMENT '是否有情报,0：无，1：有',
  `isAnimation` tinyint(1) DEFAULT NULL COMMENT '是否有动画 （该字段无意思，不提供动画数据）,0：无，1：有',
  `isLive` tinyint(1) DEFAULT NULL COMMENT '是否有直播（购买直播信号可关联），无使用时，该字段无意义,0：无，1：有   ',
  `homeNodePauseCount` smallint(5) DEFAULT NULL COMMENT '主队剩暂停数',
  `awayNodePauseCount` smallint(5) DEFAULT NULL COMMENT '客队剩暂停数 ',
  `homeNodeFoulsCount` smallint(5) DEFAULT NULL COMMENT '主队犯规数',
  `awayNodeFoulsCount` smallint(5) DEFAULT NULL COMMENT '客队犯规数',
  `homeAssists` smallint(5) DEFAULT NULL COMMENT '主队助攻数',
  `homeSteals` smallint(5) DEFAULT NULL COMMENT '主队抢断数 ',
  `homeBlocks` smallint(5) DEFAULT NULL COMMENT '主队盖帽数',
  `awayAssists` smallint(5) DEFAULT NULL COMMENT '客队助攻数',
  `awaySteals` smallint(5) DEFAULT NULL COMMENT '客队抢断数 ',
  `awayBlocks` smallint(5) DEFAULT NULL COMMENT '客队盖帽数',
  `homeThreeCount` double(5, 2) DEFAULT NULL COMMENT '主队3分球数',
  `homeTwoCount` double(5, 2) DEFAULT NULL COMMENT '主队2分球数 ',
  `homeFreeCount` double(5, 2) DEFAULT NULL COMMENT '主队罚球数',
  `homeFreeRate` double(5, 2) DEFAULT NULL COMMENT '主队罚球命中率',
  `awayThreeCount` double(5, 2) DEFAULT NULL COMMENT '客队3分球数',
  `awayTwoCount` double(5, 2) DEFAULT NULL COMMENT '客队2分球数 ',
  `awayFreeCount` double(5, 2) DEFAULT NULL COMMENT '客队罚球数',
  `awayFreeRate` double(5, 2) DEFAULT NULL COMMENT '客队罚球命中率',
  `match_date` date DEFAULT NULL COMMENT '比赛日期',
  `live_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '直播地址',
  `viewnum` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看次数',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE,
  INDEX `idx_leagueId`(`leagueId`) USING BTREE,
  INDEX `idx_homeId`(`homeId`) USING BTREE,
  INDEX `idx_awayId`(`awayId`) USING BTREE,
  INDEX `idx_matchStartTime`(`matchStartTime`) USING BTREE,
  INDEX `idx_match_date`(`match_date`) USING BTREE,
  INDEX `idx_state`(`state`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球比赛表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_player
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_player`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `playerId` int(10) UNSIGNED NOT NULL COMMENT '球员ID',
  `teamId` int(10) UNSIGNED NOT NULL COMMENT '球队ID',
  `playerNameCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文简体）',
  `playerNameCnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文简体简称）',
  `playerNameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（英文）',
  `playerNameEnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（英文简称）',
  `playerTrad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文繁体）',
  `playerTradShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文繁体简称）',
  `playerLogo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员logo',
  `playerNumber` smallint(5) UNSIGNED DEFAULT NULL COMMENT '球员球衣编号',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_playerId`(`playerId`) USING BTREE,
  INDEX `idx_teamId`(`teamId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球球员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_team
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_team`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `teamId` int(10) UNSIGNED NOT NULL COMMENT '队伍ID',
  `rank` int(10) UNSIGNED NOT NULL COMMENT '队伍排名',
  `nameCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文简体)  ',
  `nameCnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文简体简称)',
  `nameTrad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文繁体)',
  `nameTradShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文繁体简称) ',
  `nameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(英文简称)',
  `nameEnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(英文简称)   ',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍logo',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_teamId`(`teamId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球队伍表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_basketball_text_live
-- ----------------------------
CREATE TABLE `cmf_sports_basketball_text_live`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `live` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '直播信息',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_matchId`(`matchId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '篮球直播表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_analysis
-- ----------------------------
CREATE TABLE `cmf_sports_football_analysis`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `teamHtAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '球队胜平负分析数据列表',
  `recordAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '球队战绩分析数据列表',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球比赛分析表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_league
-- ----------------------------
CREATE TABLE `cmf_sports_football_league`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `leagueId` int(10) UNSIGNED NOT NULL COMMENT '联赛/杯赛ID    ',
  `leagueNameCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（中文全称）',
  `leagueNameTrad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（繁体全称）',
  `leagueNameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（英文全称）',
  `leagueNameCnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（中文全称简称）',
  `leagueNameTradShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（繁体全称简称）',
  `leagueNameEnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联赛/杯赛名（英文全称简称）',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_leagueId`(`leagueId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球联赛/杯赛表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_line_up
-- ----------------------------
CREATE TABLE `cmf_sports_football_line_up`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `homeTeamLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队首发阵容',
  `awayTeamLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队首发阵容（同主队首发阵容）',
  `homeTeamSubLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队替补阵容（同主队首发阵容）',
  `awayTeamSubLineUp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队替补阵容（同主队首发阵容）',
  `homeTeamFormation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队阵形',
  `awayTeamFormation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队阵形',
  `homeTeamInjuryList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主队伤停阵容',
  `awayTeamInjuryList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '客队伤停阵容（同主队伤停阵容）',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球比赛阵容表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_match
-- ----------------------------
CREATE TABLE `cmf_sports_football_match`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `matchId` int(10) NOT NULL COMMENT '比赛ID',
  `leagueId` int(10) NOT NULL COMMENT '联赛/杯赛ID    ',
  `matchStartTime` int(10) DEFAULT NULL COMMENT '比赛开始时间(时间戳) ',
  `state` smallint(6) DEFAULT 0 COMMENT '比赛状态:-14:推迟，-13:中断，-12:腰斩，-11:待定，-10:取消，-1.完场，0:未开始，1:上半场，2:中场，3:下半场，4:加时，5:点球 ',
  `isNeutral` tinyint(1) DEFAULT NULL COMMENT '是否中立场，1：是，2：否',
  `locationCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '比赛场地(中文,繁体也使用这个字段)',
  `locationEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '比赛场地(英文)',
  `homeId` int(10) NOT NULL COMMENT '主队ID',
  `awayId` int(10) NOT NULL COMMENT '客队ID',
  `homeScore` int(10) DEFAULT NULL COMMENT '主队全场比分',
  `awayScore` int(10) DEFAULT NULL COMMENT '客队全场比分',
  `homeHalfScore` int(10) DEFAULT NULL COMMENT '主队半场比分',
  `awayHalfScore` int(10) DEFAULT NULL COMMENT '客队半场比分',
  `homeCornerNum` int(10) DEFAULT NULL COMMENT '主队角球数 ',
  `awayCornerNum` int(10) DEFAULT NULL COMMENT '客队角球数 ',
  `extraFirstKick` tinyint(1) DEFAULT NULL COMMENT '加时: 先开球方，1：主队先开球，2：客队先开球',
  `extraNormalTime` int(10) DEFAULT NULL COMMENT '加时: 常规时间',
  `extraNormalScore` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加时: 常规时间的比分 ',
  `extraTwoLegsScore` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加时: 两回合总比分, 该字段仅在比赛有加时、点球的情况才更新    ',
  `extraType` tinyint(1) DEFAULT NULL COMMENT '加时: 加时阶段类型，1:120分钟，2：加时，3：加时中',
  `extraScore` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加时: 加时阶段比分 ',
  `extraPenaltyKickScore` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加时: 点球大战比分    ',
  `extraWin` tinyint(1) DEFAULT NULL COMMENT '加时: 获胜方，1：主队获胜，2：客队获胜',
  `letgoalHomeOdds` double(5, 2) DEFAULT NULL COMMENT '让球即时主队赔率',
  `letgoalGoal` double(5, 2) DEFAULT NULL COMMENT '让球即时盘口',
  `letgoalAwayOdds` double(5, 2) DEFAULT NULL COMMENT '让球即时客队赔率',
  `letgoalIsEntertained` tinyint(1) DEFAULT 1 COMMENT '亚盘：是否封盘,1：默认，2：临时性封盘或停止走地 ',
  `europeHomeOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时主队赔率',
  `europeFlatOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时盘口',
  `europeAwayOdds` double(5, 2) DEFAULT NULL COMMENT '欧赔即时客队赔率',
  `europeIsEntertained` tinyint(1) DEFAULT 1 COMMENT '欧赔：是否封盘,1：默认，2：临时性封盘或停止走地 ',
  `totalScoreHomeOdds` double(5, 2) DEFAULT NULL COMMENT '大小球即时主队赔率  ',
  `totalScoreGoal` double(5, 2) DEFAULT NULL COMMENT '大小球即时盘口  ',
  `totalScoreAwayOdds` double(5, 2) DEFAULT NULL COMMENT '大小球即时客队赔率',
  `totalScoreIsEntertained` tinyint(1) DEFAULT 1 COMMENT '大小球：是否封盘, 1：默认，2：临时性封盘或停止走地   ',
  `hasSources` tinyint(1) DEFAULT NULL COMMENT '是否有情报,0：无，1：有',
  `hasAnimation` tinyint(1) DEFAULT NULL COMMENT '是否有动画 （该字段无意思，不提供动画数据）,0：无，1：有',
  `hasLive` tinyint(1) DEFAULT NULL COMMENT '是否有直播（购买直播信号可关联），无使用时，该字段无意义,0：无，1：有   ',
  `weatherEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '	天气（英文）',
  `weatherCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '天气（中文）',
  `weatherIcon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '天气图标',
  `temperature` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '温度',
  `match_date` date DEFAULT NULL COMMENT '比赛日期',
  `live_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '直播地址',
  `viewnum` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看次数',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE,
  INDEX `idx_state`(`state`) USING BTREE,
  INDEX `idx_matchStartTime`(`matchStartTime`) USING BTREE,
  INDEX `idx_leagueId`(`leagueId`) USING BTREE,
  INDEX `idx_homeId`(`homeId`) USING BTREE,
  INDEX `idx_awayId`(`awayId`) USING BTREE,
  INDEX `idx_match_date`(`match_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球比赛表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_odds
-- ----------------------------
CREATE TABLE `cmf_sports_football_odds`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `teamHtAnalysis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '亚盘指数数据列表',
  `bsOddsList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '大小球指数数据列表',
  `europeOddsList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '欧赔指数数据列表 ',
  `europeMoreOddsList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '百家欧赔指数数据列表',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球比赛指数表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_odds_company
-- ----------------------------
CREATE TABLE `cmf_sports_football_odds_company`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `companyId` int(10) UNSIGNED NOT NULL COMMENT '队伍ID',
  `companySourceId` int(10) UNSIGNED NOT NULL COMMENT '公司来源ID',
  `companyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文简体)  ',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球指数公司表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_odds_flow_list
-- ----------------------------
CREATE TABLE `cmf_sports_football_odds_flow_list`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `companyId` int(10) UNSIGNED NOT NULL COMMENT '指数公司ID',
  `companyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '公司名称',
  `oddsId` int(10) UNSIGNED NOT NULL COMMENT '指数流水ID',
  `leftOdds` double(5, 2) NOT NULL COMMENT '主队胜赔率（亚盘/欧赔）,大球胜赔率（大小球）',
  `middleOdds` double(5, 2) NOT NULL COMMENT '盘口（亚盘），平局赔率（欧赔）',
  `rightOdds` double(5, 2) NOT NULL COMMENT '客队胜赔率（亚盘/欧赔）,小球胜赔率（大小球）',
  `changeTime` int(10) UNSIGNED NOT NULL COMMENT '变盘时间，单位：秒',
  `isEntertained` tinyint(1) UNSIGNED NOT NULL COMMENT '是否封盘 1：未封盘，2：临时性封盘或停止走地  ',
  `homeScore` smallint(5) UNSIGNED NOT NULL COMMENT '当前时间的主队比分',
  `awayScore` smallint(5) UNSIGNED NOT NULL COMMENT '当前时间的客队比分',
  `type` tinyint(1) UNSIGNED NOT NULL COMMENT '类型，1：无类型数据 2：早餐盘 3：即时盘, 4：走地盘',
  `from` tinyint(1) UNSIGNED NOT NULL COMMENT '类型：1亚盘，2大小球，3欧赔，4百家欧赔',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_matchId`(`matchId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球比赛公司指数流水表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_player
-- ----------------------------
CREATE TABLE `cmf_sports_football_player`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `playerId` int(10) UNSIGNED NOT NULL COMMENT '球员ID',
  `teamId` int(10) UNSIGNED NOT NULL COMMENT '球队ID',
  `nameCnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文简体简称）',
  `nameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（英文简体）',
  `nameEnShort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（英文简称）',
  `nameTrad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '球员名（中文繁体）',
  `number` smallint(5) DEFAULT NULL COMMENT '球员球衣编号',
  `kind` tinyint(1) UNSIGNED DEFAULT NULL COMMENT '类型 ： 1-主队首发 ，2-客队首发， 3-主队替补， 4-客队替补',
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '位置',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_playerId_teamId`(`playerId`, `teamId`) USING BTREE,
  INDEX `idx_teamId`(`teamId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球球员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_team
-- ----------------------------
CREATE TABLE `cmf_sports_football_team`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `teamId` int(10) UNSIGNED NOT NULL COMMENT '队伍ID',
  `rank` int(10) UNSIGNED NOT NULL COMMENT '队伍排名',
  `nameCn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文简体)  ',
  `nameTrad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(中文繁体)',
  `nameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍名(英文简称)',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '队伍logo',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_teamId`(`teamId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球队伍表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_sports_football_text_live
-- ----------------------------
CREATE TABLE `cmf_sports_football_text_live`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matchId` int(10) UNSIGNED NOT NULL COMMENT '比赛ID',
  `live` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '直播信息',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '足球文字直播表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_statistics
-- ----------------------------
CREATE TABLE `cmf_statistics`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) UNSIGNED NOT NULL COMMENT '类型：1、app下载',
  `action` tinyint(1) UNSIGNED NOT NULL COMMENT '操作：1、PC端android，2、PC端ios，3、h5端android，4、h5端ios',
  `click_cnt` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点击量',
  `date` date NOT NULL COMMENT '日期',
  `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_type_action_date`(`type`, `action`, `date`) USING BTREE,
  INDEX `idx_date`(`date`) USING BTREE,
  INDEX `idx_action`(`action`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '统计表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_theme
-- ----------------------------
CREATE TABLE `cmf_theme`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '安装时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后升级时间',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '模板状态,1:正在使用;0:未使用',
  `is_compiled` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为已编译模板',
  `theme` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题目录名，用于主题的维一标识',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题名称',
  `version` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题版本号',
  `demo_url` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `thumbnail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '缩略图',
  `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题作者',
  `author_url` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `lang` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支持语言',
  `keywords` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题关键字',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_theme_file
-- ----------------------------
CREATE TABLE `cmf_theme_file`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_public` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否公共的模板文件',
  `list_order` float NOT NULL DEFAULT 10000 COMMENT '排序',
  `theme` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名称',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板文件名',
  `action` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作',
  `file` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板文件，相对于模板根目录，如Portal/index.html',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板文件描述',
  `more` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '模板更多配置,用户自己后台设置的',
  `config_more` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '模板更多配置,来源模板的配置文件',
  `draft_more` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '模板更多配置,用户临时保存的配置',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_turntable
-- ----------------------------
CREATE TABLE `cmf_turntable`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型，0无奖1钻石2礼物',
  `type_val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '类型值',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片',
  `rate` decimal(10, 3) NOT NULL DEFAULT 0.000 COMMENT '中奖率',
  `uptime` bigint(20) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_turntable_con
-- ----------------------------
CREATE TABLE `cmf_turntable_con`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `times` int(11) NOT NULL DEFAULT 0 COMMENT '次数',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_turntable_log
-- ----------------------------
CREATE TABLE `cmf_turntable_log`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `liveuid` bigint(20) NOT NULL DEFAULT 0 COMMENT '主播ID',
  `showid` bigint(20) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  `addtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '时间',
  `iswin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否中奖',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_turntable_win
-- ----------------------------
CREATE TABLE `cmf_turntable_win`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `logid` bigint(20) NOT NULL DEFAULT 0 COMMENT '转盘记录ID',
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型，0无奖1钻石2礼物',
  `type_val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '类型值',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片',
  `nums` int(11) NOT NULL DEFAULT 0 COMMENT '数量',
  `addtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '处理状态，0未处理1已处理',
  `uptime` bigint(20) NOT NULL DEFAULT 0 COMMENT '处理时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user
-- ----------------------------
CREATE TABLE `cmf_user`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dj_uid` int(10) UNSIGNED DEFAULT NULL COMMENT '电竞用户id',
  `user_type` tinyint(3) UNSIGNED NOT NULL COMMENT '用户类型：1admin，2会员，3电竞用户',
  `sex` tinyint(2) NOT NULL DEFAULT 0 COMMENT '性别;0:保密,1:男,2:女',
  `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '生日',
  `last_login_time` int(11) NOT NULL DEFAULT 0 COMMENT '最后登录时间',
  `score` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户积分',
  `coin` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '金币',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '注册时间',
  `user_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '用户状态;0:禁用,1:正常,2:未验证',
  `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `user_pass` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '登录密码;<PASSWORD>',
  `user_nicename` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
  `user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户登录邮箱',
  `user_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户个人网址',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户头像',
  `avatar_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '小头像',
  `signature` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '个性签名',
  `last_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `user_activation_key` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '激活码',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '中国手机不带国家代码，国际手机号格式为：国家代码-手机号',
  `more` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '扩展属性',
  `consumption` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '消费总额',
  `votes` decimal(20, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '映票余额',
  `votestotal` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '映票总额',
  `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '城市',
  `isrecommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 未推荐 1 推荐',
  `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方标识',
  `login_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'phone' COMMENT '注册方式',
  `iszombie` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启僵尸粉',
  `isrecord` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开起回放',
  `iszombiep` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否僵尸粉',
  `issuper` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否超管',
  `ishot` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否热门显示',
  `goodnum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '当前装备靓号',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'pc' COMMENT '注册来源',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '所在地',
  `end_bantime` bigint(20) NOT NULL DEFAULT 0 COMMENT '禁用到期时间',
  `balance` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '用户商城人民币账户金额',
  `balance_total` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '用户商城累计收入人民币',
  `balance_consumption` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '用户商城累计消费人民币',
  `viewnum` int(11) NOT NULL DEFAULT 0 COMMENT '人气值',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_dj_uid`(`dj_uid`) USING BTREE,
  INDEX `idx_user_login`(`user_login`) USING BTREE,
  INDEX `idx_user_nicename`(`user_nicename`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_attention
-- ----------------------------
CREATE TABLE `cmf_user_attention`  (
  `uid` int(12) NOT NULL COMMENT '用户ID',
  `touid` int(12) NOT NULL COMMENT '关注人ID',
  INDEX `uid_touid_index`(`uid`, `touid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_auth
-- ----------------------------
CREATE TABLE `cmf_user_auth`  (
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '电话',
  `cer_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '身份证号',
  `front_view` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '正面',
  `back_view` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '反面',
  `handset_view` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '手持',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '审核说明',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '提交时间',
  `uptime` int(12) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0 处理中 1 成功 2 失败',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_balance_cashrecord
-- ----------------------------
CREATE TABLE `cmf_user_balance_cashrecord`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `money` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '提现金额',
  `orderno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `trade_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '三方订单号',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态，0审核中，1审核通过，2审核拒绝',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '申请时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '账号类型 1 支付宝 2 微信 3 银行卡',
  `account_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '银行名称',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '帐号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '姓名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_balance_record
-- ----------------------------
CREATE TABLE `cmf_user_balance_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NOT NULL COMMENT '用户id',
  `touid` bigint(20) NOT NULL COMMENT '对方用户id',
  `balance` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '操作的余额数',
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支类型,0支出1收入',
  `action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支行为 1 买家使用余额付款 2 系统自动结算货款给卖家  3 卖家超时未发货,退款给买家 4 买家发起退款，卖家超时未处理,系统自动退款 5买家发起退款，卖家同意 6 买家发起退款，平台介入后同意 7 用户使用余额购买付费项目  8 付费项目收入',
  `orderid` bigint(20) NOT NULL DEFAULT 0 COMMENT '对应的订单ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_banrecord
-- ----------------------------
CREATE TABLE `cmf_user_banrecord`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ban_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '被禁用原因',
  `ban_long` int(10) DEFAULT 0 COMMENT '用户禁用时长：单位：分钟',
  `uid` int(10) DEFAULT 0 COMMENT '禁用 用户ID',
  `addtime` int(10) DEFAULT 0 COMMENT '提交时间',
  `end_time` int(10) DEFAULT 0 COMMENT '禁用到期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_black
-- ----------------------------
CREATE TABLE `cmf_user_black`  (
  `uid` int(12) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(12) NOT NULL DEFAULT 0 COMMENT '被拉黑人ID',
  INDEX `uid_touid_index`(`uid`, `touid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_coinrecord
-- ----------------------------
CREATE TABLE `cmf_user_coinrecord`  (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支类型,0支出1收入',
  `action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支行为，1赠送礼物,2弹幕,3登录奖励,4购买VIP,5购买坐骑,6房间扣费,7计时扣费,8发送红包,9抢红包,10开通守护,11注册奖励,12礼物中奖,13奖池中奖,14缴纳保证金,15退还保证金,16转盘游戏,17转盘中奖,18购买靓号',
  `uid` int(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(20) NOT NULL DEFAULT 0 COMMENT '对方ID',
  `giftid` int(20) NOT NULL DEFAULT 0 COMMENT '行为对应ID',
  `giftcount` int(20) NOT NULL DEFAULT 0 COMMENT '数量',
  `totalcoin` int(20) NOT NULL DEFAULT 0 COMMENT '总价',
  `showid` int(12) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `mark` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标识，1表示热门礼物，2表示守护礼物',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `action_uid_addtime`(`action`, `uid`, `addtime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_goods_visit
-- ----------------------------
CREATE TABLE `cmf_user_goods_visit`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` bigint(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `goodsid` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `time_format` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_pushid
-- ----------------------------
CREATE TABLE `cmf_user_pushid`  (
  `uid` int(10) UNSIGNED NOT NULL COMMENT '用户ID',
  `pushid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '用户对应极光registration_id',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_scorerecord
-- ----------------------------
CREATE TABLE `cmf_user_scorerecord`  (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支类型,0支出1收入',
  `action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支行为，4购买VIP,5购买坐骑,18购买靓号,21游戏获胜',
  `uid` int(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(20) NOT NULL DEFAULT 0 COMMENT '对方ID',
  `giftid` int(20) NOT NULL DEFAULT 0 COMMENT '行为对应ID',
  `giftcount` int(20) NOT NULL DEFAULT 0 COMMENT '数量',
  `totalcoin` int(20) NOT NULL DEFAULT 0 COMMENT '总价',
  `showid` int(12) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `addtime` int(12) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `game_action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '游戏类型',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `action_uid_addtime`(`action`, `uid`, `addtime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_sign
-- ----------------------------
CREATE TABLE `cmf_user_sign`  (
  `uid` int(11) NOT NULL COMMENT '用户ID',
  `bonus_day` int(11) NOT NULL DEFAULT 0 COMMENT '登录天数',
  `bonus_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `count_day` int(11) NOT NULL DEFAULT 0 COMMENT '连续登陆天数',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_subscribe
-- ----------------------------
CREATE TABLE `cmf_user_subscribe`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '订阅用户ID',
  `touid` int(11) NOT NULL COMMENT '被订阅用户ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '订阅时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_super
-- ----------------------------
CREATE TABLE `cmf_user_super`  (
  `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_token
-- ----------------------------
CREATE TABLE `cmf_user_token`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',
  `expire_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT ' 过期时间',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'token',
  `device_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unq_user_id_device_type`(`user_id`, `device_type`) USING BTREE,
  INDEX `idx_token`(`token`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户客户端登录 token 表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_voterecord
-- ----------------------------
CREATE TABLE `cmf_user_voterecord`  (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支类型,0支出，1收入',
  `action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收支行为,1收礼物2弹幕3分销收益4家族长收益6房间收费7计时收费10守护',
  `uid` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `fromid` bigint(20) NOT NULL DEFAULT 0 COMMENT '来源用户ID',
  `actionid` bigint(20) NOT NULL DEFAULT 0 COMMENT '行为对应ID',
  `nums` bigint(20) NOT NULL DEFAULT 0 COMMENT '数量',
  `total` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '总价',
  `showid` bigint(20) NOT NULL DEFAULT 0 COMMENT '直播标识',
  `votes` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '收益映票',
  `addtime` bigint(20) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `action_uid_addtime`(`action`, `uid`, `addtime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_user_zombie
-- ----------------------------
CREATE TABLE `cmf_user_zombie`  (
  `uid` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_verification_code
-- ----------------------------
CREATE TABLE `cmf_verification_code`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表id',
  `count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '当天已经发送成功的次数',
  `send_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后发送成功时间',
  `expire_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证码过期时间',
  `code` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后发送成功的验证码',
  `account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号或者邮箱',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '手机邮箱数字验证码表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video
-- ----------------------------
CREATE TABLE `cmf_video`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '标题',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面图片',
  `thumb_s` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '封面小图',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '视频地址',
  `href_w` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '水印视频',
  `likes` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `views` int(11) NOT NULL DEFAULT 1 COMMENT '浏览数（涉及到推荐排序机制，所以默认为1）',
  `comments` int(11) NOT NULL DEFAULT 0 COMMENT '评论数',
  `steps` int(11) NOT NULL DEFAULT 0 COMMENT '踩总数',
  `shares` int(11) NOT NULL DEFAULT 0 COMMENT '分享数量',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '发布时间',
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '维度',
  `lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '经度',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '城市',
  `isdel` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 1删除（下架）0不下架',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '视频状态 0未审核 1通过 2拒绝',
  `music_id` int(12) NOT NULL DEFAULT 0 COMMENT '背景音乐ID',
  `xiajia_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '下架原因',
  `nopass_time` int(12) NOT NULL DEFAULT 0 COMMENT '审核不通过时间（第一次审核不通过时更改此值，用于判断是否发送极光IM）',
  `watch_ok` int(12) NOT NULL DEFAULT 1 COMMENT '视频完整看完次数(涉及到推荐排序机制，所以默认为1)',
  `is_ad` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为广告视频 0 否 1 是',
  `ad_endtime` int(12) NOT NULL DEFAULT 0 COMMENT '广告显示到期时间',
  `ad_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '广告外链',
  `orderno` int(12) NOT NULL DEFAULT 0 COMMENT '权重值，数字越大越靠前',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '视频绑定类型 0 未绑定 1 商品  2 付费内容',
  `goodsid` bigint(20) NOT NULL DEFAULT 0 COMMENT '商品ID',
  `classid` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_class
-- ----------------------------
CREATE TABLE `cmf_video_class`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '分类名',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_comments
-- ----------------------------
CREATE TABLE `cmf_video_comments`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '评论用户ID',
  `touid` int(10) NOT NULL DEFAULT 0 COMMENT '被评论的用户ID',
  `videoid` int(10) NOT NULL DEFAULT 0 COMMENT '视频ID',
  `commentid` int(10) NOT NULL DEFAULT 0 COMMENT '所属评论ID',
  `parentid` int(10) NOT NULL DEFAULT 0 COMMENT '上级评论ID',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '评论内容',
  `likes` int(11) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  `at_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '评论时被@用户的信息（json串）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_comments_like
-- ----------------------------
CREATE TABLE `cmf_video_comments_like`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `commentid` int(10) NOT NULL DEFAULT 0 COMMENT '评论ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  `touid` int(12) NOT NULL DEFAULT 0 COMMENT '被喜欢的评论者id',
  `videoid` int(12) NOT NULL DEFAULT 0 COMMENT '评论所属视频id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_like
-- ----------------------------
CREATE TABLE `cmf_video_like`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `videoid` int(10) NOT NULL DEFAULT 0 COMMENT '视频ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '视频是否被删除或被拒绝 0被删除或被拒绝 1 正常',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_report
-- ----------------------------
CREATE TABLE `cmf_video_report`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `touid` int(11) NOT NULL DEFAULT 0 COMMENT '被举报用户ID',
  `videoid` int(11) NOT NULL DEFAULT 0 COMMENT '视频ID',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0处理中 1已处理  2审核失败',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '提交时间',
  `uptime` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_report_classify
-- ----------------------------
CREATE TABLE `cmf_video_report_classify`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `list_order` int(10) NOT NULL DEFAULT 9999 COMMENT '排序',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '举报类型名称',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_step
-- ----------------------------
CREATE TABLE `cmf_video_step`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `videoid` int(10) NOT NULL DEFAULT 0 COMMENT '视频ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_video_view
-- ----------------------------
CREATE TABLE `cmf_video_view`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `videoid` int(10) NOT NULL DEFAULT 0 COMMENT '视频ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_vip
-- ----------------------------
CREATE TABLE `cmf_vip`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coin` int(11) NOT NULL DEFAULT 0 COMMENT '价格',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '名称',
  `length` int(11) NOT NULL DEFAULT 1 COMMENT '时长（月）',
  `score` int(11) NOT NULL DEFAULT 0 COMMENT '积分价格',
  `list_order` int(11) NOT NULL DEFAULT 9999 COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_vip_user
-- ----------------------------
CREATE TABLE `cmf_vip_user`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `addtime` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `endtime` int(10) NOT NULL DEFAULT 0 COMMENT '到期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cmf_watermark
-- ----------------------------
CREATE TABLE `cmf_watermark`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '水印名称',
  `position` int(11) NOT NULL DEFAULT 1 COMMENT '1:上左 2:上右 3:下左 4:下右',
  `xpos` int(11) NOT NULL DEFAULT 0 COMMENT 'x轴坐标比例',
  `ypos` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'y轴坐标比例',
  `device` int(11) NOT NULL DEFAULT 1 COMMENT '1:PC 2:APP/H5',
  `width` int(11) DEFAULT 0 COMMENT '宽度',
  `height` int(11) DEFAULT 0 COMMENT '高度',
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '水印图片',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `status`(`ypos`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '水印表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
