Главная Обзор Помощь
Регистрация Вход
bailian
/
x1-project
2
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Ветка: develop
Ветки Метки
x1-project
/
db
/
x1_backstage.sql

x1_backstage.sql 143 KB
Постоянная ссылка История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 192.168.3.245
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50727 (5.7.27)
    7. 

  7.  Source Host           : 192.168.3.245:33061
    8. 

  8.  Source Schema         : x1_backstage
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50727 (5.7.27)
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 05/03/2025 09:32:51
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for api_doc
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `api_doc`;
    24. 

  24. CREATE TABLE `api_doc` (
    25. 

  25.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    26. 

  26.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    27. 

  27.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    28. 

  28.   `href_url` varchar(255) DEFAULT '' COMMENT '链接地址',
    29. 

  29.   `comment` varchar(255) DEFAULT '' COMMENT '接口说明',
    30. 

  30.   `param_form` varchar(2000) DEFAULT '' COMMENT '参数格式',
    31. 

  31.   `return_form` varchar(2000) DEFAULT '' COMMENT '返回格式',
    32. 

  32.   PRIMARY KEY (`id`)
    33. 

  33. ) ENGINE=InnoDB AUTO_INCREMENT=100000144 DEFAULT CHARSET=utf8mb4 COMMENT='接口说明';
    34. 

  34. 

  35. -- ----------------------------
    36. 

  36. -- Records of api_doc
    37. 

  37. -- ----------------------------
    38. 

  38. BEGIN;
    39. 

  39. 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}]}');
    40. 

  40. 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}]}');
    41. 

  41. 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', '');
    42. 

  42. 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}');
    43. 

  43. 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}]}');
    44. 

  44. 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', '手动触发昨天付费留存数据统计', '', '');
    45. 

  45. 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}]}');
    46. 

  46. 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', '');
    47. 

  47. 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}]}');
    48. 

  48. 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}]}');
    49. 

  49. 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', '');
    50. 

  50. 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', '');
    51. 

  51. 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}');
    52. 

  52. 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}]}');
    53. 

  53. 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}]}');
    54. 

  54. 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}]}');
    55. 

  55. 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', '');
    56. 

  56. 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}]}');
    57. 

  57. 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}]}');
    58. 

  58. 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}');
    59. 

  59. 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}]}');
    60. 

  60. 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}]}');
    61. 

  61. 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', '更新游戏道具数据', '', '');
    62. 

  62. 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}]}');
    63. 

  63. 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}]}');
    64. 

  64. 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}');
    65. 

  65. 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}');
    66. 

  66. 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}]}');
    67. 

  67. 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}]}');
    68. 

  68. 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}]}');
    69. 

  69. 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', '');
    70. 

  70. 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', '');
    71. 

  71. 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', '');
    72. 

  72. 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}]}');
    73. 

  73. 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', '');
    74. 

  74. 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}');
    75. 

  75. 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}]}');
    76. 

  76. 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}]}');
    77. 

  77. 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', '\"\"');
    78. 

  78. 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', '');
    79. 

  79. 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}');
    80. 

  80. 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', '');
    81. 

  81. 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}');
    82. 

  82. 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}]}');
    83. 

  83. 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}]}');
    84. 

  84. 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}]}');
    85. 

  85. 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', '');
    86. 

  86. 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}]}');
    87. 

  87. 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', '');
    88. 

  88. 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}]}');
    89. 

  89. 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}]}');
    90. 

  90. 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}]}');
    91. 

  91. 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}]}');
    92. 

  92. 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}]}');
    93. 

  93. 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}]}');
    94. 

  94. 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}]}');
    95. 

  95. 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', '更新流水事件数据', '', '');
    96. 

  96. 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}]}');
    97. 

  97. 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', '');
    98. 

  98. 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}]}');
    99. 

  99. 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', '更新游戏充值商品配置数据', '', '');
    100. 

  100. 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}]');
    101. 

  101. 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}]}');
    102. 

  102. 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}]}');
    103. 

  103. 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', '\"\"');
    104. 

  104. 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', '');
    105. 

  105. 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', '\"\"');
    106. 

  106. 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}');
    107. 

  107. 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}]}');
    108. 

  108. 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}');
    109. 

  109. 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}]}');
    110. 

  110. 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}]}');
    111. 

  111. 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}]}');
    112. 

  112. 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}]}');
    113. 

  113. 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}]}');
    114. 

  114. 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}]}');
    115. 

  115. 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}]}');
    116. 

  116. 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', '');
    117. 

  117. 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}');
    118. 

  118. 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}]}');
    119. 

  119. 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', '');
    120. 

  120. 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}');
    121. 

  121. 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}]}');
    122. 

  122. 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', '');
    123. 

  123. 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}]}');
    124. 

  124. 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}]}');
    125. 

  125. 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}');
    126. 

  126. 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}]}');
    127. 

  127. 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}]}');
    128. 

  128. 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', '');
    129. 

  129. 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}]}');
    130. 

  130. 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}]}');
    131. 

  131. 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}');
    132. 

  132. 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}]}');
    133. 

  133. 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}');
    134. 

  134. 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}]}');
    135. 

  135. 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}]');
    136. 

  136. 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', '');
    137. 

  137. 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}]}');
    138. 

  138. 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', '');
    139. 

  139. 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}');
    140. 

  140. 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}]}');
    141. 

  141. 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}]}');
    142. 

  142. 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}]}');
    143. 

  143. 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}]}');
    144. 

  144. 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}]}');
    145. 

  145. 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}');
    146. 

  146. 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}]}');
    147. 

  147. 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}]}');
    148. 

  148. 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}]}');
    149. 

  149. 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', '手动触发昨天留存数据统计', '', '');
    150. 

  150. 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}]}');
    151. 

  151. 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', '');
    152. 

  152. 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}]}');
    153. 

  153. 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}]}');
    154. 

  154. 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}]}');
    155. 

  155. 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}');
    156. 

  156. 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', '\"\"');
    157. 

  157. 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}');
    158. 

  158. 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}');
    159. 

  159. 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}]}');
    160. 

  160. 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', '');
    161. 

  161. 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', '');
    162. 

  162. 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}]}');
    163. 

  163. 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', '');
    164. 

  164. 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}]}');
    165. 

  165. 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}');
    166. 

  166. 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}]}');
    167. 

  167. 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', '');
    168. 

  168. 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}]}');
    169. 

  169. 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}]}');
    170. 

  170. 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}]}');
    171. 

  171. 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', '更新游戏兑换码礼包配置数据', '', '');
    172. 

  172. 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', '发送封禁账号到渠道下各游戏服', '', '');
    173. 

  173. 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}]}');
    174. 

  174. 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}');
    175. 

  175. 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', '');
    176. 

  176. 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}]}');
    177. 

  177. 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}]}');
    178. 

  178. 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', '\"\"');
    179. 

  179. 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}');
    180. 

  180. 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}]}');
    181. 

  181. 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}]}');
    182. 

  182. COMMIT;
    183. 

  183. 

  184. -- ----------------------------
    185. 

  185. -- Table structure for bulletin
    186. 

  186. -- ----------------------------
    187. 

  187. DROP TABLE IF EXISTS `bulletin`;
    188. 

  188. CREATE TABLE `bulletin` (
    189. 

  189.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    190. 

  190.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    191. 

  191.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    192. 

  192.   `title` varchar(255) DEFAULT '' COMMENT '公告标题',
    193. 

  193.   `content` text COMMENT '公告内容',
    194. 

  194.   PRIMARY KEY (`id`)
    195. 

  195. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏公告表';
    196. 

  196. 

  197. -- ----------------------------
    198. 

  198. -- Records of bulletin
    199. 

  199. -- ----------------------------
    200. 

  200. BEGIN;
    201. 

  201. 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');
    202. 

  202. COMMIT;
    203. 

  203. 

  204. -- ----------------------------
    205. 

  205. -- Table structure for client_log
    206. 

  206. -- ----------------------------
    207. 

  207. DROP TABLE IF EXISTS `client_log`;
    208. 

  208. CREATE TABLE `client_log` (
    209. 

  209.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    210. 

  210.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    211. 

  211.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
    212. 

  212.   `level` varchar(255) DEFAULT '' COMMENT '日志级别',
    213. 

  213.   `title` varchar(255) DEFAULT '' COMMENT '标题、类别',
    214. 

  214.   `content` text COMMENT '日志信息',
    215. 

  215.   `player_id` varchar(255) DEFAULT '' COMMENT '玩家ID',
    216. 

  216.   `name` varchar(255) DEFAULT '' COMMENT '玩家名称',
    217. 

  217.   `data` text COMMENT '日志内容',
    218. 

  218.   `send` char(5) DEFAULT 'false' COMMENT '是否已发送给管理员',
    219. 

  219.   PRIMARY KEY (`id`)
    220. 

  220. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='客户端日志';
    221. 

  221. 

  222. -- ----------------------------
    223. 

  223. -- Records of client_log
    224. 

  224. -- ----------------------------
    225. 

  225. BEGIN;
    226. 

  226. 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');
    227. 

  227. 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');
    228. 

  228. 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');
    229. 

  229. COMMIT;
    230. 

  230. 

  231. -- ----------------------------
    232. 

  232. -- Table structure for client_version
    233. 

  233. -- ----------------------------
    234. 

  234. DROP TABLE IF EXISTS `client_version`;
    235. 

  235. CREATE TABLE `client_version` (
    236. 

  236.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    237. 

  237.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    238. 

  238.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    239. 

  239.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    240. 

  240.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    241. 

  241.   `version_code` int(11) DEFAULT '0' COMMENT '版本编号',
    242. 

  242.   `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试，2审核，3正式',
    243. 

  243.   `remote_url` varchar(255) DEFAULT '' COMMENT '远程地址',
    244. 

  244.   `resource_version` varchar(255) DEFAULT '' COMMENT '客户端资源版本号',
    245. 

  245.   `remark` varchar(255) DEFAULT '' COMMENT '备注',
    246. 

  246.   `pc_resource_version` varchar(255) DEFAULT '' COMMENT 'PC客户端资源版本号',
    247. 

  247.   `quick_url` varchar(255) DEFAULT '' COMMENT '快速通道地址',
    248. 

  248.   PRIMARY KEY (`id`),
    249. 

  249.   UNIQUE KEY `channel_version` (`channel_id`,`version_code`) USING BTREE
    250. 

  250. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='客户端版本控制';
    251. 

  251. 

  252. -- ----------------------------
    253. 

  253. -- Records of client_version
    254. 

  254. -- ----------------------------
    255. 

  255. BEGIN;
    256. 

  256. 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);
    257. 

  257. COMMIT;
    258. 

  258. 

  259. -- ----------------------------
    260. 

  260. -- Table structure for dot_data_login_statistic
    261. 

  261. -- ----------------------------
    262. 

  262. DROP TABLE IF EXISTS `dot_data_login_statistic`;
    263. 

  263. CREATE TABLE `dot_data_login_statistic` (
    264. 

  264.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    265. 

  265.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    266. 

  266.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    267. 

  267.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    268. 

  268.   `date_str` varchar(255) DEFAULT '' COMMENT '日期字符串，yyyyMMdd',
    269. 

  269.   `req_res_url_begin` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径',
    270. 

  270.   `req_res_url_sucess` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径成功',
    271. 

  271.   `req_res_url_fail` int(11) DEFAULT '0' COMMENT '根据版本号请求资源路径成功',
    272. 

  272.   `sdk_login_begin` int(11) DEFAULT '0' COMMENT 'SDK开始登陆',
    273. 

  273.   `sdk_login_sucess` int(11) DEFAULT '0' COMMENT 'SDK的登录成功',
    274. 

  274.   `sdk_login_fail` int(11) DEFAULT '0' COMMENT 'SDK的登录失败',
    275. 

  275.   `req_server_verify_begin` int(11) DEFAULT '0' COMMENT '请求服务器账号验证',
    276. 

  276.   `req_server_verify_sucess` int(11) DEFAULT '0' COMMENT '请求服务器账号验证成功',
    277. 

  277.   `req_server_verify_fail` int(11) DEFAULT '0' COMMENT '请求服务器账号验证失败',
    278. 

  278.   `req_server_list_begin` int(11) DEFAULT '0' COMMENT '请求服务器列表',
    279. 

  279.   `req_server_list_sucess` int(11) DEFAULT '0' COMMENT '请求服务器列表成功',
    280. 

  280.   `req_server_list_fail` int(11) DEFAULT '0' COMMENT '请求服务器列表失败',
    281. 

  281.   `start_game` int(11) DEFAULT '0' COMMENT '点击开始游戏',
    282. 

  282.   `req_socket_connect_sucess` int(11) DEFAULT '0' COMMENT '向服务器socket连接成功',
    283. 

  283.   `req_socket_login_begin` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议',
    284. 

  284.   `req_socket_login_sucess` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议成功',
    285. 

  285.   `req_socket_login_fail` int(11) DEFAULT '0' COMMENT '向服务器发送登陆请求协议失败',
    286. 

  286.   `create_succ` int(11) DEFAULT '0' COMMENT '创号成功',
    287. 

  287.   `req_server_push_data_end` int(11) DEFAULT '0' COMMENT '服务器推送数据结束',
    288. 

  288.   `in_game` int(11) DEFAULT '0' COMMENT '进入游戏',
    289. 

  289.   PRIMARY KEY (`id`),
    290. 

  290.   UNIQUE KEY `channelid_datastr` (`channel_id`,`date_str`) USING BTREE
    291. 

  291. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='登录打点数据统计';
    292. 

  292. 

  293. -- ----------------------------
    294. 

  294. -- Records of dot_data_login_statistic
    295. 

  295. -- ----------------------------
    296. 

  296. BEGIN;
    297. 

  297. 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);
    298. 

  298. 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);
    299. 

  299. COMMIT;
    300. 

  300. 

  301. -- ----------------------------
    302. 

  302. -- Table structure for dot_data_task_statistic
    303. 

  303. -- ----------------------------
    304. 

  304. DROP TABLE IF EXISTS `dot_data_task_statistic`;
    305. 

  305. CREATE TABLE `dot_data_task_statistic` (
    306. 

  306.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    307. 

  307.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    308. 

  308.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    309. 

  309.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    310. 

  310.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器ID',
    311. 

  311.   `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
    312. 

  312.   `task_name` varchar(255) DEFAULT '' COMMENT '任务名称',
    313. 

  313.   `start_num` int(11) DEFAULT '0' COMMENT '接取人数',
    314. 

  314.   `finish_num` int(11) DEFAULT '0' COMMENT '完成人数',
    315. 

  315.   PRIMARY KEY (`id`),
    316. 

  316.   KEY `channel_id` (`channel_id`) USING BTREE
    317. 

  317. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='任务打点数据统计';
    318. 

  318. 

  319. -- ----------------------------
    320. 

  320. -- Records of dot_data_task_statistic
    321. 

  321. -- ----------------------------
    322. 

  322. BEGIN;
    323. 

  323. COMMIT;
    324. 

  324. 

  325. -- ----------------------------
    326. 

  326. -- Table structure for fix_code
    327. 

  327. -- ----------------------------
    328. 

  328. DROP TABLE IF EXISTS `fix_code`;
    329. 

  329. CREATE TABLE `fix_code` (
    330. 

  330.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    331. 

  331.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    332. 

  332.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    333. 

  333.   `server_uids` varchar(255) DEFAULT '' COMMENT '热更的服务器唯一ID集合',
    334. 

  334.   `file_names` text COMMENT '配置文件相对路径',
    335. 

  335.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    336. 

  336.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    337. 

  337.   `fix_time` varchar(255) DEFAULT '' COMMENT '热更时间批号',
    338. 

  338.   PRIMARY KEY (`id`)
    339. 

  339. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更代码记录表';
    340. 

  340. 

  341. -- ----------------------------
    342. 

  342. -- Records of fix_code
    343. 

  343. -- ----------------------------
    344. 

  344. BEGIN;
    345. 

  345. COMMIT;
    346. 

  346. 

  347. -- ----------------------------
    348. 

  348. -- Table structure for fix_code_result
    349. 

  349. -- ----------------------------
    350. 

  350. DROP TABLE IF EXISTS `fix_code_result`;
    351. 

  351. CREATE TABLE `fix_code_result` (
    352. 

  352.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    353. 

  353.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    354. 

  354.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    355. 

  355.   `fix_id` bigint(20) DEFAULT '0' COMMENT '修正记录ID',
    356. 

  356.   `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
    357. 

  357.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    358. 

  358.   `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    359. 

  359.   `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
    360. 

  360.   `code` int(11) DEFAULT '0' COMMENT '服务器响应码',
    361. 

  361.   `message` varchar(255) DEFAULT '' COMMENT '服务器响应消息',
    362. 

  362.   PRIMARY KEY (`id`)
    363. 

  363. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更代码结果记录表';
    364. 

  364. 

  365. -- ----------------------------
    366. 

  366. -- Records of fix_code_result
    367. 

  367. -- ----------------------------
    368. 

  368. BEGIN;
    369. 

  369. COMMIT;
    370. 

  370. 

  371. -- ----------------------------
    372. 

  372. -- Table structure for fix_design
    373. 

  373. -- ----------------------------
    374. 

  374. DROP TABLE IF EXISTS `fix_design`;
    375. 

  375. CREATE TABLE `fix_design` (
    376. 

  376.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    377. 

  377.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    378. 

  378.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    379. 

  379.   `server_uids` varchar(255) DEFAULT '' COMMENT '热更的服务器唯一ID集合',
    380. 

  380.   `file_names` text COMMENT '配置文件相对路径',
    381. 

  381.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    382. 

  382.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    383. 

  383.   `fix_time` varchar(255) DEFAULT '' COMMENT '热更时间批号',
    384. 

  384.   PRIMARY KEY (`id`)
    385. 

  385. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更配置记录表';
    386. 

  386. 

  387. -- ----------------------------
    388. 

  388. -- Records of fix_design
    389. 

  389. -- ----------------------------
    390. 

  390. BEGIN;
    391. 

  391. COMMIT;
    392. 

  392. 

  393. -- ----------------------------
    394. 

  394. -- Table structure for fix_design_result
    395. 

  395. -- ----------------------------
    396. 

  396. DROP TABLE IF EXISTS `fix_design_result`;
    397. 

  397. CREATE TABLE `fix_design_result` (
    398. 

  398.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    399. 

  399.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    400. 

  400.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    401. 

  401.   `fix_id` bigint(20) DEFAULT '0' COMMENT '修正记录ID',
    402. 

  402.   `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
    403. 

  403.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    404. 

  404.   `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    405. 

  405.   `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
    406. 

  406.   `code` int(11) DEFAULT '0' COMMENT '服务器响应码',
    407. 

  407.   `message` varchar(255) DEFAULT '' COMMENT '服务器响应消息',
    408. 

  408.   PRIMARY KEY (`id`)
    409. 

  409. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='热更配置结果记录表';
    410. 

  410. 

  411. -- ----------------------------
    412. 

  412. -- Records of fix_design_result
    413. 

  413. -- ----------------------------
    414. 

  414. BEGIN;
    415. 

  415. COMMIT;
    416. 

  416. 

  417. -- ----------------------------
    418. 

  418. -- Table structure for forbid_list
    419. 

  419. -- ----------------------------
    420. 

  420. DROP TABLE IF EXISTS `forbid_list`;
    421. 

  421. CREATE TABLE `forbid_list` (
    422. 

  422.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    423. 

  423.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    424. 

  424.   `id` bigint(20) NOT NULL COMMENT '唯一ID',
    425. 

  425.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    426. 

  426.   `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
    427. 

  427.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作人ID',
    428. 

  428.   `user_name` varchar(255) DEFAULT '' COMMENT '操作人名字',
    429. 

  429.   PRIMARY KEY (`id`),
    430. 

  430.   UNIQUE KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
    431. 

  431. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='封禁账号表';
    432. 

  432. 

  433. -- ----------------------------
    434. 

  434. -- Records of forbid_list
    435. 

  435. -- ----------------------------
    436. 

  436. BEGIN;
    437. 

  437. COMMIT;
    438. 

  438. 

  439. -- ----------------------------
    440. 

  440. -- Table structure for fushun_setting
    441. 

  441. -- ----------------------------
    442. 

  442. DROP TABLE IF EXISTS `fushun_setting`;
    443. 

  443. CREATE TABLE `fushun_setting` (
    444. 

  444.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    445. 

  445.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    446. 

  446.   `id` bigint(20) NOT NULL COMMENT '数据ID',
    447. 

  447.   `game_id` varchar(255) DEFAULT '' COMMENT '渠道参数游戏ID',
    448. 

  448.   `game_key` varchar(255) DEFAULT '' COMMENT '游戏密钥',
    449. 

  449.   `login_url` varchar(255) DEFAULT '' COMMENT '验证登录URL',
    450. 

  450.   PRIMARY KEY (`id`)
    451. 

  451. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='福顺参数设置';
    452. 

  452. 

  453. -- ----------------------------
    454. 

  454. -- Records of fushun_setting
    455. 

  455. -- ----------------------------
    456. 

  456. BEGIN;
    457. 

  457. 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/');
    458. 

  458. COMMIT;
    459. 

  459. 

  460. -- ----------------------------
    461. 

  461. -- Table structure for game_cause
    462. 

  462. -- ----------------------------
    463. 

  463. DROP TABLE IF EXISTS `game_cause`;
    464. 

  464. CREATE TABLE `game_cause` (
    465. 

  465.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    466. 

  466.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    467. 

  467.   `id` bigint(20) NOT NULL COMMENT '事件ID',
    468. 

  468.   `name` varchar(255) DEFAULT '' COMMENT '事件名',
    469. 

  469.   PRIMARY KEY (`id`)
    470. 

  470. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏流水事件表';
    471. 

  471. 

  472. -- ----------------------------
    473. 

  473. -- Records of game_cause
    474. 

  474. -- ----------------------------
    475. 

  475. BEGIN;
    476. 

  476. COMMIT;
    477. 

  477. 

  478. -- ----------------------------
    479. 

  479. -- Table structure for game_channel
    480. 

  480. -- ----------------------------
    481. 

  481. DROP TABLE IF EXISTS `game_channel`;
    482. 

  482. CREATE TABLE `game_channel` (
    483. 

  483.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    484. 

  484.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    485. 

  485.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '渠道ID',
    486. 

  486.   `name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    487. 

  487.   `platform_id` bigint(20) DEFAULT '0' COMMENT '归属平台ID',
    488. 

  488.   `platform_name` varchar(255) DEFAULT '' COMMENT '归属平台名称',
    489. 

  489.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    490. 

  490.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    491. 

  491.   `bulletin_id` bigint(20) DEFAULT '0' COMMENT '公告ID',
    492. 

  492.   `program_version` varchar(255) DEFAULT '' COMMENT '客户端程序版本号',
    493. 

  493.   `resource_version` varchar(255) DEFAULT '' COMMENT '客户端资源版本号',
    494. 

  494.   PRIMARY KEY (`id`)
    495. 

  495. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏渠道表';
    496. 

  496. 

  497. -- ----------------------------
    498. 

  498. -- Records of game_channel
    499. 

  499. -- ----------------------------
    500. 

  500. BEGIN;
    501. 

  501. 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, '', '');
    502. 

  502. COMMIT;
    503. 

  503. 

  504. -- ----------------------------
    505. 

  505. -- Table structure for game_channel_server
    506. 

  506. -- ----------------------------
    507. 

  507. DROP TABLE IF EXISTS `game_channel_server`;
    508. 

  508. CREATE TABLE `game_channel_server` (
    509. 

  509.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    510. 

  510.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    511. 

  511.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关系ID',
    512. 

  512.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    513. 

  513.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    514. 

  514.   `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
    515. 

  515.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    516. 

  516.   `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    517. 

  517.   `region_id` int(11) DEFAULT '0' COMMENT '所属大区ID',
    518. 

  518.   `region_name` varchar(255) DEFAULT '' COMMENT '所属大区名称',
    519. 

  519.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    520. 

  520.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    521. 

  521.   `recommend` char(5) DEFAULT 'false' COMMENT '是否为推荐服务器',
    522. 

  522.   PRIMARY KEY (`id`),
    523. 

  523.   UNIQUE KEY `channelid_serverid` (`channel_id`,`server_id`) USING BTREE,
    524. 

  524.   KEY `channelid` (`channel_id`) USING BTREE
    525. 

  525. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏渠道与服务器关系表';
    526. 

  526. 

  527. -- ----------------------------
    528. 

  528. -- Records of game_channel_server
    529. 

  529. -- ----------------------------
    530. 

  530. BEGIN;
    531. 

  531. 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');
    532. 

  532. COMMIT;
    533. 

  533. 

  534. -- ----------------------------
    535. 

  535. -- Table structure for game_db
    536. 

  536. -- ----------------------------
    537. 

  537. DROP TABLE IF EXISTS `game_db`;
    538. 

  538. CREATE TABLE `game_db` (
    539. 

  539.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    540. 

  540.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    541. 

  541.   `db_name` varchar(255) NOT NULL COMMENT '数据库名字，唯一ID',
    542. 

  542.   `platform_id` int(11) DEFAULT '0' COMMENT '平台ID',
    543. 

  543.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    544. 

  544.   `type` varchar(255) DEFAULT '' COMMENT '服务器类型',
    545. 

  545.   `zone_id` int(11) DEFAULT '0' COMMENT '在服务器里面用的一个ID，基本是1',
    546. 

  546.   `alias` varchar(255) DEFAULT '' COMMENT '别名',
    547. 

  547.   `ip_port` varchar(255) DEFAULT '' COMMENT 'IP与端口，填内网IP与端口',
    548. 

  548.   `user` varchar(255) DEFAULT '' COMMENT '数据库用户',
    549. 

  549.   `password` varchar(255) DEFAULT '' COMMENT '数据库密码',
    550. 

  550.   `min_idle` int(11) DEFAULT '0' COMMENT '最少空闲连接数',
    551. 

  551.   `max_active` int(11) DEFAULT '0' COMMENT '最大活跃连接数',
    552. 

  552.   `max_wait_millis` int(11) DEFAULT '0' COMMENT '最大等级时间',
    553. 

  553.   PRIMARY KEY (`db_name`),
    554. 

  554.   UNIQUE KEY `db_name` (`db_name`) USING BTREE
    555. 

  555. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏数据库管理表';
    556. 

  556. 

  557. -- ----------------------------
    558. 

  558. -- Records of game_db
    559. 

  559. -- ----------------------------
    560. 

  560. BEGIN;
    561. 

  561. COMMIT;
    562. 

  562. 

  563. -- ----------------------------
    564. 

  564. -- Table structure for game_platform
    565. 

  565. -- ----------------------------
    566. 

  566. DROP TABLE IF EXISTS `game_platform`;
    567. 

  567. CREATE TABLE `game_platform` (
    568. 

  568.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    569. 

  569.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    570. 

  570.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '平台ID',
    571. 

  571.   `name` varchar(255) DEFAULT '' COMMENT '平台名称',
    572. 

  572.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    573. 

  573.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    574. 

  574.   PRIMARY KEY (`id`)
    575. 

  575. ) ENGINE=InnoDB AUTO_INCREMENT=1002 DEFAULT CHARSET=utf8mb4 COMMENT='游戏平台表';
    576. 

  576. 

  577. -- ----------------------------
    578. 

  578. -- Records of game_platform
    579. 

  579. -- ----------------------------
    580. 

  580. BEGIN;
    581. 

  581. 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');
    582. 

  582. COMMIT;
    583. 

  583. 

  584. -- ----------------------------
    585. 

  585. -- Table structure for game_region
    586. 

  586. -- ----------------------------
    587. 

  587. DROP TABLE IF EXISTS `game_region`;
    588. 

  588. CREATE TABLE `game_region` (
    589. 

  589.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    590. 

  590.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    591. 

  591.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
    592. 

  592.   `region_id` int(11) DEFAULT '0' COMMENT '大区ID',
    593. 

  593.   `name` varchar(255) DEFAULT '' COMMENT '大区名称',
    594. 

  594.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    595. 

  595.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    596. 

  596.   `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试服，2审核服，3正式服',
    597. 

  597.   PRIMARY KEY (`id`),
    598. 

  598.   UNIQUE KEY `channelid_regionid` (`channel_id`,`region_id`) USING BTREE
    599. 

  599. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='游戏大区表';
    600. 

  600. 

  601. -- ----------------------------
    602. 

  602. -- Records of game_region
    603. 

  603. -- ----------------------------
    604. 

  604. BEGIN;
    605. 

  605. 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);
    606. 

  606. COMMIT;
    607. 

  607. 

  608. -- ----------------------------
    609. 

  609. -- Table structure for game_server
    610. 

  610. -- ----------------------------
    611. 

  611. DROP TABLE IF EXISTS `game_server`;
    612. 

  612. CREATE TABLE `game_server` (
    613. 

  613.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    614. 

  614.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    615. 

  615.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
    616. 

  616.   `platform_id` bigint(20) DEFAULT '0' COMMENT '归属平台ID',
    617. 

  617.   `platform_name` varchar(255) DEFAULT '' COMMENT '归属平台名称',
    618. 

  618.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    619. 

  619.   `name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    620. 

  620.   `server_type` int(11) DEFAULT '0' COMMENT '服务器类型，1测试服，2审核服，3正式服',
    621. 

  621.   `socket_type` varchar(255) DEFAULT '' COMMENT 'socket连接方式',
    622. 

  622.   `external_ip` varchar(255) DEFAULT '' COMMENT '外网IP',
    623. 

  623.   `internal_ip` varchar(255) DEFAULT '' COMMENT '内网IP',
    624. 

  624.   `tcp_port` int(11) DEFAULT '0' COMMENT 'tcp/ws端口',
    625. 

  625.   `http_port` int(11) DEFAULT '0' COMMENT 'http端口',
    626. 

  626.   `db_game_name` varchar(255) DEFAULT '' COMMENT '游戏数据库名',
    627. 

  627.   `db_log_name` varchar(255) DEFAULT '' COMMENT '日志数据库名',
    628. 

  628.   `status` int(11) DEFAULT '0' COMMENT '状态，0维护，1流畅，2爆满，3新服',
    629. 

  629.   `recommend` char(5) DEFAULT 'false' COMMENT '是否为推荐服务器',
    630. 

  630.   `open_time` datetime DEFAULT NULL COMMENT '预期开服时间',
    631. 

  631.   `real_open_time` datetime DEFAULT NULL COMMENT '实际开服时间',
    632. 

  632.   `send_open_status` int(11) DEFAULT '0' COMMENT '开服时间是否发送成功，0未发送，1成功，2失败',
    633. 

  633.   `maintain` char(5) DEFAULT 'false' COMMENT '服务器是否维护中',
    634. 

  634.   `maintain_response` char(5) DEFAULT 'false' COMMENT '服务器维护消息是否发送成功',
    635. 

  635.   `merge` char(5) DEFAULT 'false' COMMENT '服务器是否已被合服',
    636. 

  636.   `hide` char(5) DEFAULT 'false' COMMENT '是否隐藏入口',
    637. 

  637.   PRIMARY KEY (`id`),
    638. 

  638.   UNIQUE KEY `platformid_serverid` (`platform_id`,`server_id`) USING BTREE
    639. 

  639. ) ENGINE=InnoDB AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8mb4 COMMENT='游戏服务器表';
    640. 

  640. 

  641. -- ----------------------------
    642. 

  642. -- Records of game_server
    643. 

  643. -- ----------------------------
    644. 

  644. BEGIN;
    645. 

  645. 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');
    646. 

  646. COMMIT;
    647. 

  647. 

  648. -- ----------------------------
    649. 

  649. -- Table structure for game_server_runtime
    650. 

  650. -- ----------------------------
    651. 

  651. DROP TABLE IF EXISTS `game_server_runtime`;
    652. 

  652. CREATE TABLE `game_server_runtime` (
    653. 

  653.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    654. 

  654.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    655. 

  655.   `server_uid` int(11) NOT NULL COMMENT '服务器唯一ID',
    656. 

  656.   `register_num` int(11) DEFAULT '0' COMMENT '注册数',
    657. 

  657.   `create_num` int(11) DEFAULT '0' COMMENT '创角数',
    658. 

  658.   `online_num` int(11) DEFAULT '0' COMMENT '在线数',
    659. 

  659.   `battle_num` int(11) DEFAULT '0' COMMENT '战斗数',
    660. 

  660.   `curr_battle_num` int(11) DEFAULT '0' COMMENT '当前战斗数',
    661. 

  661.   `running` char(5) DEFAULT 'false' COMMENT '服务器是否正常运行',
    662. 

  662.   `heart_time` datetime DEFAULT NULL COMMENT '最后心跳时间',
    663. 

  663.   `max_memory` varchar(255) DEFAULT '' COMMENT '最大可用内存',
    664. 

  664.   `free_memory` varchar(255) DEFAULT '' COMMENT '空闲内存',
    665. 

  665.   `total_memory` varchar(255) DEFAULT '' COMMENT '占用内存（占用内存=空闲内存+实际使用内存）',
    666. 

  666.   `used_memory` varchar(255) DEFAULT '' COMMENT '实际使用内存',
    667. 

  667.   `left_memory` varchar(255) DEFAULT '' COMMENT '剩余可用内存（剩余可用内存=最大可用内存-实际使用内存）',
    668. 

  668.   PRIMARY KEY (`server_uid`)
    669. 

  669. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏服务器运行数据表';
    670. 

  670. 

  671. -- ----------------------------
    672. 

  672. -- Records of game_server_runtime
    673. 

  673. -- ----------------------------
    674. 

  674. BEGIN;
    675. 

  675. 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');
    676. 

  676. COMMIT;
    677. 

  677. 

  678. -- ----------------------------
    679. 

  679. -- Table structure for gift_code
    680. 

  680. -- ----------------------------
    681. 

  681. DROP TABLE IF EXISTS `gift_code`;
    682. 

  682. CREATE TABLE `gift_code` (
    683. 

  683.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    684. 

  684.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    685. 

  685.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
    686. 

  686.   `code` varchar(255) DEFAULT '' COMMENT '礼包码',
    687. 

  687.   `channel_id` bigint(20) DEFAULT '0' COMMENT '所属渠道ID',
    688. 

  688.   `type` int(11) DEFAULT '0' COMMENT '礼包码类型，1通码，2独享码',
    689. 

  689.   `config_id` int(11) DEFAULT '0' COMMENT '配置礼包ID',
    690. 

  690.   `config_name` varchar(255) DEFAULT '' COMMENT '配置礼包名称',
    691. 

  691.   `user_id` bigint(20) DEFAULT '0' COMMENT '创建的用户ID',
    692. 

  692.   `user_name` varchar(255) DEFAULT '' COMMENT '创建的用户名称',
    693. 

  693.   `player_id` bigint(20) DEFAULT '0' COMMENT '使用码的玩家ID',
    694. 

  694.   `player_name` varchar(255) DEFAULT '' COMMENT '使用码的玩家名称',
    695. 

  695.   PRIMARY KEY (`id`),
    696. 

  696.   UNIQUE KEY `code` (`code`) USING BTREE
    697. 

  697. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='礼包码表';
    698. 

  698. 

  699. -- ----------------------------
    700. 

  700. -- Records of gift_code
    701. 

  701. -- ----------------------------
    702. 

  702. BEGIN;
    703. 

  703. COMMIT;
    704. 

  704. 

  705. -- ----------------------------
    706. 

  706. -- Table structure for gift_code_cfg
    707. 

  707. -- ----------------------------
    708. 

  708. DROP TABLE IF EXISTS `gift_code_cfg`;
    709. 

  709. CREATE TABLE `gift_code_cfg` (
    710. 

  710.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    711. 

  711.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    712. 

  712.   `id` int(11) NOT NULL COMMENT '礼包ID',
    713. 

  713.   `name` varchar(255) DEFAULT '' COMMENT '礼包名字',
    714. 

  714.   PRIMARY KEY (`id`)
    715. 

  715. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='兑换码礼包配置';
    716. 

  716. 

  717. -- ----------------------------
    718. 

  718. -- Records of gift_code_cfg
    719. 

  719. -- ----------------------------
    720. 

  720. BEGIN;
    721. 

  721. COMMIT;
    722. 

  722. 

  723. -- ----------------------------
    724. 

  724. -- Table structure for gift_code_share_log
    725. 

  725. -- ----------------------------
    726. 

  726. DROP TABLE IF EXISTS `gift_code_share_log`;
    727. 

  727. CREATE TABLE `gift_code_share_log` (
    728. 

  728.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    729. 

  729.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    730. 

  730.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
    731. 

  731.   `code` varchar(255) DEFAULT '' COMMENT '礼包码',
    732. 

  732.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    733. 

  733.   `player_name` varchar(255) DEFAULT '' COMMENT '玩家名称',
    734. 

  734.   PRIMARY KEY (`id`)
    735. 

  735. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='共享礼包码使用情况表';
    736. 

  736. 

  737. -- ----------------------------
    738. 

  738. -- Records of gift_code_share_log
    739. 

  739. -- ----------------------------
    740. 

  740. BEGIN;
    741. 

  741. COMMIT;
    742. 

  742. 

  743. -- ----------------------------
    744. 

  744. -- Table structure for god_finger
    745. 

  745. -- ----------------------------
    746. 

  746. DROP TABLE IF EXISTS `god_finger`;
    747. 

  747. CREATE TABLE `god_finger` (
    748. 

  748.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    749. 

  749.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    750. 

  750.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    751. 

  751.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    752. 

  752.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    753. 

  753.   `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
    754. 

  754.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    755. 

  755.   `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    756. 

  756.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    757. 

  757.   `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
    758. 

  758.   `nick` varchar(255) DEFAULT '' COMMENT '玩家昵称',
    759. 

  759.   `remark` varchar(255) DEFAULT '' COMMENT '备注',
    760. 

  760.   `money` bigint(20) DEFAULT '0' COMMENT '每日金额',
    761. 

  761.   `user_id` bigint(20) DEFAULT '0' COMMENT '添加金手指的用户',
    762. 

  762.   `user_name` varchar(255) DEFAULT '' COMMENT '添加金手指的用户',
    763. 

  763.   PRIMARY KEY (`id`)
    764. 

  764. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='金手指表';
    765. 

  765. 

  766. -- ----------------------------
    767. 

  767. -- Records of god_finger
    768. 

  768. -- ----------------------------
    769. 

  769. BEGIN;
    770. 

  770. COMMIT;
    771. 

  771. 

  772. -- ----------------------------
    773. 

  773. -- Table structure for item_cfg
    774. 

  774. -- ----------------------------
    775. 

  775. DROP TABLE IF EXISTS `item_cfg`;
    776. 

  776. CREATE TABLE `item_cfg` (
    777. 

  777.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    778. 

  778.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    779. 

  779.   `id` int(11) NOT NULL COMMENT '道具ID',
    780. 

  780.   `name` varchar(255) DEFAULT '' COMMENT '道具名',
    781. 

  781.   PRIMARY KEY (`id`)
    782. 

  782. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='道具配置';
    783. 

  783. 

  784. -- ----------------------------
    785. 

  785. -- Records of item_cfg
    786. 

  786. -- ----------------------------
    787. 

  787. BEGIN;
    788. 

  788. COMMIT;
    789. 

  789. 

  790. -- ----------------------------
    791. 

  791. -- Table structure for mail_setting
    792. 

  792. -- ----------------------------
    793. 

  793. DROP TABLE IF EXISTS `mail_setting`;
    794. 

  794. CREATE TABLE `mail_setting` (
    795. 

  795.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    796. 

  796.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    797. 

  797.   `id` bigint(20) NOT NULL COMMENT 'ID',
    798. 

  798.   `protocol` varchar(255) DEFAULT '' COMMENT '邮件协议',
    799. 

  799.   `host` varchar(255) DEFAULT '' COMMENT '邮箱系统服务器地址',
    800. 

  800.   `port` int(11) DEFAULT '0' COMMENT '端口',
    801. 

  801.   `account` varchar(255) DEFAULT '' COMMENT '发件人邮箱地址',
    802. 

  802.   `auth_code` varchar(255) DEFAULT '' COMMENT '发件人邮箱授权码',
    803. 

  803.   `client_master_mail` varchar(255) DEFAULT '' COMMENT '客户端管理员邮箱地址',
    804. 

  804.   `server_master_mail` varchar(255) DEFAULT '' COMMENT '服务端管理员邮箱地址',
    805. 

  805.   PRIMARY KEY (`id`)
    806. 

  806. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='后台邮箱发送配置';
    807. 

  807. 

  808. -- ----------------------------
    809. 

  809. -- Records of mail_setting
    810. 

  810. -- ----------------------------
    811. 

  811. BEGIN;
    812. 

  812. 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');
    813. 

  813. COMMIT;
    814. 

  814. 

  815. -- ----------------------------
    816. 

  816. -- Table structure for mail_system
    817. 

  817. -- ----------------------------
    818. 

  818. DROP TABLE IF EXISTS `mail_system`;
    819. 

  819. CREATE TABLE `mail_system` (
    820. 

  820.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    821. 

  821.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    822. 

  822.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    823. 

  823.   `user_id` bigint(20) DEFAULT '0' COMMENT '创建邮件的用户',
    824. 

  824.   `user_name` varchar(255) DEFAULT '' COMMENT '创建邮件的用户',
    825. 

  825.   `title` varchar(255) DEFAULT '' COMMENT '标题',
    826. 

  826.   `content` text COMMENT '内容',
    827. 

  827.   `rewards` varchar(5000) DEFAULT '' COMMENT '奖励',
    828. 

  828.   `type` int(11) DEFAULT '0' COMMENT '邮件类型，1全服邮件，2玩家邮件',
    829. 

  829.   `server_uids` text COMMENT '服务器唯一ID集合',
    830. 

  830.   `send_server_uids` text COMMENT '已发送的服务器唯一ID集合',
    831. 

  831.   `delete_server_uids` text COMMENT '已发送删除的服务器唯一ID集合',
    832. 

  832.   `pids` text COMMENT '玩家ID集合，分号分隔',
    833. 

  833.   `player_level` int(11) DEFAULT '0' COMMENT '收到邮件的玩家等级限制',
    834. 

  834.   `status` int(11) DEFAULT '0' COMMENT '邮件审核状态，0未审核，1审核通过，2审核不通过，3通知删除',
    835. 

  835.   `check_user_id` bigint(20) DEFAULT '0' COMMENT '审核用户ID',
    836. 

  836.   `check_user_name` varchar(255) DEFAULT '' COMMENT '审核用户',
    837. 

  837.   PRIMARY KEY (`id`)
    838. 

  838. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件表';
    839. 

  839. 

  840. -- ----------------------------
    841. 

  841. -- Records of mail_system
    842. 

  842. -- ----------------------------
    843. 

  843. BEGIN;
    844. 

  844. COMMIT;
    845. 

  845. 

  846. -- ----------------------------
    847. 

  847. -- Table structure for mail_system_result
    848. 

  848. -- ----------------------------
    849. 

  849. DROP TABLE IF EXISTS `mail_system_result`;
    850. 

  850. CREATE TABLE `mail_system_result` (
    851. 

  851.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    852. 

  852.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    853. 

  853.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
    854. 

  854.   `mail_id` bigint(20) DEFAULT '0' COMMENT '系统邮件ID',
    855. 

  855.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器ID',
    856. 

  856.   `server_id` int(11) DEFAULT '0' COMMENT '服务器名字',
    857. 

  857.   `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    858. 

  858.   `type_text` varchar(255) DEFAULT '' COMMENT '结果类型',
    859. 

  859.   `status` int(11) DEFAULT '0' COMMENT '处理状态，0未处理，1成功，2失败',
    860. 

  860.   `message` varchar(255) DEFAULT '' COMMENT '处理信息',
    861. 

  861.   PRIMARY KEY (`id`)
    862. 

  862. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件发送回执表';
    863. 

  863. 

  864. -- ----------------------------
    865. 

  865. -- Records of mail_system_result
    866. 

  866. -- ----------------------------
    867. 

  867. BEGIN;
    868. 

  868. COMMIT;
    869. 

  869. 

  870. -- ----------------------------
    871. 

  871. -- Table structure for menu1_system
    872. 

  872. -- ----------------------------
    873. 

  873. DROP TABLE IF EXISTS `menu1_system`;
    874. 

  874. CREATE TABLE `menu1_system` (
    875. 

  875.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    876. 

  876.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    877. 

  877.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    878. 

  878.   `title` varchar(255) DEFAULT '' COMMENT '系统名字',
    879. 

  879.   `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
    880. 

  880.   `icon` varchar(255) DEFAULT '' COMMENT '图标',
    881. 

  881.   `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
    882. 

  882.   `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
    883. 

  883.   `component` varchar(255) DEFAULT '' COMMENT '组件',
    884. 

  884.   PRIMARY KEY (`id`)
    885. 

  885. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单，系统菜单>模块菜单>功能菜单';
    886. 

  886. 

  887. -- ----------------------------
    888. 

  888. -- Records of menu1_system
    889. 

  889. -- ----------------------------
    890. 

  890. BEGIN;
    891. 

  891. 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');
    892. 

  892. 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');
    893. 

  893. COMMIT;
    894. 

  894. 

  895. -- ----------------------------
    896. 

  896. -- Table structure for menu2_module
    897. 

  897. -- ----------------------------
    898. 

  898. DROP TABLE IF EXISTS `menu2_module`;
    899. 

  899. CREATE TABLE `menu2_module` (
    900. 

  900.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    901. 

  901.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    902. 

  902.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    903. 

  903.   `system_id` bigint(20) DEFAULT '0' COMMENT '所属的系统菜单ID',
    904. 

  904.   `title` varchar(255) DEFAULT '' COMMENT '模块名字',
    905. 

  905.   `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
    906. 

  906.   `icon` varchar(255) DEFAULT '' COMMENT '图标',
    907. 

  907.   `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
    908. 

  908.   `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
    909. 

  909.   `component` varchar(255) DEFAULT '' COMMENT '组件',
    910. 

  910.   PRIMARY KEY (`id`)
    911. 

  911. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='模块菜单，导航区的分类菜单';
    912. 

  912. 

  913. -- ----------------------------
    914. 

  914. -- Records of menu2_module
    915. 

  915. -- ----------------------------
    916. 

  916. BEGIN;
    917. 

  917. 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');
    918. 

  918. 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');
    919. 

  919. 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');
    920. 

  920. 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');
    921. 

  921. 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');
    922. 

  922. 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');
    923. 

  923. 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');
    924. 

  924. 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');
    925. 

  925. 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');
    926. 

  926. 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');
    927. 

  927. COMMIT;
    928. 

  928. 

  929. -- ----------------------------
    930. 

  930. -- Table structure for menu3_function
    931. 

  931. -- ----------------------------
    932. 

  932. DROP TABLE IF EXISTS `menu3_function`;
    933. 

  933. CREATE TABLE `menu3_function` (
    934. 

  934.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    935. 

  935.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    936. 

  936.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    937. 

  937.   `module_id` bigint(20) DEFAULT '0' COMMENT '所属的模块菜单ID',
    938. 

  938.   `title` varchar(255) DEFAULT '' COMMENT '功能名字',
    939. 

  939.   `sort` bigint(20) DEFAULT '0' COMMENT '排序位置',
    940. 

  940.   `icon` varchar(255) DEFAULT '' COMMENT '图标',
    941. 

  941.   `route_name` varchar(255) DEFAULT '' COMMENT '路由名字',
    942. 

  942.   `route_path` varchar(255) DEFAULT '' COMMENT '路由路径',
    943. 

  943.   `auth_clazz` varchar(255) DEFAULT '' COMMENT '权限验证归属类',
    944. 

  944.   PRIMARY KEY (`id`)
    945. 

  945. ) ENGINE=InnoDB AUTO_INCREMENT=100000065 DEFAULT CHARSET=utf8mb4 COMMENT='功能菜单，具体的业务功能菜单';
    946. 

  946. 

  947. -- ----------------------------
    948. 

  948. -- Records of menu3_function
    949. 

  949. -- ----------------------------
    950. 

  950. BEGIN;
    951. 

  951. 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');
    952. 

  952. 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');
    953. 

  953. 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');
    954. 

  954. 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');
    955. 

  955. 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');
    956. 

  956. 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');
    957. 

  957. 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');
    958. 

  958. 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');
    959. 

  959. 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');
    960. 

  960. 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');
    961. 

  961. 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');
    962. 

  962. 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');
    963. 

  963. 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');
    964. 

  964. 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');
    965. 

  965. 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');
    966. 

  966. 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');
    967. 

  967. 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');
    968. 

  968. 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');
    969. 

  969. 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');
    970. 

  970. 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');
    971. 

  971. 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');
    972. 

  972. 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');
    973. 

  973. 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');
    974. 

  974. 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');
    975. 

  975. 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');
    976. 

  976. 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');
    977. 

  977. 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');
    978. 

  978. 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');
    979. 

  979. 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');
    980. 

  980. 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');
    981. 

  981. 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');
    982. 

  982. 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');
    983. 

  983. 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');
    984. 

  984. 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');
    985. 

  985. 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');
    986. 

  986. 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');
    987. 

  987. 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');
    988. 

  988. 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');
    989. 

  989. 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');
    990. 

  990. 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');
    991. 

  991. 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');
    992. 

  992. 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');
    993. 

  993. 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');
    994. 

  994. 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');
    995. 

  995. 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');
    996. 

  996. 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');
    997. 

  997. 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');
    998. 

  998. 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');
    999. 

  999. 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');
    1000. 

  1000. 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');
    1001. 

  1001. 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');
    1002. 

  1002. 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');
    1003. 

  1003. 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');
    1004. 

  1004. 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');
    1005. 

  1005. 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');
    1006. 

  1006. 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');
    1007. 

  1007. 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');
    1008. 

  1008. 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');
    1009. 

  1009. 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');
    1010. 

  1010. 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');
    1011. 

  1011. 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');
    1012. 

  1012. 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');
    1013. 

  1013. 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');
    1014. 

  1014. 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');
    1015. 

  1015. COMMIT;
    1016. 

  1016. 

  1017. -- ----------------------------
    1018. 

  1018. -- Table structure for player
    1019. 

  1019. -- ----------------------------
    1020. 

  1020. DROP TABLE IF EXISTS `player`;
    1021. 

  1021. CREATE TABLE `player` (
    1022. 

  1022.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1023. 

  1023.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1024. 

  1024.   `id` bigint(20) NOT NULL COMMENT '玩家ID，全平台唯一',
    1025. 

  1025.   `platform_id` bigint(20) DEFAULT '0' COMMENT '平台ID',
    1026. 

  1026.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1027. 

  1027.   `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
    1028. 

  1028.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    1029. 

  1029.   `nick` varchar(255) DEFAULT '' COMMENT '昵称',
    1030. 

  1030.   `head` varchar(255) DEFAULT '' COMMENT '头像',
    1031. 

  1031.   `sex` int(11) DEFAULT '0' COMMENT '性别，0无性别，1男，2女',
    1032. 

  1032.   `level` int(11) DEFAULT '0' COMMENT '等级',
    1033. 

  1033.   `gold` bigint(20) DEFAULT '0' COMMENT '金币',
    1034. 

  1034.   `diamond` bigint(20) DEFAULT '0' COMMENT '钻石',
    1035. 

  1035.   `fighting` bigint(20) DEFAULT '0' COMMENT '战力',
    1036. 

  1036.   `recharge` bigint(20) DEFAULT '0' COMMENT '充值金额',
    1037. 

  1037.   `online` char(5) DEFAULT 'false' COMMENT '是否在线',
    1038. 

  1038.   `daily_online` bigint(20) DEFAULT '0' COMMENT '今日在线时长',
    1039. 

  1039.   `born_time` datetime DEFAULT NULL COMMENT '创号时间',
    1040. 

  1040.   `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
    1041. 

  1041.   PRIMARY KEY (`id`),
    1042. 

  1042.   KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
    1043. 

  1043. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家信息表';
    1044. 

  1044. 

  1045. -- ----------------------------
    1046. 

  1046. -- Records of player
    1047. 

  1047. -- ----------------------------
    1048. 

  1048. BEGIN;
    1049. 

  1049. 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');
    1050. 

  1050. 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');
    1051. 

  1051. COMMIT;
    1052. 

  1052. 

  1053. -- ----------------------------
    1054. 

  1054. -- Table structure for player_ltv
    1055. 

  1055. -- ----------------------------
    1056. 

  1056. DROP TABLE IF EXISTS `player_ltv`;
    1057. 

  1057. CREATE TABLE `player_ltv` (
    1058. 

  1058.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1059. 

  1059.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1060. 

  1060.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1061. 

  1061.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1062. 

  1062.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
    1063. 

  1063.   `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
    1064. 

  1064.   `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
    1065. 

  1065.   `money` bigint(20) DEFAULT '0' COMMENT '总支付金额，单位分',
    1066. 

  1066.   `player_count` int(11) DEFAULT '0' COMMENT '创号玩家数量',
    1067. 

  1067.   PRIMARY KEY (`id`),
    1068. 

  1068.   UNIQUE KEY `channelid_born_daycount` (`channel_id`,`born`,`day_count`) USING BTREE
    1069. 

  1069. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家生命周期价值LTV表';
    1070. 

  1070. 

  1071. -- ----------------------------
    1072. 

  1072. -- Records of player_ltv
    1073. 

  1073. -- ----------------------------
    1074. 

  1074. BEGIN;
    1075. 

  1075. COMMIT;
    1076. 

  1076. 

  1077. -- ----------------------------
    1078. 

  1078. -- Table structure for player_pay_remain
    1079. 

  1079. -- ----------------------------
    1080. 

  1080. DROP TABLE IF EXISTS `player_pay_remain`;
    1081. 

  1081. CREATE TABLE `player_pay_remain` (
    1082. 

  1082.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1083. 

  1083.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1084. 

  1084.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1085. 

  1085.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1086. 

  1086.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
    1087. 

  1087.   `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
    1088. 

  1088.   `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
    1089. 

  1089.   `player` int(11) DEFAULT '0' COMMENT '人数',
    1090. 

  1090.   PRIMARY KEY (`id`),
    1091. 

  1091.   UNIQUE KEY `csbd` (`channel_id`,`server_uid`,`born`,`day_count`) USING BTREE
    1092. 

  1092. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家付费留存表';
    1093. 

  1093. 

  1094. -- ----------------------------
    1095. 

  1095. -- Records of player_pay_remain
    1096. 

  1096. -- ----------------------------
    1097. 

  1097. BEGIN;
    1098. 

  1098. COMMIT;
    1099. 

  1099. 

  1100. -- ----------------------------
    1101. 

  1101. -- Table structure for player_remain
    1102. 

  1102. -- ----------------------------
    1103. 

  1103. DROP TABLE IF EXISTS `player_remain`;
    1104. 

  1104. CREATE TABLE `player_remain` (
    1105. 

  1105.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1106. 

  1106.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1107. 

  1107.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1108. 

  1108.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1109. 

  1109.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
    1110. 

  1110.   `born` varchar(255) DEFAULT '' COMMENT '创号日期，yyyyMMdd',
    1111. 

  1111.   `day_count` int(11) DEFAULT '0' COMMENT '距离创号时间的天数',
    1112. 

  1112.   `player` int(11) DEFAULT '0' COMMENT '人数',
    1113. 

  1113.   PRIMARY KEY (`id`),
    1114. 

  1114.   UNIQUE KEY `csbd` (`channel_id`,`server_uid`,`born`,`day_count`) USING BTREE
    1115. 

  1115. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家留存表';
    1116. 

  1116. 

  1117. -- ----------------------------
    1118. 

  1118. -- Records of player_remain
    1119. 

  1119. -- ----------------------------
    1120. 

  1120. BEGIN;
    1121. 

  1121. COMMIT;
    1122. 

  1122. 

  1123. -- ----------------------------
    1124. 

  1124. -- Table structure for recharge_callback
    1125. 

  1125. -- ----------------------------
    1126. 

  1126. DROP TABLE IF EXISTS `recharge_callback`;
    1127. 

  1127. CREATE TABLE `recharge_callback` (
    1128. 

  1128.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1129. 

  1129.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1130. 

  1130.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1131. 

  1131.   `platform_id` bigint(20) DEFAULT '0' COMMENT '平台ID',
    1132. 

  1132.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1133. 

  1133.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    1134. 

  1134.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    1135. 

  1135.   `nick` varchar(255) DEFAULT '' COMMENT '玩家名字',
    1136. 

  1136.   `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
    1137. 

  1137.   `level` int(11) DEFAULT '0' COMMENT '下单等级',
    1138. 

  1138.   `sdk_order_id` varchar(255) DEFAULT '' COMMENT '渠道订单ID',
    1139. 

  1139.   `game_order_id` varchar(255) DEFAULT '' COMMENT '游戏服的订单ID',
    1140. 

  1140.   `money` bigint(20) DEFAULT '0' COMMENT '支付金额',
    1141. 

  1141.   `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
    1142. 

  1142.   `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
    1143. 

  1143.   `give` int(11) DEFAULT '0' COMMENT '发货状态，0未处理，1发货成功，2发货失败',
    1144. 

  1144.   `remark` varchar(3000) DEFAULT '' COMMENT '备注',
    1145. 

  1145.   `remark_idx` int(11) DEFAULT '0' COMMENT '备注序号',
    1146. 

  1146.   `test` int(11) DEFAULT '0' COMMENT '是否测试订单，1是，0不是',
    1147. 

  1147.   `all_check` char(5) DEFAULT 'false' COMMENT '是否所有验证都通过',
    1148. 

  1148.   `sign` varchar(255) DEFAULT '' COMMENT '订单签名',
    1149. 

  1149.   `local_sign` varchar(255) DEFAULT '' COMMENT '本地订单签名',
    1150. 

  1150.   `extra_sign` varchar(255) DEFAULT '' COMMENT '扩展参数签名',
    1151. 

  1151.   `local_extra_sign` varchar(255) DEFAULT '' COMMENT '本地扩展参数签名',
    1152. 

  1152.   `remote_ip` varchar(255) DEFAULT '' COMMENT '请求的IP',
    1153. 

  1153.   `callback_data` text COMMENT '回调原数据',
    1154. 

  1154.   `game_response` varchar(255) DEFAULT '' COMMENT '游戏服的响应',
    1155. 

  1155.   PRIMARY KEY (`id`)
    1156. 

  1156. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='充值回调表';
    1157. 

  1157. 

  1158. -- ----------------------------
    1159. 

  1159. -- Records of recharge_callback
    1160. 

  1160. -- ----------------------------
    1161. 

  1161. BEGIN;
    1162. 

  1162. COMMIT;
    1163. 

  1163. 

  1164. -- ----------------------------
    1165. 

  1165. -- Table structure for recharge_one_date
    1166. 

  1166. -- ----------------------------
    1167. 

  1167. DROP TABLE IF EXISTS `recharge_one_date`;
    1168. 

  1168. CREATE TABLE `recharge_one_date` (
    1169. 

  1169.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1170. 

  1170.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1171. 

  1171.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1172. 

  1172.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1173. 

  1173.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名称',
    1174. 

  1174.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
    1175. 

  1175.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    1176. 

  1176.   `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    1177. 

  1177.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    1178. 

  1178.   `nick` varchar(255) DEFAULT '' COMMENT '玩家昵称',
    1179. 

  1179.   `date_str` varchar(255) DEFAULT '' COMMENT '日期yyyyMMdd',
    1180. 

  1180.   `total_pay` bigint(20) DEFAULT '0' COMMENT '当日总支付',
    1181. 

  1181.   `last_recharge_time` datetime DEFAULT NULL COMMENT '当日最后充值时间',
    1182. 

  1182.   PRIMARY KEY (`id`),
    1183. 

  1183.   UNIQUE KEY `channel_player_date` (`channel_id`,`player_id`,`date_str`) USING BTREE,
    1184. 

  1184.   KEY `channelid` (`channel_id`) USING BTREE
    1185. 

  1185. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家某一天的充值表';
    1186. 

  1186. 

  1187. -- ----------------------------
    1188. 

  1188. -- Records of recharge_one_date
    1189. 

  1189. -- ----------------------------
    1190. 

  1190. BEGIN;
    1191. 

  1191. COMMIT;
    1192. 

  1192. 

  1193. -- ----------------------------
    1194. 

  1194. -- Table structure for recharge_product_cfg
    1195. 

  1195. -- ----------------------------
    1196. 

  1196. DROP TABLE IF EXISTS `recharge_product_cfg`;
    1197. 

  1197. CREATE TABLE `recharge_product_cfg` (
    1198. 

  1198.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1199. 

  1199.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1200. 

  1200.   `id` int(11) NOT NULL COMMENT '商品ID',
    1201. 

  1201.   `name` varchar(255) DEFAULT '' COMMENT '商品名',
    1202. 

  1202.   `describe` varchar(255) DEFAULT '' COMMENT '商品描述',
    1203. 

  1203.   `money` bigint(20) DEFAULT '0' COMMENT '金额，单位分',
    1204. 

  1204.   PRIMARY KEY (`id`)
    1205. 

  1205. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商品配置';
    1206. 

  1206. 

  1207. -- ----------------------------
    1208. 

  1208. -- Records of recharge_product_cfg
    1209. 

  1209. -- ----------------------------
    1210. 

  1210. BEGIN;
    1211. 

  1211. COMMIT;
    1212. 

  1212. 

  1213. -- ----------------------------
    1214. 

  1214. -- Table structure for recharge_product_count
    1215. 

  1215. -- ----------------------------
    1216. 

  1216. DROP TABLE IF EXISTS `recharge_product_count`;
    1217. 

  1217. CREATE TABLE `recharge_product_count` (
    1218. 

  1218.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1219. 

  1219.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1220. 

  1220.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1221. 

  1221.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1222. 

  1222.   `product_id` int(11) DEFAULT '0' COMMENT '商品ID',
    1223. 

  1223.   `product_name` varchar(255) DEFAULT '' COMMENT '商品名字',
    1224. 

  1224.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    1225. 

  1225.   `pay_money` bigint(20) DEFAULT '0' COMMENT '支付金额',
    1226. 

  1226.   `callback_id` bigint(20) DEFAULT '0' COMMENT '回调ID',
    1227. 

  1227.   `server_uid` int(11) DEFAULT '0' COMMENT '服务器唯一ID',
    1228. 

  1228.   PRIMARY KEY (`id`),
    1229. 

  1229.   KEY `channelid` (`channel_id`) USING BTREE
    1230. 

  1230. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='充值商品统计表';
    1231. 

  1231. 

  1232. -- ----------------------------
    1233. 

  1233. -- Records of recharge_product_count
    1234. 

  1234. -- ----------------------------
    1235. 

  1235. BEGIN;
    1236. 

  1236. COMMIT;
    1237. 

  1237. 

  1238. -- ----------------------------
    1239. 

  1239. -- Table structure for recharge_today
    1240. 

  1240. -- ----------------------------
    1241. 

  1241. DROP TABLE IF EXISTS `recharge_today`;
    1242. 

  1242. CREATE TABLE `recharge_today` (
    1243. 

  1243.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1244. 

  1244.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1245. 

  1245.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1246. 

  1246.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1247. 

  1247.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    1248. 

  1248.   `money` bigint(20) DEFAULT '0' COMMENT '支付金额',
    1249. 

  1249.   `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
    1250. 

  1250.   `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
    1251. 

  1251.   PRIMARY KEY (`id`)
    1252. 

  1252. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='今日充值表';
    1253. 

  1253. 

  1254. -- ----------------------------
    1255. 

  1255. -- Records of recharge_today
    1256. 

  1256. -- ----------------------------
    1257. 

  1257. BEGIN;
    1258. 

  1258. COMMIT;
    1259. 

  1259. 

  1260. -- ----------------------------
    1261. 

  1261. -- Table structure for recharge_virtual
    1262. 

  1262. -- ----------------------------
    1263. 

  1263. DROP TABLE IF EXISTS `recharge_virtual`;
    1264. 

  1264. CREATE TABLE `recharge_virtual` (
    1265. 

  1265.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1266. 

  1266.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1267. 

  1267.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据ID',
    1268. 

  1268.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1269. 

  1269.   `server_uid` bigint(20) DEFAULT '0' COMMENT '服务器唯一ID',
    1270. 

  1270.   `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
    1271. 

  1271.   `server_name` varchar(255) DEFAULT '' COMMENT '服务器名字',
    1272. 

  1272.   `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
    1273. 

  1273.   `nick` varchar(255) DEFAULT '' COMMENT '玩家名字',
    1274. 

  1274.   `open_id` varchar(255) DEFAULT '' COMMENT '账号ID',
    1275. 

  1275.   `product_id` int(11) DEFAULT '0' COMMENT '充值商品ID',
    1276. 

  1276.   `product_name` varchar(255) DEFAULT '' COMMENT '充值商品名字',
    1277. 

  1277.   `money` bigint(20) DEFAULT '0' COMMENT '金额',
    1278. 

  1278.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作员ID',
    1279. 

  1279.   `user_name` varchar(255) DEFAULT '' COMMENT '操作员名称',
    1280. 

  1280.   `status` int(11) DEFAULT '0' COMMENT '充值状态，0未处理，1成功，2失败',
    1281. 

  1281.   `remark` varchar(255) DEFAULT '' COMMENT '备注',
    1282. 

  1282.   PRIMARY KEY (`id`)
    1283. 

  1283. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='虚拟充值（内部充值）表';
    1284. 

  1284. 

  1285. -- ----------------------------
    1286. 

  1286. -- Records of recharge_virtual
    1287. 

  1287. -- ----------------------------
    1288. 

  1288. BEGIN;
    1289. 

  1289. COMMIT;
    1290. 

  1290. 

  1291. -- ----------------------------
    1292. 

  1292. -- Table structure for system_counter
    1293. 

  1293. -- ----------------------------
    1294. 

  1294. DROP TABLE IF EXISTS `system_counter`;
    1295. 

  1295. CREATE TABLE `system_counter` (
    1296. 

  1296.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1297. 

  1297.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1298. 

  1298.   `id` bigint(20) NOT NULL COMMENT '数据ID',
    1299. 

  1299.   `remain_time` bigint(20) DEFAULT '0' COMMENT '留存统计时间',
    1300. 

  1300.   `pay_remain_time` bigint(20) DEFAULT '0' COMMENT '付费留存统计时间',
    1301. 

  1301.   `ltv_time` bigint(20) DEFAULT '0' COMMENT 'LTV统计时间',
    1302. 

  1302.   `god_finger_time` bigint(20) DEFAULT '0' COMMENT '金手指发放时间',
    1303. 

  1303.   PRIMARY KEY (`id`)
    1304. 

  1304. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统数据统计时间表';
    1305. 

  1305. 

  1306. -- ----------------------------
    1307. 

  1307. -- Records of system_counter
    1308. 

  1308. -- ----------------------------
    1309. 

  1309. BEGIN;
    1310. 

  1310. 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);
    1311. 

  1311. COMMIT;
    1312. 

  1312. 

  1313. -- ----------------------------
    1314. 

  1314. -- Table structure for user
    1315. 

  1315. -- ----------------------------
    1316. 

  1316. DROP TABLE IF EXISTS `user`;
    1317. 

  1317. CREATE TABLE `user` (
    1318. 

  1318.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1319. 

  1319.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1320. 

  1320.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    1321. 

  1321.   `name` varchar(255) DEFAULT '' COMMENT '用户名',
    1322. 

  1322.   `password` varchar(255) DEFAULT '' COMMENT '密码',
    1323. 

  1323.   `level` int(11) DEFAULT '0' COMMENT '用户级别，高级别用户创建低级别用户，数字越小级别越高',
    1324. 

  1324.   `super_user` char(5) DEFAULT 'false' COMMENT '是否超级管理员，0不是，1是',
    1325. 

  1325.   `up_user_id` bigint(20) DEFAULT '0' COMMENT '上级用户ID',
    1326. 

  1326.   `phone` varchar(255) DEFAULT '' COMMENT '手机号码',
    1327. 

  1327.   `mail_address` varchar(255) DEFAULT '' COMMENT '邮箱地址',
    1328. 

  1328.   `usable` char(5) DEFAULT 'false' COMMENT '是否可用',
    1329. 

  1329.   `can_read_sensitive` char(5) DEFAULT 'false' COMMENT '是否可查看敏感信息',
    1330. 

  1330.   PRIMARY KEY (`id`),
    1331. 

  1331.   UNIQUE KEY `name_index` (`name`) USING BTREE
    1332. 

  1332. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
    1333. 

  1333. 

  1334. -- ----------------------------
    1335. 

  1335. -- Records of user
    1336. 

  1336. -- ----------------------------
    1337. 

  1337. BEGIN;
    1338. 

  1338. 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');
    1339. 

  1339. COMMIT;
    1340. 

  1340. 

  1341. -- ----------------------------
    1342. 

  1342. -- Table structure for user_channel
    1343. 

  1343. -- ----------------------------
    1344. 

  1344. DROP TABLE IF EXISTS `user_channel`;
    1345. 

  1345. CREATE TABLE `user_channel` (
    1346. 

  1346.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1347. 

  1347.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1348. 

  1348.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    1349. 

  1349.   `user_id` bigint(20) DEFAULT '0' COMMENT '用户ID',
    1350. 

  1350.   `user_name` varchar(255) DEFAULT '' COMMENT '用户名称',
    1351. 

  1351.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1352. 

  1352.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名称',
    1353. 

  1353.   `grant_user_id` bigint(20) DEFAULT '0' COMMENT '授权的用户ID',
    1354. 

  1354.   `grant_user_name` varchar(255) DEFAULT '' COMMENT '授权的用户名称',
    1355. 

  1355.   PRIMARY KEY (`id`),
    1356. 

  1356.   UNIQUE KEY `userId_channelId` (`user_id`,`channel_id`) USING BTREE
    1357. 

  1357. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户渠道表';
    1358. 

  1358. 

  1359. -- ----------------------------
    1360. 

  1360. -- Records of user_channel
    1361. 

  1361. -- ----------------------------
    1362. 

  1362. BEGIN;
    1363. 

  1363. COMMIT;
    1364. 

  1364. 

  1365. -- ----------------------------
    1366. 

  1366. -- Table structure for user_function
    1367. 

  1367. -- ----------------------------
    1368. 

  1368. DROP TABLE IF EXISTS `user_function`;
    1369. 

  1369. CREATE TABLE `user_function` (
    1370. 

  1370.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1371. 

  1371.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1372. 

  1372.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    1373. 

  1373.   `user_id` bigint(20) DEFAULT '0' COMMENT '用户ID',
    1374. 

  1374.   `user_name` varchar(255) DEFAULT '' COMMENT '用户名称',
    1375. 

  1375.   `function_id` bigint(20) DEFAULT '0' COMMENT '功能菜单ID',
    1376. 

  1376.   `function_name` varchar(255) DEFAULT '' COMMENT '功能菜单名字',
    1377. 

  1377.   `writee` char(5) DEFAULT 'false' COMMENT '是否具有写权限',
    1378. 

  1378.   `grant_user_id` bigint(20) DEFAULT '0' COMMENT '授权的用户ID',
    1379. 

  1379.   `grant_user_name` varchar(255) DEFAULT '' COMMENT '授权的用户名称',
    1380. 

  1380.   PRIMARY KEY (`id`),
    1381. 

  1381.   UNIQUE KEY `unique_uf` (`user_id`,`function_id`) USING BTREE
    1382. 

  1382. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='用户功能权限表';
    1383. 

  1383. 

  1384. -- ----------------------------
    1385. 

  1385. -- Records of user_function
    1386. 

  1386. -- ----------------------------
    1387. 

  1387. BEGIN;
    1388. 

  1388. COMMIT;
    1389. 

  1389. 

  1390. -- ----------------------------
    1391. 

  1391. -- Table structure for wabo_setting
    1392. 

  1392. -- ----------------------------
    1393. 

  1393. DROP TABLE IF EXISTS `wabo_setting`;
    1394. 

  1394. CREATE TABLE `wabo_setting` (
    1395. 

  1395.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1396. 

  1396.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1397. 

  1397.   `id` bigint(20) NOT NULL COMMENT '数据ID',
    1398. 

  1398.   `game_id` varchar(255) DEFAULT '' COMMENT '渠道参数游戏ID',
    1399. 

  1399.   `game_key` varchar(255) DEFAULT '' COMMENT '游戏密钥',
    1400. 

  1400.   `login_url` varchar(255) DEFAULT '' COMMENT '验证登录URL',
    1401. 

  1401.   PRIMARY KEY (`id`)
    1402. 

  1402. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='wabo渠道参数设置';
    1403. 

  1403. 

  1404. -- ----------------------------
    1405. 

  1405. -- Records of wabo_setting
    1406. 

  1406. -- ----------------------------
    1407. 

  1407. BEGIN;
    1408. 

  1408. 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');
    1409. 

  1409. COMMIT;
    1410. 

  1410. 

  1411. -- ----------------------------
    1412. 

  1412. -- Table structure for white_list
    1413. 

  1413. -- ----------------------------
    1414. 

  1414. DROP TABLE IF EXISTS `white_list`;
    1415. 

  1415. CREATE TABLE `white_list` (
    1416. 

  1416.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1417. 

  1417.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1418. 

  1418.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
    1419. 

  1419.   `channel_id` bigint(20) DEFAULT '0' COMMENT '渠道ID',
    1420. 

  1420.   `channel_name` varchar(255) DEFAULT '' COMMENT '渠道名字',
    1421. 

  1421.   `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
    1422. 

  1422.   `user_id` bigint(20) DEFAULT '0' COMMENT '操作人ID',
    1423. 

  1423.   `user_name` varchar(255) DEFAULT '' COMMENT '操作人名字',
    1424. 

  1424.   `remark` varchar(255) DEFAULT '' COMMENT '备注',
    1425. 

  1425.   PRIMARY KEY (`id`),
    1426. 

  1426.   UNIQUE KEY `channelid_openid` (`channel_id`,`open_id`) USING BTREE
    1427. 

  1427. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='白名单表';
    1428. 

  1428. 

  1429. -- ----------------------------
    1430. 

  1430. -- Records of white_list
    1431. 

  1431. -- ----------------------------
    1432. 

  1432. BEGIN;
    1433. 

  1433. COMMIT;
    1434. 

  1434. 

  1435. -- ----------------------------
    1436. 

  1436. -- Table structure for yile_setting
    1437. 

  1437. -- ----------------------------
    1438. 

  1438. DROP TABLE IF EXISTS `yile_setting`;
    1439. 

  1439. CREATE TABLE `yile_setting` (
    1440. 

  1440.   `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
    1441. 

  1441.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    1442. 

  1442.   `id` bigint(20) NOT NULL COMMENT '数据ID',
    1443. 

  1443.   `platform_id` bigint(20) DEFAULT '0' COMMENT '益乐平台数据ID',
    1444. 

  1444.   `game_id` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
    1445. 

  1445.   `product_key` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
    1446. 

  1446.   `charge_key` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
    1447. 

  1447.   `login_url` varchar(255) DEFAULT '' COMMENT '益乐平台数据ID',
    1448. 

  1448.   PRIMARY KEY (`id`)
    1449. 

  1449. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='益乐渠道参数设置';
    1450. 

  1450. 

  1451. -- ----------------------------
    1452. 

  1452. -- Records of yile_setting
    1453. 

  1453. -- ----------------------------
    1454. 

  1454. BEGIN;
    1455. 

  1455. 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');
    1456. 

  1456. COMMIT;
    1457. 

  1457. 

  1458. SET FOREIGN_KEY_CHECKS = 1;
    1459.