x1-project/db/x1_backstage.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.3.245
 Source Server Type    : MySQL
 Source Server Version : 50727 (5.7.27)
 Source Host           : 192.168.3.245:33061
 Source Schema         : x1_backstage

 Target Server Type    : MySQL
 Target Server Version : 50727 (5.7.27)
 File Encoding         : 65001

 Date: 05/03/2025 09:32:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for api_doc
-- ----------------------------
DROP TABLE IF EXISTS `api_doc`;
CREATE TABLE `api_doc` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `href_url` varchar(255) DEFAULT '' COMMENT '链接地址',
  `comment` varchar(255) DEFAULT '' COMMENT '接口说明',
  `param_form` varchar(2000) DEFAULT '' COMMENT '参数格式',
  `return_form` varchar(2000) DEFAULT '' COMMENT '返回格式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000144 DEFAULT CHARSET=utf8mb4 COMMENT='接口说明';

-- ----------------------------
-- Records of api_doc
-- ----------------------------
BEGIN;
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000001, '/gameRegion/data.auth', '请求渠道大区数据', 'channelId:long;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"regionId\":0,\"name\":null,\"channelId\":0,\"channelName\":null,\"serverType\":0,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000002, '/gameRegion/options.do', '渠道大区下拉菜单数据', 'channelId:long;\n', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000003, '/gameRegion/delete.authw', '删除渠道大区数据', 'channelId:long;\nregionId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000004, '/gameRegion/save.authw', '保存渠道大区数据，ID小于等于0时新增，大于0时修改', 'id:long;\nregionId:int;\nname:String;\nchannelId:long;\nserverType:int;\n', '{\"id\":0,\"regionId\":0,\"name\":null,\"channelId\":0,\"channelName\":null,\"serverType\":0,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000005, '/playerPayRemain/data.auth', '请求付费留存数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\n', '{\"count\":0,\"data\":[{\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"bornDate\":null,\"dayBase\":0,\"day0\":0,\"day1\":0,\"day2\":0,\"day3\":0,\"day4\":0,\"day5\":0,\"day6\":0,\"day7\":0,\"day8\":0,\"day9\":0,\"day10\":0,\"day11\":0,\"day12\":0,\"day13\":0,\"day14\":0,\"day30\":0,\"day60\":0,\"day90\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000006, '/playerPayRemain/manual.auth', '手动触发昨天付费留存数据统计', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000007, '/playerLtv/data.auth', '请求付费LTV数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\n', '{\"count\":0,\"data\":[{\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"bornDate\":null,\"playerCount\":0,\"day0\":0,\"day1\":0,\"day2\":0,\"day3\":0,\"day4\":0,\"day5\":0,\"day6\":0,\"day7\":0,\"day8\":0,\"day9\":0,\"day10\":0,\"day11\":0,\"day12\":0,\"day13\":0,\"day14\":0,\"day30\":0,\"day60\":0,\"day90\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000008, '/playerLtv/manual.auth', '手动触发昨天LTV数据统计', 'command:String;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000009, '/gameChannel/data.auth', '请求渠道数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"platformId\":0,\"platformName\":null,\"userId\":0,\"userName\":null,\"bulletinId\":0,\"programVersion\":null,\"resourceVersion\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000010, '/gameChannel/options.do', '请求渠道下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000011, '/gameChannel/change.do', '切换渠道', 'channelId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000012, '/gameChannel/delete.authw', '删除渠道数据，并删除与之关联的服务器关系数据', 'channelId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000013, '/gameChannel/save.authw', '保存渠道数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\nname:String;\nbulletinId:long;\nplatformId:long;\nprogramVersion:String;\nresourceVersion:String;\n', '{\"id\":0,\"name\":null,\"platformId\":0,\"platformName\":null,\"userId\":0,\"userName\":null,\"bulletinId\":0,\"programVersion\":null,\"resourceVersion\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2025-02-27 10:13:48', 100000014, '/player/data.auth', '请求玩家数据', 'playerId:long;\nname:String;\nopenId:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelInfo\":null,\"serverInfo\":null,\"playerId\":0,\"openId\":null,\"nick\":null,\"head\":null,\"sex\":0,\"level\":0,\"gold\":0,\"diamond\":0,\"fighting\":0,\"recharge\":0,\"online\":false,\"dailyOnline\":0,\"bornTime\":{\"date\":{\"year\":2025,\"month\":2,\"day\":27},\"time\":{\"hour\":10,\"minute\":13,\"second\":48,\"nano\":296000000}},\"lastLoginTime\":{\"date\":{\"year\":2025,\"month\":2,\"day\":27},\"time\":{\"hour\":10,\"minute\":13,\"second\":48,\"nano\":297000000}},\"quickUrl\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000015, '/player/hero.auth', '请求玩家英雄数据', 'playerId:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"quality\":0,\"level\":0,\"num\":0,\"fighting\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000016, '/player/bag.auth', '请求玩家背包数据', 'playerId:long;\n', '{\"count\":0,\"data\":[{\"itemId\":0,\"itemName\":null,\"haveNum\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000017, '/api/playerReport', '上报玩家数据，给游戏服的接口', 'serverId:int;\ndatas:List;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000018, '/player/detail.auth', '请求玩家数据详情', 'playerId:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"openId\":null,\"serverId\":0,\"nick\":null,\"head\":null,\"sex\":0,\"level\":0,\"exp\":0,\"gold\":0,\"diamond\":0,\"nowFighting\":0,\"hisMaxFighting\":0,\"changeNameNum\":0,\"online\":false,\"lastLoginTime\":null,\"lastLogoutTime\":null,\"forbidEndTime\":null,\"dailyOnline\":0,\"realTotalPay\":0,\"loginIp\":null,\"loginDeviceType\":null,\"loginDeviceId\":null,\"loginVersion\":null,\"createIp\":null,\"createDeviceType\":null,\"createDeviceId\":null,\"createChannel\":0,\"oldPlayer\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000019, '/rechargeVirtual/data.auth', '请求虚拟充值（内部充值）数据', 'openId:String;\nplayerId:long;\nnick:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"playerId\":0,\"nick\":null,\"openId\":null,\"productId\":0,\"productName\":null,\"money\":0,\"userId\":0,\"userName\":null,\"status\":0,\"remark\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000020, '/rechargeVirtual/add.authw', '发放虚拟充值（内部充值）', 'playerId:long;\nproductId:int;\nremark:String;\n', '{\"id\":0,\"channelId\":0,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"playerId\":0,\"nick\":null,\"openId\":null,\"productId\":0,\"productName\":null,\"money\":0,\"userId\":0,\"userName\":null,\"status\":0,\"remark\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000021, '/itemCfg/data.auth', '请求游戏道具数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000022, '/itemCfg/options.do', '道具下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000023, '/itemCfg/refresh.auth', '更新游戏道具数据', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000024, '/recruitRefreshDotData/data.auth', '招募刷新打点数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"dateStr\":null,\"num0to10\":0,\"num11to20\":0,\"num21toMax\":0,\"joinNum\":0,\"createNum\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000025, '/serverOpen/data.auth', '请求服务器开服数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"platformId\":0,\"platformName\":null,\"serverId\":0,\"name\":null,\"socketType\":null,\"externalIp\":null,\"internalIp\":null,\"tcpPort\":0,\"httpPort\":0,\"dbIp\":null,\"dbPort\":null,\"dbUser\":null,\"dbPwd\":null,\"dbGameName\":null,\"dbLogName\":null,\"hide\":false,\"status\":0,\"recommend\":false,\"openTime\":null,\"realOpenTime\":null,\"sendOpenStatus\":0,\"opening\":false,\"serverType\":0,\"running\":false,\"heartTime\":null,\"registerNum\":0,\"createNum\":0,\"onlineNum\":0,\"battleNum\":0,\"currBattleNum\":0,\"maxMemory\":null,\"freeMemory\":null,\"totalMemory\":null,\"leftMemory\":null,\"usedMemory\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000026, '/serverOpen/openNow.authw', '立刻开服', 'serverUid:int;\n', '{\"id\":0,\"platformId\":0,\"platformName\":null,\"serverId\":0,\"name\":null,\"socketType\":null,\"externalIp\":null,\"internalIp\":null,\"tcpPort\":0,\"httpPort\":0,\"dbIp\":null,\"dbPort\":null,\"dbUser\":null,\"dbPwd\":null,\"dbGameName\":null,\"dbLogName\":null,\"hide\":false,\"status\":0,\"recommend\":false,\"openTime\":null,\"realOpenTime\":null,\"sendOpenStatus\":0,\"opening\":false,\"serverType\":0,\"running\":false,\"heartTime\":null,\"registerNum\":0,\"createNum\":0,\"onlineNum\":0,\"battleNum\":0,\"currBattleNum\":0,\"maxMemory\":null,\"freeMemory\":null,\"totalMemory\":null,\"leftMemory\":null,\"usedMemory\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000027, '/serverOpen/editOpenTime.authw', '设置服务器预期开服时间', 'serverUid:int;\nopenTime:long;\n', '{\"id\":0,\"platformId\":0,\"platformName\":null,\"serverId\":0,\"name\":null,\"socketType\":null,\"externalIp\":null,\"internalIp\":null,\"tcpPort\":0,\"httpPort\":0,\"dbIp\":null,\"dbPort\":null,\"dbUser\":null,\"dbPwd\":null,\"dbGameName\":null,\"dbLogName\":null,\"hide\":false,\"status\":0,\"recommend\":false,\"openTime\":null,\"realOpenTime\":null,\"sendOpenStatus\":0,\"opening\":false,\"serverType\":0,\"running\":false,\"heartTime\":null,\"registerNum\":0,\"createNum\":0,\"onlineNum\":0,\"battleNum\":0,\"currBattleNum\":0,\"maxMemory\":null,\"freeMemory\":null,\"totalMemory\":null,\"leftMemory\":null,\"usedMemory\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000028, '/fixDesignResult/data.auth', '请求热更配置结果数据', 'id:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"fixId\":0,\"serverUid\":0,\"serverId\":0,\"name\":null,\"status\":0,\"code\":0,\"message\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000029, '/fixDesign/data.auth', '请求热更配置记录', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"serverUids\":[],\"fileNames\":[],\"userId\":0,\"userName\":null,\"fixTime\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000030, '/loginDotData/data.auth', '登录打点接口', 'startTime:int;\nendTime:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"dateStr\":null,\"reqResUrlBegin\":0,\"reqResUrlSucess\":0,\"reqResUrlFail\":0,\"sdkLoginBegin\":0,\"sdkLoginSucess\":0,\"sdkLoginFail\":0,\"reqServerVerifyBegin\":0,\"reqServerVerifySucess\":0,\"reqServerVerifyFail\":0,\"reqServerListBegin\":0,\"reqServerListSucess\":0,\"reqServerListFail\":0,\"startGame\":0,\"reqSocketConnectSucess\":0,\"reqSocketLoginBegin\":0,\"reqSocketLoginSucess\":0,\"reqSocketLoginFail\":0,\"createSucc\":0,\"reqServerPushDataEnd\":0,\"inGame\":0,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000031, '/api/loginDot', '提供给游戏客户端使用，非主后台的登录打点接口', 'channelId:long;\nopenId:String;\ntiming:int;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000032, '/api/loginDotMain', '主后台的登录打点接口', 'channelId:long;\nopenId:String;\ntiming:int;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000033, '/api/loginDotReport', '提供给游戏服使用，上报登录打点接口', 'datas:List;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000034, '/clientVersion/data.auth', '请求客户端版本信息数据', 'channelId:long;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"channelName\":null,\"versionCode\":0,\"serverType\":0,\"remoteUrl\":null,\"resourceVersion\":null,\"remark\":null,\"pcResourceVersion\":null,\"quickUrl\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000035, '/clientVersion/delete.authw', '删除版本信息数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000036, '/clientVersion/save.authw', '保存版本信息数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\nchannelId:long;\nversionCode:int;\nserverType:int;\nremark:String;\nremoteUrl:String;\nresourceVersion:String;\npcResourceVersion:String;\nquickUrl:String;\n', '{\"id\":0,\"channelId\":0,\"channelName\":null,\"versionCode\":0,\"serverType\":0,\"remoteUrl\":null,\"resourceVersion\":null,\"remark\":null,\"pcResourceVersion\":null,\"quickUrl\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000037, '/playerScatterLog/data.auth', '获取玩家在线时间占比', 'startTime:int;\nendTime:int;\nserverUids:List;\n', '{\"count\":0,\"data\":[{\"date\":0,\"timePeriod\":0,\"timePeriodText\":null,\"onlineNum\":0,\"onlineBase\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000038, '/whiteList/data.auth', '请求白名单数据', 'openId:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"channelName\":null,\"openId\":null,\"userId\":0,\"userName\":null,\"remark\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000039, '/api/isWhiteList', '是否为白名单，给游戏服的接口', 'channelId:int;\nopenId:String;\n', '\"\"');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000040, '/whiteList/delete.authw', '删除白名单', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000041, '/whiteList/add.authw', '添加白名单', 'openId:String;\nremark:String;\n', '{\"id\":0,\"channelId\":0,\"channelName\":null,\"openId\":null,\"userId\":0,\"userName\":null,\"remark\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000042, '/mail/resend.auth', '重新发送系统邮件', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000043, '/mail/save.authw', '保存系统邮件数据', 'id:long;\ntitle:String;\ncontent:String;\nrewards:String;\ntype:int;\nserverUids:Set;\npids:String;\nplayerLevel:int;\n', '{\"id\":0,\"userId\":0,\"userName\":null,\"title\":null,\"content\":null,\"rewards\":[{\"item\":0,\"name\":null,\"num\":0}],\"type\":0,\"serverUids\":[],\"sendServerUids\":[],\"deleteServerUids\":[],\"pids\":null,\"playerLevel\":0,\"status\":0,\"checkUserId\":0,\"checkUserName\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000044, '/mail/data.auth', '请求系统邮件数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"userId\":0,\"userName\":null,\"title\":null,\"content\":null,\"rewards\":null,\"type\":0,\"pids\":null,\"playerLevel\":0,\"status\":0,\"checkUserId\":0,\"checkUserName\":null,\"serverUids\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000045, '/mail/checkPass.authw', '系统邮件审核通过', 'ids:List;\n', '{\"mails\":[{\"id\":0,\"userId\":0,\"userName\":null,\"title\":null,\"content\":null,\"rewards\":[],\"type\":0,\"serverUids\":[],\"sendServerUids\":[],\"deleteServerUids\":[],\"pids\":null,\"playerLevel\":0,\"status\":0,\"checkUserId\":0,\"checkUserName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000046, '/mail/checkNotPass.authw', '系统邮件审核不通过', 'ids:List;\n', '{\"mails\":[{\"id\":0,\"userId\":0,\"userName\":null,\"title\":null,\"content\":null,\"rewards\":[],\"type\":0,\"serverUids\":[],\"sendServerUids\":[],\"deleteServerUids\":[],\"pids\":null,\"playerLevel\":0,\"status\":0,\"checkUserId\":0,\"checkUserName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000047, '/mail/delete.authw', '通知游戏服删除系统邮件', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000048, '/mail/mailResult.auth', '请求系统邮件发送结果数据', 'id:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"mailId\":0,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"typeText\":null,\"status\":0,\"message\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000049, '/serverCommand/send.authw', '发送服务器指令', 'serverUid:long;\ncommand:String;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000050, '/giftCodeShareLog/data.auth', '请求通用礼包码使用日志数据', 'code:String;\nplayerId:long;\nplayerName:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"code\":null,\"playerId\":0,\"playerName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000051, '/userfunction/data.auth', '请求用户权限数据', 'userName:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"userId\":0,\"userName\":null,\"functionId\":0,\"functionName\":null,\"writee\":false,\"grantUserId\":0,\"grantUserName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000052, '/userfunction/options.auth', '获取可授权的菜单数据', 'userId:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"has\":false,\"writee\":false,\"module\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000053, '/userfunction/save.authw', '保存用户权限数据', 'userId:long;\nfunctionAndWrite:List;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"has\":false,\"writee\":false,\"module\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000054, '/serverResume/data.auth', '获取游戏汇总数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"dateStr\":null,\"playerNum\":0,\"newPlayerNum\":0,\"loginPlayerNum\":0,\"loginNum\":0,\"oldLoginNum\":0,\"rechargeNum\":0,\"rechargePlayerNum\":0,\"rechargeForDiamond\":0,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000055, '/gameCause/data.auth', '请求流水事件数据', 'openId:String;\nname:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000056, '/gameCause/options.do', '流水事件下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000057, '/gameCause/refresh.auth', '更新流水事件数据', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2025-02-27 10:13:48', 100000058, '/playerMail/data.auth', '请求玩家邮件数据', 'channleId:long;\nplayerId:long;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"receiver\":0,\"template\":0,\"titleArgs\":[],\"contentArgs\":[],\"attachment\":null,\"read\":false,\"receive\":false,\"expireTime\":{\"date\":{\"year\":2025,\"month\":2,\"day\":27},\"time\":{\"hour\":10,\"minute\":13,\"second\":48,\"nano\":292000000}},\"gameCause\":0,\"gameCauseText\":null,\"fromPoolId\":0,\"channelId\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000059, '/playerMail/delete.authw', '删除玩家邮件数据', 'channelId:long;\nplayerId:long;\nmailId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000060, '/rechargeProductCfg/data.auth', '请求游戏充值商品配置数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"describe\":null,\"money\":0,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000061, '/rechargeProductCfg/refresh.auth', '更新游戏充值商品配置数据', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000062, '/api/dbs', '请求游戏服的数据库配置', 'platformId:int;\nserverId:int;\ntype:String;\ntime:long;\nsign:String;\n', '[{\"id\":0,\"alias\":null,\"ipPort\":null,\"dbName\":null,\"user\":null,\"password\":null,\"minIdle\":0,\"maxActive\":0,\"maxWaitMillis\":0}]');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000063, '/guideDotData/data.auth', '引导打点数据', 'serverUid:int;\n', '{\"count\":0,\"data\":[{\"guideId\":0,\"guideName\":null,\"step\":0,\"num\":0,\"loseNum\":0,\"loseRate\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000064, '/giftCode/data.auth', '请求礼包码数据', 'configId:int;\ncode:String;\nplayerId:long;\nplayerName:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"code\":null,\"channelId\":0,\"type\":0,\"configId\":0,\"configName\":null,\"userId\":0,\"userName\":null,\"playerId\":0,\"playerName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000065, '/api/canUseCode', '礼包码是否可用，给游戏服的接口', 'channelId:int;\ncode:String;\nplayerId:long;\nplayerName:String;\n', '\"\"');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000066, '/giftCode/save.authw', '新增礼包码数据', 'type:int;\ncode:String;\nconfigId:int;\nnum:int;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000067, '/api/fushun/recharge', '提供给fushun的充值回调接口', ':String;\n:String;\n:String;\n:String;\n:String;\n:String;\n:String;\n:String;\n:String;\n:String;\n', '\"\"');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000068, '/api/fushun/login', '提供给游戏客户端验证fushun登录数据的接口', 'code:String;\n', '{\"code\":0,\"message\":null,\"data\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000069, '/modulemenu/data.auth', '请求模块菜单数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"systemId\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"component\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000070, '/modulemenu/update.authw', '更新模块菜单数据', 'id:long;\nsort:long;\nicon:String;\n', '{\"id\":0,\"systemId\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"component\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000071, '/gameServerMaintain/data.auth', '请求服务器维护数据', 'platformId:long;\n', '{\"count\":0,\"data\":[{\"serverId\":0,\"name\":null,\"maintain\":false,\"maintainResponse\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000072, '/gameServerMaintain/maintain.authw', '进行服务器维护', 'platformId:long;\nserverIds:List;\n', '{\"count\":0,\"data\":[{\"serverId\":0,\"name\":null,\"maintain\":false,\"maintainResponse\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000073, '/gameServerMaintain/resendMaintain.authw', '重新发送进行服务器维护', 'platformId:long;\nserverIds:List;\n', '{\"count\":0,\"data\":[{\"serverId\":0,\"name\":null,\"maintain\":false,\"maintainResponse\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000074, '/gameServerMaintain/endMaintain.authw', '结束服务器维护', 'platformId:long;\nserverIds:List;\n', '{\"count\":0,\"data\":[{\"serverId\":0,\"name\":null,\"maintain\":false,\"maintainResponse\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000075, '/gameServerMaintain/resendEndMaintain.authw', '重新发送结束服务器维护', 'platformId:long;\nserverIds:List;\n', '{\"count\":0,\"data\":[{\"serverId\":0,\"name\":null,\"maintain\":false,\"maintainResponse\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000076, '/bulletin/data.auth', '请求公告数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"title\":null,\"content\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000077, '/bulletin/options.do', '请求公告下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000078, '/bulletin/delete.authw', '删除渠道数据，并删除与之关联的服务器关系数据', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000079, '/bulletin/save.authw', '保存公告数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\ntitle:String;\ncontent:String;\n', '{\"id\":0,\"title\":null,\"content\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000080, '/user/data.auth', '请求用户列表数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"password\":null,\"level\":0,\"superUser\":false,\"upUserId\":0,\"phone\":null,\"mailAddress\":null,\"usable\":false,\"canReadSensitive\":false,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000081, '/user/delete.authw', '删除用户数据', 'id:long;\nname:String;\npassword:String;\nusable:boolean;\nsuperUser:boolean;\nphone:String;\nmailAddress:String;\ncanReadSensitive:boolean;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000082, '/user/save.authw', '保存用户数据，数据ID小于等于0时新增，大于0时更新', 'id:long;\nname:String;\npassword:String;\nusable:boolean;\nsuperUser:boolean;\nphone:String;\nmailAddress:String;\ncanReadSensitive:boolean;\n', '{\"id\":0,\"name\":null,\"password\":null,\"level\":0,\"superUser\":false,\"upUserId\":0,\"phone\":null,\"mailAddress\":null,\"usable\":false,\"canReadSensitive\":false,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000083, '/recharge/data.auth', '请求充值订单数据', 'playerId:long;\nnick:String;\nopenId:String;\nsdkOrderId:String;\nstartTime:int;\nendTime:int;\nstatus:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"platformId\":0,\"channelId\":0,\"serverId\":0,\"playerId\":0,\"nick\":null,\"openId\":null,\"level\":0,\"sdkOrderId\":null,\"gameOrderId\":null,\"money\":0,\"productId\":0,\"productName\":null,\"give\":0,\"remark\":null,\"remarkIdx\":0,\"test\":0,\"allCheck\":false,\"sign\":null,\"localSign\":null,\"extraSign\":null,\"localExtraSign\":null,\"remoteIp\":null,\"callbackData\":null,\"gameResponse\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000084, '/recharge/manual.authw', '人工触发订单补发发货', 'rechargeId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000085, '/taskDotData/data.auth', '任务打点数据', 'serverUid:int;\n', '{\"count\":0,\"data\":[{\"taskId\":0,\"taskName\":null,\"startNum\":0,\"finishNum\":0,\"finishRate\":0.0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000086, '/systemmenu/data.auth', '请求系统菜单数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"component\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000087, '/systemmenu/update.authw', '更新系统菜单数据', 'id:long;\nsort:long;\nicon:String;\n', '{\"id\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"component\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000088, '/fixCodeResult/data.auth', '请求热更代码结果数据', 'id:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"fixId\":0,\"serverUid\":0,\"serverId\":0,\"name\":null,\"status\":0,\"code\":0,\"message\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000089, '/fixCode/data.auth', '请求热更代码记录', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"serverUids\":[],\"fileNames\":[],\"userId\":0,\"userName\":null,\"fixTime\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000090, '/fixCodeResult/patch.auth', '执行补丁', 'serverUids:Set;\nparam:String;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000091, '/gameServer/data.auth', '请求服务器数据', 'platformId:long;\nserverId:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"platformId\":0,\"platformName\":null,\"serverId\":0,\"name\":null,\"socketType\":null,\"externalIp\":null,\"internalIp\":null,\"tcpPort\":0,\"httpPort\":0,\"dbIp\":null,\"dbPort\":null,\"dbUser\":null,\"dbPwd\":null,\"dbGameName\":null,\"dbLogName\":null,\"hide\":false,\"status\":0,\"recommend\":false,\"openTime\":null,\"realOpenTime\":null,\"sendOpenStatus\":0,\"opening\":false,\"serverType\":0,\"running\":false,\"heartTime\":null,\"registerNum\":0,\"createNum\":0,\"onlineNum\":0,\"battleNum\":0,\"currBattleNum\":0,\"maxMemory\":null,\"freeMemory\":null,\"totalMemory\":null,\"leftMemory\":null,\"usedMemory\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000092, '/gameServer/options.do', '服务器下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000093, '/gameServer/save.authw', '保存服务器数据，ID小于等于0时新增，大于0时修改', 'id:long;\nplatformId:long;\nplatformName:String;\nserverId:int;\nname:String;\nexternalIp:String;\ninternalIp:String;\ntcpPort:int;\nhttpPort:int;\ndbIp:String;\ndbPort:String;\ndbUser:String;\ndbPwd:String;\ndbGameName:String;\ndbLogName:String;\nstatus:int;\nrecommend:boolean;\nserverType:int;\nsocketType:String;\nhide:boolean;\n', '{\"id\":0,\"platformId\":0,\"platformName\":null,\"serverId\":0,\"name\":null,\"socketType\":null,\"externalIp\":null,\"internalIp\":null,\"tcpPort\":0,\"httpPort\":0,\"dbIp\":null,\"dbPort\":null,\"dbUser\":null,\"dbPwd\":null,\"dbGameName\":null,\"dbLogName\":null,\"hide\":false,\"status\":0,\"recommend\":false,\"openTime\":null,\"realOpenTime\":null,\"sendOpenStatus\":0,\"opening\":false,\"serverType\":0,\"running\":false,\"heartTime\":null,\"registerNum\":0,\"createNum\":0,\"onlineNum\":0,\"battleNum\":0,\"currBattleNum\":0,\"maxMemory\":null,\"freeMemory\":null,\"totalMemory\":null,\"leftMemory\":null,\"usedMemory\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000094, '/gameServer/optionsInCurrChannel.do', '根据当前渠道获取服务器下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000095, '/api/versionInfo', '请求客户端版本信息，给游戏客户端请求用的', 'channelId:long;\nversionId:int;\n', '{\"remoteUrl\":null,\"resourceVersion\":null,\"pcResourceVersion\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000096, '/api/serversList', '请求服务器列表，给游戏客户端请求用的', 'channelId:long;\nopenId:String;\n:Integer;\n', '{\"title\":null,\"content\":null,\"players\":[{\"serverId\":0,\"nick\":null,\"level\":0,\"head\":null}],\"regions\":[{\"id\":0,\"name\":null}],\"servers\":[{\"id\":0,\"name\":null,\"ip\":null,\"port\":0,\"status\":0,\"socketType\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000097, '/api/serverInRegion', '请求游戏大区下的服务器列表，给游戏客户端请求用的', 'regionId:long;\n', '[{\"id\":0,\"name\":null,\"ip\":null,\"port\":0,\"status\":0,\"socketType\":null}]');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000098, '/api/heartBeat', '游戏服务器上报心跳', 'platformId:int;\nserverId:int;\nplayerNum:int;\nonlineNum:int;\nbattleNum:int;\ncurrBattleNum:int;\nmaxMemory:String;\nfreeMemory:String;\ntotalMemory:String;\nleftMemory:String;\nusedMemory:String;\nrunning:boolean;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000099, '/godFinger/data.auth', '请求金手指名单数据', 'openId:String;\nname:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"channelName\":null,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"playerId\":0,\"openId\":null,\"nick\":null,\"remark\":null,\"money\":0,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000100, '/godFinger/delete.authw', '删除金手指名单数据', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000101, '/godFinger/save.authw', '保存金手指名单数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\nplayerId:long;\nremark:String;\nmoney:long;\n', '{\"id\":0,\"channelId\":0,\"channelName\":null,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"playerId\":0,\"openId\":null,\"nick\":null,\"remark\":null,\"money\":0,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000102, '/userChannel/data.auth', '请求用户与渠道关系数据', 'userName:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"phone\":null,\"mailAddress\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000103, '/userChannel/options.auth', '获取可授权的渠道数据', 'userId:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"has\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000104, '/userChannel/save.authw', '保存用户与渠道关系数据', 'userId:long;\nchannel:List;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"has\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000105, '/consume/data.auth', '获取游戏消费统计数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\nresourceType:int;\nconsumeType:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"index\":0,\"gameCause\":0,\"gameCauseTxt\":null,\"resourceType\":null,\"consumeType\":0,\"playerNum\":0,\"countNum\":0,\"total\":0,\"avg\":0.0,\"weight\":0.0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000106, '/functionmenu/data.auth', '请求功能菜单数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"moduleId\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"authClazz\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000107, '/functionmenu/update.authw', '更新功能菜单数据', 'id:long;\nsort:long;\nicon:String;\n', '{\"id\":0,\"moduleId\":0,\"title\":null,\"sort\":0,\"icon\":null,\"routeName\":null,\"routePath\":null,\"authClazz\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000108, '/rechargeProductCount/data.auth', '请求充值商品项目统计数据', 'startTime:int;\nendTime:int;\nserverUids:List;\n', '{\"count\":0,\"data\":[{\"productId\":0,\"productName\":null,\"playerCount\":0,\"buyCount\":0,\"totalPay\":0,\"rate\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2025-02-27 10:13:48', 100000109, '/userlog/data.auth', '请求用户操作日志', 'userName:String;\nstartTime:int;\nendTime:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"userId\":0,\"userName\":null,\"requestUrl\":null,\"param\":null,\"time\":{\"date\":{\"year\":2025,\"month\":2,\"day\":27},\"time\":{\"hour\":10,\"minute\":13,\"second\":48,\"nano\":305000000}},\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000110, '/playerRemain/data.auth', '请求玩家留存数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\n', '{\"count\":0,\"data\":[{\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"bornDate\":null,\"dayBase\":0,\"day0\":0,\"day1\":0,\"day2\":0,\"day3\":0,\"day4\":0,\"day5\":0,\"day6\":0,\"day7\":0,\"day8\":0,\"day9\":0,\"day10\":0,\"day11\":0,\"day12\":0,\"day13\":0,\"day14\":0,\"day30\":0,\"day60\":0,\"day90\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000111, '/playerRemain/manual.auth', '手动触发昨天留存数据统计', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000112, '/clientLog/data.auth', '请求客户端日志数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"level\":null,\"title\":null,\"content\":null,\"playerId\":null,\"name\":null,\"data\":null,\"send\":false,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000113, '/api/clientLog', '记录客户端日志，给游戏客户端请求用的', 'level:String;\ntitle:String;\ncontent:String;\nplayerId:String;\nname:String;\ndata:String;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000114, '/playerTimeLog/data.auth', '获取注册分时统计数据', 'time:int;\nserverUids:List;\n', '{\"count\":0,\"data\":[{\"timePeriod\":null,\"minOnline\":0,\"maxOnline\":0,\"createNum\":0,\"loginNum\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000115, '/gamePlatform/data.auth', '请求平台数据', 'page:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000116, '/gamePlatform/options.do', '请求平台下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000117, '/gamePlatform/save.authw', '保存平台数据，数据ID小于等于0时插入数据，大于0时更新对应数据', 'id:long;\nname:String;\n', '{\"id\":0,\"name\":null,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000118, '/api/yile/recharge', '提供给益乐的充值回调接口', 'game_id:String;\nuid:String;\namount:String;\norder_id:String;\ncp_order_id:String;\nrole_id:String;\nserver_id:String;\next:String;\ntime:String;\nsign:String;\n', '\"\"');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000119, '/api/yile/checkLogin', '提供给游戏客户端验证益乐登录数据的接口', 'uid:String;\ntoken:String;\nloginTime:String;\n', '{\"code\":0,\"message\":null,\"data\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000120, '/login.gate', '请求登录系统', 'username:String;\npassword:String;\n', '{\"token\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000121, '/menu.do', '获取用户可用菜单', '', '{\"username\":null,\"systemMenus\":[{\"children\":[],\"name\":null,\"path\":null,\"meta\":null,\"component\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000122, '/changePasssword.do', '修改密码', 'oldPassword:String;\nnewPassword:String;\nconfirmPassword:String;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000123, '/playerCurrOnline/forbid.auth', '请求封禁玩家', 'playerId:long;\nforbidEndTime:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000124, '/playerCurrOnline/data.auth', '请求当前在线玩家', 'serverUid:long;\n', '{\"count\":0,\"data\":[{\"id\":0,\"nick\":null,\"level\":0,\"diamond\":0,\"gold\":0,\"lastLoginTime\":null,\"dailyOnline\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000125, '/playerCurrOnline/forcedOffLine.auth', '踢玩家下线', 'playerId:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000126, '/gameChannelServer/data.auth', '请求渠道与服务器关系数据', 'channelId:long;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"channelName\":null,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"regionId\":0,\"regionName\":null,\"userId\":0,\"userName\":null,\"recommend\":false,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000127, '/gameChannelServer/saveToRegion.authw', '编辑服务器归属大区', 'channelId:long;\nserverUid:long;\nregionId:long;\n', '{\"id\":0,\"channelId\":0,\"channelName\":null,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"regionId\":0,\"regionName\":null,\"userId\":0,\"userName\":null,\"recommend\":false,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000128, '/gameChannelServer/currRelation.auth', '请求渠道下当前的服务器', 'channelId:long;\n', '{\"datas\":[{\"id\":0,\"text\":null,\"select\":false}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000129, '/gameChannelServer/save.authw', '保存渠道与服务器关系数据', 'channelId:long;\nserverUids:List;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000130, '/recruitDotData/data.auth', '招募打点数据', 'serverUid:int;\nstartTime:int;\nendTime:int;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"dateStr\":null,\"num0to10\":0,\"num11to20\":0,\"num21toMax\":0,\"joinNum\":0,\"createNum\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000131, '/giftCodeCfg/data.auth', '请求游戏兑换码礼包配置数据', 'openId:String;\nname:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"name\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000132, '/giftCodeCfg/options.do', '游戏兑换码礼包配置下拉菜单数据', '', '{\"options\":[{\"value\":0,\"text\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000133, '/giftCodeCfg/refresh.auth', '更新游戏兑换码礼包配置数据', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000134, '/forbidList/send.auth', '发送封禁账号到渠道下各游戏服', '', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000135, '/forbidList/data.auth', '请求封禁账号数据', 'openId:String;\npage:int;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"id\":0,\"channelId\":0,\"openId\":null,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000136, '/forbidList/add.authw', '添加封禁账号', 'openId:String;\n', '{\"id\":0,\"channelId\":0,\"openId\":null,\"userId\":0,\"userName\":null,\"insertTime\":null,\"updateTime\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000137, '/forbidList/delete.authw', '删除封禁账号', 'id:long;\n', '');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000138, '/playerOnlineLog/data.auth', '获取在线人数数据', 'time:int;\nserverUids:List;\n', '{\"count\":0,\"data\":[{\"period\":0,\"periodText\":null,\"onlineNum\":0,\"newOnlineNum\":0}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000139, '/fogDotData/data.auth', '引导打点数据', 'serverUid:int;\n', '{\"count\":0,\"data\":[{\"fogId\":0,\"minFighting\":0,\"num\":0,\"canNum\":0,\"rate\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000140, '/api/wabo/recharge', '提供给wabo的充值回调接口', ':String;\n:String;\n:String;\nev:String;\ngameId:String;\npn:String;\nsystem:String;\ngameAccountId:String;\ngameOrderId:String;\ncpOrderId:String;\nextraInfo:String;\nitemId:String;\nitemDoublePrice:String;\nitemCurrency:String;\ntransactionId:String;\npayTime:String;\npayTimeStr:String;\ntimestamp:String;\n', '\"\"');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000141, '/api/wabo/checkLogin', '提供给游戏客户端验证益乐登录数据的接口', 'token:String;\n', '{\"code\":0,\"message\":null,\"data\":null}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000142, '/rechargeRank/data.auth', '请求充值排名数据', 'startTime:int;\nendTime:int;\nserverUids:List;\nlimit:int;\n', '{\"count\":0,\"data\":[{\"channelId\":0,\"channelName\":null,\"serverUid\":0,\"serverId\":0,\"serverName\":null,\"playerId\":0,\"nick\":null,\"level\":0,\"fighting\":0,\"diamond\":0,\"gold\":0,\"money\":0,\"lastLoginTime\":null,\"bornTime\":null,\"lastRechargeTime\":null}]}');
INSERT INTO `api_doc` (`insert_time`, `update_time`, `id`, `href_url`, `comment`, `param_form`, `return_form`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 100000143, '/bossDotData/data.auth', '引导打点数据', 'serverUid:int;\n', '{\"count\":0,\"data\":[{\"bossId\":0,\"bossName\":null,\"level\":0,\"canChallengeNum\":0,\"challengeNum\":0,\"playerNum\":0,\"killNum\":0,\"minFighting\":0,\"killRate\":null}]}');
COMMIT;

-- ----------------------------
-- Table structure for bulletin
-- ----------------------------
DROP TABLE IF EXISTS `bulletin`;
CREATE TABLE `bulletin` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `title` varchar(255) DEFAULT '' COMMENT '公告标题',
  `content` text COMMENT '公告内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏公告表';

-- ----------------------------
-- Records of bulletin
-- ----------------------------
BEGIN;
INSERT INTO `bulletin` (`insert_time`, `update_time`, `id`, `title`, `content`) VALUES ('2024-11-22 10:14:31', '2024-11-22 11:09:55', 2, '测试公告', '测试公告1\r\n测试公告1\r\n测试公告1\r\n测试公告1');
COMMIT;

-- ----------------------------
-- Table structure for client_log
-- ----------------------------
DROP TABLE IF EXISTS `client_log`;
CREATE TABLE `client_log` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `level` varchar(255) DEFAULT '' COMMENT '日志级别',
  `title` varchar(255) DEFAULT '' COMMENT '标题、类别',
  `content` text COMMENT '日志信息',
  `player_id` varchar(255) DEFAULT '' COMMENT '玩家ID',
  `name` varchar(255) DEFAULT '' COMMENT '玩家名称',
  `data` text COMMENT '日志内容',
  `send` char(5) DEFAULT 'false' COMMENT '是否已发送给管理员',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='客户端日志';

-- ----------------------------
-- Records of client_log
-- ----------------------------
BEGIN;
INSERT INTO `client_log` (`insert_time`, `update_time`, `id`, `level`, `title`, `content`, `player_id`, `name`, `data`, `send`) VALUES ('2024-11-21 19:57:56', '2024-11-21 19:57:56', 2, 'error', '报错', '{\"message\":\"Uncaught TypeError: Cannot read properties of undefined (reading \'0\')\",\"url\":\"http://localhost:7779/\",\"line\":303,\"column\":47,\"errorObj\":{}}', 'undefined', 'undefined', '{message:Cannot read properties of undefined (reading \'0\'),stack:TypeError: Cannot read properties of undefined (reading \'0\')\n    at Loading.updateShowServer (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:303:47)\n    at Loading.onResponseServerList (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:207:14)\n    at xhr.onreadystatechange (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:174:23),channelId:undefined}', 'false');
INSERT INTO `client_log` (`insert_time`, `update_time`, `id`, `level`, `title`, `content`, `player_id`, `name`, `data`, `send`) VALUES ('2024-11-21 19:58:03', '2024-11-21 19:58:03', 3, 'error', '报错', '{\"message\":\"Uncaught TypeError: Cannot read properties of undefined (reading \'0\')\",\"url\":\"\",\"line\":303,\"column\":47,\"errorObj\":{}}', 'undefined', 'undefined', '{message:Cannot read properties of undefined (reading \'0\'),stack:TypeError: Cannot read properties of undefined (reading \'0\')\n    at Loading.updateShowServer (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:303:47)\n    at Loading.onResponseServerList (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:207:14)\n    at xhr.onreadystatechange (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:174:23)\n    at XMLHttpRequest.s (http://localhost:7779/app/node_modules/vconsole/dist/vconsole.min.js:11:27891),channelId:undefined}', 'false');
INSERT INTO `client_log` (`insert_time`, `update_time`, `id`, `level`, `title`, `content`, `player_id`, `name`, `data`, `send`) VALUES ('2024-11-21 19:58:26', '2024-11-21 19:58:26', 4, 'error', '报错', '{\"message\":\"Uncaught TypeError: Cannot read properties of undefined (reading \'0\')\",\"url\":\"\",\"line\":303,\"column\":47,\"errorObj\":{}}', 'undefined', 'undefined', '{message:Cannot read properties of undefined (reading \'0\'),stack:TypeError: Cannot read properties of undefined (reading \'0\')\n    at Loading.updateShowServer (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:303:47)\n    at Loading.onResponseServerList (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:207:14)\n    at xhr.onreadystatechange (eval at <anonymous> (http://localhost:7779/preview-scripts/__quick_compile__.js:238:32), <anonymous>:174:23)\n    at XMLHttpRequest.s (http://localhost:7779/app/node_modules/vconsole/dist/vconsole.min.js:11:27891),channelId:undefined}', 'false');
COMMIT;

-- ----------------------------
-- Table structure for client_version
-- ----------------------------
DROP TABLE IF EXISTS `client_version`;
CREATE TABLE `client_version` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `version_code` int(11) DEFAULT '0' COMMENT '版本编号',
  `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试，2审核，3正式',
  `remote_url` varchar(255) DEFAULT '' COMMENT '远程地址',
  `resource_version` varchar(255) DEFAULT '' COMMENT '客户端资源版本号',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `pc_resource_version` varchar(255) DEFAULT '' COMMENT 'PC客户端资源版本号',
  `quick_url` varchar(255) DEFAULT '' COMMENT '快速通道地址',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channel_version` (`channel_id`,`version_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='客户端版本控制';

-- ----------------------------
-- Records of client_version
-- ----------------------------
BEGIN;
INSERT INTO `client_version` (`insert_time`, `update_time`, `id`, `channel_id`, `channel_name`, `version_code`, `server_type`, `remote_url`, `resource_version`, `remark`, `pc_resource_version`, `quick_url`) VALUES ('2024-11-22 11:09:14', '2024-11-22 11:09:14', 100000002, 2, '测试渠道', 10004, 1, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for dot_data_login_statistic
-- ----------------------------
DROP TABLE IF EXISTS `dot_data_login_statistic`;
CREATE TABLE `dot_data_login_statistic` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `date_str` varchar(255) DEFAULT '' COMMENT '日期字符串，yyyyMMdd',
  `req_res_url_begin` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径',
  `req_res_url_sucess` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径成功',
  `req_res_url_fail` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径成功',
  `sdk_login_begin` int(11) DEFAULT '0' COMMENT 'SDK开始登陆',
  `sdk_login_sucess` int(11) DEFAULT '0' COMMENT 'SDK的登录成功',
  `sdk_login_fail` int(11) DEFAULT '0' COMMENT 'SDK的登录失败',
  `req_server_verify_begin` int(11) DEFAULT '0' COMMENT '请求服务器账号验证',
  `req_server_verify_sucess` int(11) DEFAULT '0' COMMENT '请求服务器账号验证成功',
  `req_server_verify_fail` int(11) DEFAULT '0' COMMENT '请求服务器账号验证失败',
  `req_server_list_begin` int(11) DEFAULT '0' COMMENT '请求服务器列表',
  `req_server_list_sucess` int(11) DEFAULT '0' COMMENT '请求服务器列表成功',
  `req_server_list_fail` int(11) DEFAULT '0' COMMENT '请求服务器列表失败',
  `start_game` int(11) DEFAULT '0' COMMENT '点击开始游戏',
  `req_socket_connect_sucess` int(11) DEFAULT '0' COMMENT '向服务器socket连接成功',
  `req_socket_login_begin` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议',
  `req_socket_login_sucess` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议成功',
  `req_socket_login_fail` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议失败',
  `create_succ` int(11) DEFAULT '0' COMMENT '创号成功',
  `req_server_push_data_end` int(11) DEFAULT '0' COMMENT '服务器推送数据结束',
  `in_game` int(11) DEFAULT '0' COMMENT '进入游戏',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_datastr` (`channel_id`,`date_str`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='登录打点数据统计';

-- ----------------------------
-- Records of dot_data_login_statistic
-- ----------------------------
BEGIN;
INSERT INTO `dot_data_login_statistic` (`insert_time`, `update_time`, `id`, `channel_id`, `date_str`, `req_res_url_begin`, `req_res_url_sucess`, `req_res_url_fail`, `sdk_login_begin`, `sdk_login_sucess`, `sdk_login_fail`, `req_server_verify_begin`, `req_server_verify_sucess`, `req_server_verify_fail`, `req_server_list_begin`, `req_server_list_sucess`, `req_server_list_fail`, `start_game`, `req_socket_connect_sucess`, `req_socket_login_begin`, `req_socket_login_sucess`, `req_socket_login_fail`, `create_succ`, `req_server_push_data_end`, `in_game`) VALUES ('2024-11-22 11:17:37', '2024-11-22 16:53:45', 100000001, 1, '20241122', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0);
INSERT INTO `dot_data_login_statistic` (`insert_time`, `update_time`, `id`, `channel_id`, `date_str`, `req_res_url_begin`, `req_res_url_sucess`, `req_res_url_fail`, `sdk_login_begin`, `sdk_login_sucess`, `sdk_login_fail`, `req_server_verify_begin`, `req_server_verify_sucess`, `req_server_verify_fail`, `req_server_list_begin`, `req_server_list_sucess`, `req_server_list_fail`, `start_game`, `req_socket_connect_sucess`, `req_socket_login_begin`, `req_socket_login_sucess`, `req_socket_login_fail`, `create_succ`, `req_server_push_data_end`, `in_game`) VALUES ('2024-11-22 13:14:08', '2024-11-22 16:53:45', 100000002, 2, '20241122', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for dot_data_task_statistic
-- ----------------------------
DROP TABLE IF EXISTS `dot_data_task_statistic`;
CREATE TABLE `dot_data_task_statistic` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器ID',
  `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
  `task_name` varchar(255) DEFAULT '' COMMENT '任务名称',
  `start_num` int(11) DEFAULT '0' COMMENT '接取人数',
  `finish_num` int(11) DEFAULT '0' COMMENT '完成人数',
  PRIMARY KEY (`id`),
  KEY `channel_id` (`channel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='任务打点数据统计';

-- ----------------------------
-- Records of dot_data_task_statistic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fix_code
-- ----------------------------
DROP TABLE IF EXISTS `fix_code`;
CREATE TABLE `fix_code` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `server_uids` varchar(255) DEFAULT '' COMMENT '热更的服务器唯一ID集合',
  `file_names` text COMMENT '配置文件相对路径',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  `fix_time` varchar(255) DEFAULT '' COMMENT '热更时间批号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更代码记录表';

-- ----------------------------
-- Records of fix_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fix_code_result
-- ----------------------------
DROP TABLE IF EXISTS `fix_code_result`;
CREATE TABLE `fix_code_result` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `fix_id` bigint(20) DEFAULT '0' COMMENT '修正记录ID',
  `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
  `code` int(11) DEFAULT '0' COMMENT '服务器响应码',
  `message` varchar(255) DEFAULT '' COMMENT '服务器响应消息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更代码结果记录表';

-- ----------------------------
-- Records of fix_code_result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fix_design
-- ----------------------------
DROP TABLE IF EXISTS `fix_design`;
CREATE TABLE `fix_design` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `server_uids` varchar(255) DEFAULT '' COMMENT '热更的服务器唯一ID集合',
  `file_names` text COMMENT '配置文件相对路径',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  `fix_time` varchar(255) DEFAULT '' COMMENT '热更时间批号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更配置记录表';

-- ----------------------------
-- Records of fix_design
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fix_design_result
-- ----------------------------
DROP TABLE IF EXISTS `fix_design_result`;
CREATE TABLE `fix_design_result` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `fix_id` bigint(20) DEFAULT '0' COMMENT '修正记录ID',
  `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
  `code` int(11) DEFAULT '0' COMMENT '服务器响应码',
  `message` varchar(255) DEFAULT '' COMMENT '服务器响应消息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更配置结果记录表';

-- ----------------------------
-- Records of fix_design_result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for forbid_list
-- ----------------------------
DROP TABLE IF EXISTS `forbid_list`;
CREATE TABLE `forbid_list` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '唯一ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作人ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作人名字',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='封禁账号表';

-- ----------------------------
-- Records of forbid_list
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fushun_setting
-- ----------------------------
DROP TABLE IF EXISTS `fushun_setting`;
CREATE TABLE `fushun_setting` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '数据ID',
  `game_id` varchar(255) DEFAULT '' COMMENT '渠道参数游戏ID',
  `game_key` varchar(255) DEFAULT '' COMMENT '游戏密钥',
  `login_url` varchar(255) DEFAULT '' COMMENT '验证登录URL',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='福顺参数设置';

-- ----------------------------
-- Records of fushun_setting
-- ----------------------------
BEGIN;
INSERT INTO `fushun_setting` (`insert_time`, `update_time`, `id`, `game_id`, `game_key`, `login_url`) VALUES ('2024-11-21 18:09:32', '2024-11-21 18:09:32', 1, '30128', 'da371d609efdf1bf9c7e9d8fff364af9', 'https://api.hnmaiji.com/server/code/');
COMMIT;

-- ----------------------------
-- Table structure for game_cause
-- ----------------------------
DROP TABLE IF EXISTS `game_cause`;
CREATE TABLE `game_cause` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '事件ID',
  `name` varchar(255) DEFAULT '' COMMENT '事件名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏流水事件表';

-- ----------------------------
-- Records of game_cause
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for game_channel
-- ----------------------------
DROP TABLE IF EXISTS `game_channel`;
CREATE TABLE `game_channel` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '渠道ID',
  `name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `platform_id` bigint(20) DEFAULT '0' COMMENT '归属平台ID',
  `platform_name` varchar(255) DEFAULT '' COMMENT '归属平台名称',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  `bulletin_id` bigint(20) DEFAULT '0' COMMENT '公告ID',
  `program_version` varchar(255) DEFAULT '' COMMENT '客户端程序版本号',
  `resource_version` varchar(255) DEFAULT '' COMMENT '客户端资源版本号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏渠道表';

-- ----------------------------
-- Records of game_channel
-- ----------------------------
BEGIN;
INSERT INTO `game_channel` (`insert_time`, `update_time`, `id`, `name`, `platform_id`, `platform_name`, `user_id`, `user_name`, `bulletin_id`, `program_version`, `resource_version`) VALUES ('2024-11-22 10:03:59', '2024-11-22 11:20:26', 2, '测试渠道', 1001, '测试平台', 1, 'zx', 2, '', '');
COMMIT;

-- ----------------------------
-- Table structure for game_channel_server
-- ----------------------------
DROP TABLE IF EXISTS `game_channel_server`;
CREATE TABLE `game_channel_server` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `region_id` int(11) DEFAULT '0' COMMENT '所属大区ID',
  `region_name` varchar(255) DEFAULT '' COMMENT '所属大区名称',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  `recommend` char(5) DEFAULT 'false' COMMENT '是否为推荐服务器',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_serverid` (`channel_id`,`server_id`) USING BTREE,
  KEY `channelid` (`channel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏渠道与服务器关系表';

-- ----------------------------
-- Records of game_channel_server
-- ----------------------------
BEGIN;
INSERT INTO `game_channel_server` (`insert_time`, `update_time`, `id`, `channel_id`, `channel_name`, `server_uid`, `server_id`, `server_name`, `region_id`, `region_name`, `user_id`, `user_name`, `recommend`) VALUES ('2024-11-22 10:13:06', '2024-11-22 11:12:33', 2, 2, '测试渠道', 10001, 1, 'S1', 1, '测试大区1', 1, 'zx', 'true');
COMMIT;

-- ----------------------------
-- Table structure for game_db
-- ----------------------------
DROP TABLE IF EXISTS `game_db`;
CREATE TABLE `game_db` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `db_name` varchar(255) NOT NULL COMMENT '数据库名字，唯一ID',
  `platform_id` int(11) DEFAULT '0' COMMENT '平台ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `type` varchar(255) DEFAULT '' COMMENT '服务器类型',
  `zone_id` int(11) DEFAULT '0' COMMENT '在服务器里面用的一个ID，基本是1',
  `alias` varchar(255) DEFAULT '' COMMENT '别名',
  `ip_port` varchar(255) DEFAULT '' COMMENT 'IP与端口，填内网IP与端口',
  `user` varchar(255) DEFAULT '' COMMENT '数据库用户',
  `password` varchar(255) DEFAULT '' COMMENT '数据库密码',
  `min_idle` int(11) DEFAULT '0' COMMENT '最少空闲连接数',
  `max_active` int(11) DEFAULT '0' COMMENT '最大活跃连接数',
  `max_wait_millis` int(11) DEFAULT '0' COMMENT '最大等级时间',
  PRIMARY KEY (`db_name`),
  UNIQUE KEY `db_name` (`db_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏数据库管理表';

-- ----------------------------
-- Records of game_db
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for game_platform
-- ----------------------------
DROP TABLE IF EXISTS `game_platform`;
CREATE TABLE `game_platform` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '平台ID',
  `name` varchar(255) DEFAULT '' COMMENT '平台名称',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1002 DEFAULT CHARSET=utf8mb4 COMMENT='游戏平台表';

-- ----------------------------
-- Records of game_platform
-- ----------------------------
BEGIN;
INSERT INTO `game_platform` (`insert_time`, `update_time`, `id`, `name`, `user_id`, `user_name`) VALUES ('2024-11-22 10:02:45', '2024-11-22 10:02:45', 1001, '测试平台', 1, 'zx');
COMMIT;

-- ----------------------------
-- Table structure for game_region
-- ----------------------------
DROP TABLE IF EXISTS `game_region`;
CREATE TABLE `game_region` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `region_id` int(11) DEFAULT '0' COMMENT '大区ID',
  `name` varchar(255) DEFAULT '' COMMENT '大区名称',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试服，2审核服，3正式服',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_regionid` (`channel_id`,`region_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏大区表';

-- ----------------------------
-- Records of game_region
-- ----------------------------
BEGIN;
INSERT INTO `game_region` (`insert_time`, `update_time`, `id`, `region_id`, `name`, `channel_id`, `channel_name`, `server_type`) VALUES ('2024-11-22 10:11:06', '2024-11-22 10:11:06', 2, 1, '测试大区1', 2, '测试渠道', 1);
COMMIT;

-- ----------------------------
-- Table structure for game_server
-- ----------------------------
DROP TABLE IF EXISTS `game_server`;
CREATE TABLE `game_server` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `platform_id` bigint(20) DEFAULT '0' COMMENT '归属平台ID',
  `platform_name` varchar(255) DEFAULT '' COMMENT '归属平台名称',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试服，2审核服，3正式服',
  `socket_type` varchar(255) DEFAULT '' COMMENT 'socket连接方式',
  `external_ip` varchar(255) DEFAULT '' COMMENT '外网IP',
  `internal_ip` varchar(255) DEFAULT '' COMMENT '内网IP',
  `tcp_port` int(11) DEFAULT '0' COMMENT 'tcp/ws端口',
  `http_port` int(11) DEFAULT '0' COMMENT 'http端口',
  `db_game_name` varchar(255) DEFAULT '' COMMENT '游戏数据库名',
  `db_log_name` varchar(255) DEFAULT '' COMMENT '日志数据库名',
  `status` int(11) DEFAULT '0' COMMENT '状态，0维护，1流畅，2爆满，3新服',
  `recommend` char(5) DEFAULT 'false' COMMENT '是否为推荐服务器',
  `open_time` datetime DEFAULT NULL COMMENT '预期开服时间',
  `real_open_time` datetime DEFAULT NULL COMMENT '实际开服时间',
  `send_open_status` int(11) DEFAULT '0' COMMENT '开服时间是否发送成功，0未发送，1成功，2失败',
  `maintain` char(5) DEFAULT 'false' COMMENT '服务器是否维护中',
  `maintain_response` char(5) DEFAULT 'false' COMMENT '服务器维护消息是否发送成功',
  `merge` char(5) DEFAULT 'false' COMMENT '服务器是否已被合服',
  `hide` char(5) DEFAULT 'false' COMMENT '是否隐藏入口',
  PRIMARY KEY (`id`),
  UNIQUE KEY `platformid_serverid` (`platform_id`,`server_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8mb4 COMMENT='游戏服务器表';

-- ----------------------------
-- Records of game_server
-- ----------------------------
BEGIN;
INSERT INTO `game_server` (`insert_time`, `update_time`, `id`, `platform_id`, `platform_name`, `server_id`, `name`, `server_type`, `socket_type`, `external_ip`, `internal_ip`, `tcp_port`, `http_port`, `db_game_name`, `db_log_name`, `status`, `recommend`, `open_time`, `real_open_time`, `send_open_status`, `maintain`, `maintain_response`, `merge`, `hide`) VALUES ('2024-11-22 10:08:45', '2024-11-22 11:19:26', 10001, 1001, '测试平台', 1, 'S1', 1, 'ws', '192.168.3.247', '192.168.3.247', 10004, 20004, 'x1_1_game', 'x1_1_log', 1, 'true', '2099-12-31 23:59:00', '2024-11-22 11:10:19', 2, 'false', 'true', 'false', 'false');
COMMIT;

-- ----------------------------
-- Table structure for game_server_runtime
-- ----------------------------
DROP TABLE IF EXISTS `game_server_runtime`;
CREATE TABLE `game_server_runtime` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `server_uid` int(11) NOT NULL COMMENT '服务器唯一ID',
  `register_num` int(11) DEFAULT '0' COMMENT '注册数',
  `create_num` int(11) DEFAULT '0' COMMENT '创角数',
  `online_num` int(11) DEFAULT '0' COMMENT '在线数',
  `battle_num` int(11) DEFAULT '0' COMMENT '战斗数',
  `curr_battle_num` int(11) DEFAULT '0' COMMENT '当前战斗数',
  `running` char(5) DEFAULT 'false' COMMENT '服务器是否正常运行',
  `heart_time` datetime DEFAULT NULL COMMENT '最后心跳时间',
  `max_memory` varchar(255) DEFAULT '' COMMENT '最大可用内存',
  `free_memory` varchar(255) DEFAULT '' COMMENT '空闲内存',
  `total_memory` varchar(255) DEFAULT '' COMMENT '占用内存（占用内存=空闲内存+实际使用内存）',
  `used_memory` varchar(255) DEFAULT '' COMMENT '实际使用内存',
  `left_memory` varchar(255) DEFAULT '' COMMENT '剩余可用内存（剩余可用内存=最大可用内存-实际使用内存）',
  PRIMARY KEY (`server_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏服务器运行数据表';

-- ----------------------------
-- Records of game_server_runtime
-- ----------------------------
BEGIN;
INSERT INTO `game_server_runtime` (`insert_time`, `update_time`, `server_uid`, `register_num`, `create_num`, `online_num`, `battle_num`, `curr_battle_num`, `running`, `heart_time`, `max_memory`, `free_memory`, `total_memory`, `used_memory`, `left_memory`) VALUES ('2024-11-22 10:09:04', '2025-02-28 11:02:03', 10001, 2, 2, 0, 0, 0, 'true', '2025-02-28 11:02:03', '3.56G', '252.31M', '457.00M', '204.69M', '3.36G');
COMMIT;

-- ----------------------------
-- Table structure for gift_code
-- ----------------------------
DROP TABLE IF EXISTS `gift_code`;
CREATE TABLE `gift_code` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `code` varchar(255) DEFAULT '' COMMENT '礼包码',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '所属渠道ID',
  `type` int(11) DEFAULT '0' COMMENT '礼包码类型，1通码，2独享码',
  `config_id` int(11) DEFAULT '0' COMMENT '配置礼包ID',
  `config_name` varchar(255) DEFAULT '' COMMENT '配置礼包名称',
  `user_id` bigint(20) DEFAULT '0' COMMENT '创建的用户ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '创建的用户名称',
  `player_id` bigint(20) DEFAULT '0' COMMENT '使用码的玩家ID',
  `player_name` varchar(255) DEFAULT '' COMMENT '使用码的玩家名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='礼包码表';

-- ----------------------------
-- Records of gift_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gift_code_cfg
-- ----------------------------
DROP TABLE IF EXISTS `gift_code_cfg`;
CREATE TABLE `gift_code_cfg` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` int(11) NOT NULL COMMENT '礼包ID',
  `name` varchar(255) DEFAULT '' COMMENT '礼包名字',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='兑换码礼包配置';

-- ----------------------------
-- Records of gift_code_cfg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for gift_code_share_log
-- ----------------------------
DROP TABLE IF EXISTS `gift_code_share_log`;
CREATE TABLE `gift_code_share_log` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `code` varchar(255) DEFAULT '' COMMENT '礼包码',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `player_name` varchar(255) DEFAULT '' COMMENT '玩家名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='共享礼包码使用情况表';

-- ----------------------------
-- Records of gift_code_share_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for god_finger
-- ----------------------------
DROP TABLE IF EXISTS `god_finger`;
CREATE TABLE `god_finger` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
  `nick` varchar(255) DEFAULT '' COMMENT '玩家昵称',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `money` bigint(20) DEFAULT '0' COMMENT '每日金额',
  `user_id` bigint(20) DEFAULT '0' COMMENT '添加金手指的用户',
  `user_name` varchar(255) DEFAULT '' COMMENT '添加金手指的用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='金手指表';

-- ----------------------------
-- Records of god_finger
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for item_cfg
-- ----------------------------
DROP TABLE IF EXISTS `item_cfg`;
CREATE TABLE `item_cfg` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` int(11) NOT NULL COMMENT '道具ID',
  `name` varchar(255) DEFAULT '' COMMENT '道具名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='道具配置';

-- ----------------------------
-- Records of item_cfg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mail_setting
-- ----------------------------
DROP TABLE IF EXISTS `mail_setting`;
CREATE TABLE `mail_setting` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `protocol` varchar(255) DEFAULT '' COMMENT '邮件协议',
  `host` varchar(255) DEFAULT '' COMMENT '邮箱系统服务器地址',
  `port` int(11) DEFAULT '0' COMMENT '端口',
  `account` varchar(255) DEFAULT '' COMMENT '发件人邮箱地址',
  `auth_code` varchar(255) DEFAULT '' COMMENT '发件人邮箱授权码',
  `client_master_mail` varchar(255) DEFAULT '' COMMENT '客户端管理员邮箱地址',
  `server_master_mail` varchar(255) DEFAULT '' COMMENT '服务端管理员邮箱地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='后台邮箱发送配置';

-- ----------------------------
-- Records of mail_setting
-- ----------------------------
BEGIN;
INSERT INTO `mail_setting` (`insert_time`, `update_time`, `id`, `protocol`, `host`, `port`, `account`, `auth_code`, `client_master_mail`, `server_master_mail`) VALUES ('2024-11-21 18:09:32', '2024-11-21 18:09:32', 1, 'smtp', 'smtp.qq.com', 465, '3462921572@qq.com', 'kefizuhspramdbae', '89662961@qq.com', '89662961@qq.com');
COMMIT;

-- ----------------------------
-- Table structure for mail_system
-- ----------------------------
DROP TABLE IF EXISTS `mail_system`;
CREATE TABLE `mail_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '创建邮件的用户',
  `user_name` varchar(255) DEFAULT '' COMMENT '创建邮件的用户',
  `title` varchar(255) DEFAULT '' COMMENT '标题',
  `content` text COMMENT '内容',
  `rewards` varchar(5000) DEFAULT '' COMMENT '奖励',
  `type` int(11) DEFAULT '0' COMMENT '邮件类型，1全服邮件，2玩家邮件',
  `server_uids` text COMMENT '服务器唯一ID集合',
  `send_server_uids` text COMMENT '已发送的服务器唯一ID集合',
  `delete_server_uids` text COMMENT '已发送删除的服务器唯一ID集合',
  `pids` text COMMENT '玩家ID集合，分号分隔',
  `player_level` int(11) DEFAULT '0' COMMENT '收到邮件的玩家等级限制',
  `status` int(11) DEFAULT '0' COMMENT '邮件审核状态，0未审核，1审核通过，2审核不通过，3通知删除',
  `check_user_id` bigint(20) DEFAULT '0' COMMENT '审核用户ID',
  `check_user_name` varchar(255) DEFAULT '' COMMENT '审核用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件表';

-- ----------------------------
-- Records of mail_system
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mail_system_result
-- ----------------------------
DROP TABLE IF EXISTS `mail_system_result`;
CREATE TABLE `mail_system_result` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `mail_id` bigint(20) DEFAULT '0' COMMENT '系统邮件ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器名字',
  `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `type_text` varchar(255) DEFAULT '' COMMENT '结果类型',
  `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
  `message` varchar(255) DEFAULT '' COMMENT '处理信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件发送回执表';

-- ----------------------------
-- Records of mail_system_result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for menu1_system
-- ----------------------------
DROP TABLE IF EXISTS `menu1_system`;
CREATE TABLE `menu1_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `title` varchar(255) DEFAULT '' COMMENT '系统名字',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
  `icon` varchar(255) DEFAULT '' COMMENT '图标',
  `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
  `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
  `component` varchar(255) DEFAULT '' COMMENT '组件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单，系统菜单>模块菜单>功能菜单';

-- ----------------------------
-- Records of menu1_system
-- ----------------------------
BEGIN;
INSERT INTO `menu1_system` (`insert_time`, `update_time`, `id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 1, '系统设置', 1, '', 'systemSettings', '/systemSettings', 'Layout');
INSERT INTO `menu1_system` (`insert_time`, `update_time`, `id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 2, '游戏管理', 2, '', 'gameSettings', '/gameSettings', 'Layout');
COMMIT;

-- ----------------------------
-- Table structure for menu2_module
-- ----------------------------
DROP TABLE IF EXISTS `menu2_module`;
CREATE TABLE `menu2_module` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `system_id` bigint(20) DEFAULT '0' COMMENT '所属的系统菜单ID',
  `title` varchar(255) DEFAULT '' COMMENT '模块名字',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
  `icon` varchar(255) DEFAULT '' COMMENT '图标',
  `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
  `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
  `component` varchar(255) DEFAULT '' COMMENT '组件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='模块菜单，导航区的分类菜单';

-- ----------------------------
-- Records of menu2_module
-- ----------------------------
BEGIN;
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 1, 1, '菜单设置', 1, '', 'menuSettings', 'menuSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 2, 1, '用户设置', 2, '', 'userSettings', 'userSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 3, 1, '接口说明', 3, '', 'apiSettings', 'apiSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10001, 2, '服务器管理', 0, '', 'serverSettings', 'serverSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10002, 2, '玩家管理', 0, '', 'loginSettings', 'loginSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10003, 2, '游戏统计数据', 0, '', 'censusSettings', 'censusSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10004, 2, '邮件相关', 0, '', 'mailSettings', 'mailSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10005, 2, '玩家流水查询', 0, '', 'logSettings', 'logSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10006, 2, '特殊操作', 0, '', 'fixSettings', 'fixSettings', 'layout/secondaryLayout');
INSERT INTO `menu2_module` (`insert_time`, `update_time`, `id`, `system_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `component`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 10007, 2, '充值相关', 0, '', 'rechargeSettings', 'rechargeSettings', 'layout/secondaryLayout');
COMMIT;

-- ----------------------------
-- Table structure for menu3_function
-- ----------------------------
DROP TABLE IF EXISTS `menu3_function`;
CREATE TABLE `menu3_function` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `module_id` bigint(20) DEFAULT '0' COMMENT '所属的模块菜单ID',
  `title` varchar(255) DEFAULT '' COMMENT '功能名字',
  `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
  `icon` varchar(255) DEFAULT '' COMMENT '图标',
  `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
  `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
  `auth_clazz` varchar(255) DEFAULT '' COMMENT '权限验证归属类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000065 DEFAULT CHARSET=utf8mb4 COMMENT='功能菜单，具体的业务功能菜单';

-- ----------------------------
-- Records of menu3_function
-- ----------------------------
BEGIN;
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000001, 1, '系统菜单', 1, '', 'systemMenu', 'systemMenu', 'SystemMenuController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000002, 1, '模块菜单', 2, '', 'moduleMenu', 'moduleMenu', 'ModuleMenuController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000003, 1, '功能菜单', 3, '', 'functionMenu', 'functionMenu', 'FunctionMenuController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000004, 2, '用户管理', 1, '', 'user', 'user', 'UserController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000005, 2, '用户权限管理', 2, '', 'userFunction', 'userFunction', 'UserFunctionController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000006, 2, '用户操作日志', 3, '', 'userLog', 'userLog', 'UserLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000007, 3, '接口说明', 1, '', 'apidoc', 'apidoc', 'ApiDocController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:34', '2024-11-21 18:09:34', 100000008, 3, '空白主页', 1, '', 'home', 'home', 'ApiDocController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000009, 10001, '平台管理', 1, '', 'gamePlatform', 'gamePlatform', 'GamePlatformController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000010, 10001, '渠道管理', 2, '', 'gameChannel', 'gameChannel', 'GameChannelController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000011, 10001, '服务器管理', 3, '', 'gameServer', 'gameServer', 'GameServerController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000012, 10001, '渠道与服务器关系', 4, '', 'gameChannelServer', 'gameChannelServer', 'GameChannelServerController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000013, 10001, '渠道大区管理', 5, '', 'gameRegion', 'gameRegion', 'GameRegionController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000014, 10001, '开服管理', 6, '', 'serverOpen', 'serverOpen', 'ServerOpenController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000015, 10001, '渠道权限管理', 7, '', 'userChannel', 'userChannel', 'UserChannelController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000016, 10001, '游戏公告管理', 8, '', 'bulletin', 'bulletin', 'BulletinController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000017, 10001, '服务器维护管理', 9, '', 'gameServerMaintain', 'gameServerMaintain', 'GameServerMaintainController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000018, 10001, '客户端版本管理', 10, '', 'clientVersion', 'clientVersion', 'ClientVersionController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000019, 10002, '玩家信息管理', 1, '', 'player', 'player', 'PlayerController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000020, 10002, '白名单管理', 2, '', 'whiteList', 'whiteList', 'WhiteListController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000021, 10002, '金手指名单', 3, '', 'godFinger', 'godFinger', 'GodFingerController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000022, 10002, '封禁账号', 4, '', 'forbidList', 'forbidList', 'ForbidListController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000023, 10003, '注册分时', 1, '', 'playerTimeLog', 'playerTimeLog', 'PlayerTimeLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000024, 10003, '在线人数', 2, '', 'playerOnlineLog', 'playerOnlineLog', 'PlayerOnlineLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000025, 10003, '在线时长占比', 3, '', 'playerScatterLog', 'playerScatterLog', 'PlayerScatterLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000026, 10003, '玩家留存', 4, '', 'playerRemain', 'playerRemain', 'PlayerRemainController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000027, 10003, '付费留存', 5, '', 'playerPayRemain', 'playerPayRemain', 'PlayerPayRemainController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000028, 10003, '付费LTV', 6, '', 'playerLTV', 'playerLTV', 'PlayerLTVController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000029, 10003, '游戏汇总', 7, '', 'serverResume', 'serverResume', 'ServerResumeController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000030, 10003, '货币消费统计', 8, '', 'consume', 'consume', 'ConsumeController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000031, 10003, '登录数据打点', 9, '', 'loginDotData', 'loginDotData', 'LoginDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000032, 10003, '任务数据打点', 10, '', 'taskDotData', 'taskDotData', 'TaskDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000033, 10003, '引导数据打点', 11, '', 'guideDotData', 'guideDotData', 'GuideDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000034, 10003, '招募数据打点', 11, '', 'recruitDotData', 'recruitDotData', 'RecruitDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000035, 10003, '招募刷新数据打点', 12, '', 'recruitRefreshDotData', 'recruitRefreshDotData', 'RecruitRefreshDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000036, 10003, 'BOSS击杀数据打点', 13, '', 'bossDotData', 'bossDotData', 'BossDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:35', '2024-11-21 18:09:35', 100000037, 10003, '场景区域解锁数据打点', 14, '', 'fogDotData', 'fogDotData', 'FogDotDataController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000038, 10004, '系统邮件', 1, '', 'mailSystem', 'mailSystem', 'MailSystemController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000039, 10004, '玩家邮件', 2, '', 'playerMail', 'playerMail', 'PlayerMailController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000040, 10005, '钻石日志', 1, '', 'diamondLogs', 'diamondLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000041, 10005, '金币日志', 2, '', 'goldLogs', 'goldLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000042, 10005, '道具日志', 3, '', 'itemLogs', 'itemLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000043, 10005, '肉日志', 4, '', 'meatLogs', 'meatLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000044, 10005, '木日志', 5, '', 'woodLogs', 'woodLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000045, 10005, '矿日志', 6, '', 'mineLogs', 'mineLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000046, 10005, '英雄日志', 7, '', 'heroLogs', 'heroLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000047, 10005, '装备日志', 8, '', 'equipLogs', 'equipLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000048, 10005, '角色经验日志', 9, '', 'playerExpLogs', 'playerExpLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000049, 10005, '英雄战力日志', 10, '', 'heroFightingLogs', 'heroFightingLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000050, 10005, '已删邮件日志', 11, '', 'mailLogs', 'mailLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000051, 10005, '玩家战力日志', 12, '', 'playerFightingLogs', 'playerFightingLogs', 'GameLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000052, 10006, '热更配置', 1, '', 'fixDesign', 'fixDesign', 'FixDesignController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000053, 10006, '热更代码', 2, '', 'fixCode', 'fixCode', 'FixCodeController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000054, 10006, '流水事件', 3, '', 'gameCause', 'gameCause', 'GameCauseController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000055, 10006, '道具配置', 4, '', 'itemCfg', 'itemCfg', 'ItemCfgController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000056, 10006, '兑换码礼包配置', 5, '', 'giftCodeCfg', 'giftCodeCfg', 'GiftCodeCfgController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000057, 10006, '兑换码生成', 6, '', 'giftCode', 'giftCode', 'GiftCodeController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000058, 10006, '通用兑换码日志', 7, '', 'giftCodeShareLog', 'giftCodeShareLog', 'GiftCodeShareLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000059, 10006, '客户端日志', 8, '', 'clientLog', 'clientLog', 'ClientLogController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000060, 10006, '充值商品配置', 9, '', 'rechargeProductCfg', 'rechargeProductCfg', 'RechargeProductCfgController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000061, 10007, '充值回调查询', 1, '', 'recharge', 'recharge', 'RechargeCallbackController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000062, 10007, '充值排名', 2, '', 'rechargeRank', 'rechargeRank', 'RechargeRankController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000063, 10007, '充值项目统计', 3, '', 'rechargeProductCount', 'rechargeProductCount', 'RechargeProductCountController');
INSERT INTO `menu3_function` (`insert_time`, `update_time`, `id`, `module_id`, `title`, `sort`, `icon`, `route_name`, `route_path`, `auth_clazz`) VALUES ('2024-11-21 18:09:36', '2024-11-21 18:09:36', 100000064, 10007, '虚拟充值（内部充值）', 4, '', 'rechargeVirtual', 'rechargeVirtual', 'RechargeVirtualController');
COMMIT;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '玩家ID，全平台唯一',
  `platform_id` bigint(20) DEFAULT '0' COMMENT '平台ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `nick` varchar(255) DEFAULT '' COMMENT '昵称',
  `head` varchar(255) DEFAULT '' COMMENT '头像',
  `sex` int(11) DEFAULT '0' COMMENT '性别，0无性别，1男，2女',
  `level` int(11) DEFAULT '0' COMMENT '等级',
  `gold` bigint(20) DEFAULT '0' COMMENT '金币',
  `diamond` bigint(20) DEFAULT '0' COMMENT '钻石',
  `fighting` bigint(20) DEFAULT '0' COMMENT '战力',
  `recharge` bigint(20) DEFAULT '0' COMMENT '充值金额',
  `online` char(5) DEFAULT 'false' COMMENT '是否在线',
  `daily_online` bigint(20) DEFAULT '0' COMMENT '今日在线时长',
  `born_time` datetime DEFAULT NULL COMMENT '创号时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  PRIMARY KEY (`id`),
  KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家信息表';

-- ----------------------------
-- Records of player
-- ----------------------------
BEGIN;
INSERT INTO `player` (`insert_time`, `update_time`, `id`, `platform_id`, `channel_id`, `open_id`, `server_id`, `nick`, `head`, `sex`, `level`, `gold`, `diamond`, `fighting`, `recharge`, `online`, `daily_online`, `born_time`, `last_login_time`) VALUES ('2024-11-22 11:02:13', '2024-11-22 11:21:53', 335879897874433, 1001, 1, 'zxt', 1, '宁丁兰', '', 0, 1, 0, 0, 540, 0, 'true', 179, '2024-11-22 11:02:10', '2024-11-22 11:21:30');
INSERT INTO `player` (`insert_time`, `update_time`, `id`, `platform_id`, `channel_id`, `open_id`, `server_id`, `nick`, `head`, `sex`, `level`, `gold`, `diamond`, `fighting`, `recharge`, `online`, `daily_online`, `born_time`, `last_login_time`) VALUES ('2024-11-22 11:37:24', '2024-11-22 11:50:24', 335879897874434, 1001, 2, 'xg011732246612147', 1, '方昊乾', '', 0, 3, 20, 0, 1043, 0, 'false', 776, '2024-11-22 11:37:06', '2024-11-22 11:37:06');
COMMIT;

-- ----------------------------
-- Table structure for player_ltv
-- ----------------------------
DROP TABLE IF EXISTS `player_ltv`;
CREATE TABLE `player_ltv` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
  `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
  `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
  `money` bigint(20) DEFAULT '0' COMMENT '总支付金额，单位分',
  `player_count` int(11) DEFAULT '0' COMMENT '创号玩家数量',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_born_daycount` (`channel_id`,`born`,`day_count`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家生命周期价值LTV表';

-- ----------------------------
-- Records of player_ltv
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for player_pay_remain
-- ----------------------------
DROP TABLE IF EXISTS `player_pay_remain`;
CREATE TABLE `player_pay_remain` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
  `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
  `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
  `player` int(11) DEFAULT '0' COMMENT '人数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `csbd` (`channel_id`,`server_uid`,`born`,`day_count`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家付费留存表';

-- ----------------------------
-- Records of player_pay_remain
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for player_remain
-- ----------------------------
DROP TABLE IF EXISTS `player_remain`;
CREATE TABLE `player_remain` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
  `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
  `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
  `player` int(11) DEFAULT '0' COMMENT '人数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `csbd` (`channel_id`,`server_uid`,`born`,`day_count`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家留存表';

-- ----------------------------
-- Records of player_remain
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_callback
-- ----------------------------
DROP TABLE IF EXISTS `recharge_callback`;
CREATE TABLE `recharge_callback` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `platform_id` bigint(20) DEFAULT '0' COMMENT '平台ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `nick` varchar(255) DEFAULT '' COMMENT '玩家名字',
  `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
  `level` int(11) DEFAULT '0' COMMENT '下单等级',
  `sdk_order_id` varchar(255) DEFAULT '' COMMENT '渠道订单ID',
  `game_order_id` varchar(255) DEFAULT '' COMMENT '游戏服的订单ID',
  `money` bigint(20) DEFAULT '0' COMMENT '支付金额',
  `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
  `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
  `give` int(11) DEFAULT '0' COMMENT '发货状态，0未处理，1发货成功，2发货失败',
  `remark` varchar(3000) DEFAULT '' COMMENT '备注',
  `remark_idx` int(11) DEFAULT '0' COMMENT '备注序号',
  `test` int(11) DEFAULT '0' COMMENT '是否测试订单，1是，0不是',
  `all_check` char(5) DEFAULT 'false' COMMENT '是否所有验证都通过',
  `sign` varchar(255) DEFAULT '' COMMENT '订单签名',
  `local_sign` varchar(255) DEFAULT '' COMMENT '本地订单签名',
  `extra_sign` varchar(255) DEFAULT '' COMMENT '扩展参数签名',
  `local_extra_sign` varchar(255) DEFAULT '' COMMENT '本地扩展参数签名',
  `remote_ip` varchar(255) DEFAULT '' COMMENT '请求的IP',
  `callback_data` text COMMENT '回调原数据',
  `game_response` varchar(255) DEFAULT '' COMMENT '游戏服的响应',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='充值回调表';

-- ----------------------------
-- Records of recharge_callback
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_one_date
-- ----------------------------
DROP TABLE IF EXISTS `recharge_one_date`;
CREATE TABLE `recharge_one_date` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名称',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `nick` varchar(255) DEFAULT '' COMMENT '玩家昵称',
  `date_str` varchar(255) DEFAULT '' COMMENT '日期yyyyMMdd',
  `total_pay` bigint(20) DEFAULT '0' COMMENT '当日总支付',
  `last_recharge_time` datetime DEFAULT NULL COMMENT '当日最后充值时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channel_player_date` (`channel_id`,`player_id`,`date_str`) USING BTREE,
  KEY `channelid` (`channel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家某一天的充值表';

-- ----------------------------
-- Records of recharge_one_date
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_product_cfg
-- ----------------------------
DROP TABLE IF EXISTS `recharge_product_cfg`;
CREATE TABLE `recharge_product_cfg` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` int(11) NOT NULL COMMENT '商品ID',
  `name` varchar(255) DEFAULT '' COMMENT '商品名',
  `describe` varchar(255) DEFAULT '' COMMENT '商品描述',
  `money` bigint(20) DEFAULT '0' COMMENT '金额，单位分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商品配置';

-- ----------------------------
-- Records of recharge_product_cfg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_product_count
-- ----------------------------
DROP TABLE IF EXISTS `recharge_product_count`;
CREATE TABLE `recharge_product_count` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `product_id` int(11) DEFAULT '0' COMMENT '商品ID',
  `product_name` varchar(255) DEFAULT '' COMMENT '商品名字',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `pay_money` bigint(20) DEFAULT '0' COMMENT '支付金额',
  `callback_id` bigint(20) DEFAULT '0' COMMENT '回调ID',
  `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
  PRIMARY KEY (`id`),
  KEY `channelid` (`channel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='充值商品统计表';

-- ----------------------------
-- Records of recharge_product_count
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_today
-- ----------------------------
DROP TABLE IF EXISTS `recharge_today`;
CREATE TABLE `recharge_today` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `money` bigint(20) DEFAULT '0' COMMENT '支付金额',
  `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
  `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='今日充值表';

-- ----------------------------
-- Records of recharge_today
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_virtual
-- ----------------------------
DROP TABLE IF EXISTS `recharge_virtual`;
CREATE TABLE `recharge_virtual` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `nick` varchar(255) DEFAULT '' COMMENT '玩家名字',
  `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
  `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
  `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
  `money` bigint(20) DEFAULT '0' COMMENT '金额',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
  `status` int(11) DEFAULT '0' COMMENT '充值状态，0未处理，1成功，2失败',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='虚拟充值（内部充值）表';

-- ----------------------------
-- Records of recharge_virtual
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_counter
-- ----------------------------
DROP TABLE IF EXISTS `system_counter`;
CREATE TABLE `system_counter` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '数据ID',
  `remain_time` bigint(20) DEFAULT '0' COMMENT '留存统计时间',
  `pay_remain_time` bigint(20) DEFAULT '0' COMMENT '付费留存统计时间',
  `ltv_time` bigint(20) DEFAULT '0' COMMENT 'LTV统计时间',
  `god_finger_time` bigint(20) DEFAULT '0' COMMENT '金手指发放时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统数据统计时间表';

-- ----------------------------
-- Records of system_counter
-- ----------------------------
BEGIN;
INSERT INTO `system_counter` (`insert_time`, `update_time`, `id`, `remain_time`, `pay_remain_time`, `ltv_time`, `god_finger_time`) VALUES ('2024-11-21 18:09:36', '2025-02-28 09:38:48', 1, 1740758400000, 1740758400000, 1740749928231, 1740758400000);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `name` varchar(255) DEFAULT '' COMMENT '用户名',
  `password` varchar(255) DEFAULT '' COMMENT '密码',
  `level` int(11) DEFAULT '0' COMMENT '用户级别，高级别用户创建低级别用户，数字越小级别越高',
  `super_user` char(5) DEFAULT 'false' COMMENT '是否超级管理员，0不是，1是',
  `up_user_id` bigint(20) DEFAULT '0' COMMENT '上级用户ID',
  `phone` varchar(255) DEFAULT '' COMMENT '手机号码',
  `mail_address` varchar(255) DEFAULT '' COMMENT '邮箱地址',
  `usable` char(5) DEFAULT 'false' COMMENT '是否可用',
  `can_read_sensitive` char(5) DEFAULT 'false' COMMENT '是否可查看敏感信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_index` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`insert_time`, `update_time`, `id`, `name`, `password`, `level`, `super_user`, `up_user_id`, `phone`, `mail_address`, `usable`, `can_read_sensitive`) VALUES ('2024-11-21 18:53:13', '2024-11-21 18:53:15', 1, 'zx', '202cb962ac59075b964b07152d234b70', 0, 'true', 0, '', '', 'true', 'true');
COMMIT;

-- ----------------------------
-- Table structure for user_channel
-- ----------------------------
DROP TABLE IF EXISTS `user_channel`;
CREATE TABLE `user_channel` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '用户ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '用户名称',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名称',
  `grant_user_id` bigint(20) DEFAULT '0' COMMENT '授权的用户ID',
  `grant_user_name` varchar(255) DEFAULT '' COMMENT '授权的用户名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userId_channelId` (`user_id`,`channel_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户渠道表';

-- ----------------------------
-- Records of user_channel
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_function
-- ----------------------------
DROP TABLE IF EXISTS `user_function`;
CREATE TABLE `user_function` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '用户ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '用户名称',
  `function_id` bigint(20) DEFAULT '0' COMMENT '功能菜单ID',
  `function_name` varchar(255) DEFAULT '' COMMENT '功能菜单名字',
  `writee` char(5) DEFAULT 'false' COMMENT '是否具有写权限',
  `grant_user_id` bigint(20) DEFAULT '0' COMMENT '授权的用户ID',
  `grant_user_name` varchar(255) DEFAULT '' COMMENT '授权的用户名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_uf` (`user_id`,`function_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户功能权限表';

-- ----------------------------
-- Records of user_function
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wabo_setting
-- ----------------------------
DROP TABLE IF EXISTS `wabo_setting`;
CREATE TABLE `wabo_setting` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '数据ID',
  `game_id` varchar(255) DEFAULT '' COMMENT '渠道参数游戏ID',
  `game_key` varchar(255) DEFAULT '' COMMENT '游戏密钥',
  `login_url` varchar(255) DEFAULT '' COMMENT '验证登录URL',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='wabo渠道参数设置';

-- ----------------------------
-- Records of wabo_setting
-- ----------------------------
BEGIN;
INSERT INTO `wabo_setting` (`insert_time`, `update_time`, `id`, `game_id`, `game_key`, `login_url`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 1, '15345', 'sdasd', 'https://game-gateway.bepicgames.com/api/server/token');
COMMIT;

-- ----------------------------
-- Table structure for white_list
-- ----------------------------
DROP TABLE IF EXISTS `white_list`;
CREATE TABLE `white_list` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
  `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
  `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  `user_id` bigint(20) DEFAULT '0' COMMENT '操作人ID',
  `user_name` varchar(255) DEFAULT '' COMMENT '操作人名字',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='白名单表';

-- ----------------------------
-- Records of white_list
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for yile_setting
-- ----------------------------
DROP TABLE IF EXISTS `yile_setting`;
CREATE TABLE `yile_setting` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '数据ID',
  `platform_id` bigint(20) DEFAULT '0' COMMENT '益乐平台数据ID',
  `game_id` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
  `product_key` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
  `charge_key` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
  `login_url` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='益乐渠道参数设置';

-- ----------------------------
-- Records of yile_setting
-- ----------------------------
BEGIN;
INSERT INTO `yile_setting` (`insert_time`, `update_time`, `id`, `platform_id`, `game_id`, `product_key`, `charge_key`, `login_url`) VALUES ('2024-11-21 18:09:33', '2024-11-21 18:09:33', 1, 0, '10910', '0f504f9466fb085b10be8fafe7debf65', 'e581eea614f472e294cea85d75a2eb62', 'https://oursdk.bingchenghuyu.com/cp/loginVerify');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;