x1_1_log.sql 167 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 192.168.3.245
  4. Source Server Type : MySQL
  5. Source Server Version : 50727 (5.7.27)
  6. Source Host : 192.168.3.245:33061
  7. Source Schema : x1_4_log
  8. Target Server Type : MySQL
  9. Target Server Version : 50727 (5.7.27)
  10. File Encoding : 65001
  11. Date: 05/03/2025 09:32:31
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for achievement_point_log_202411
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `achievement_point_log_202411`;
  19. CREATE TABLE `achievement_point_log_202411` (
  20. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  21. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  22. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  23. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  24. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  25. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  26. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  27. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  28. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  29. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  30. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  31. `time` datetime DEFAULT NULL COMMENT '发生时间',
  32. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  33. PRIMARY KEY (`id`)
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='成就点数日志表';
  35. -- ----------------------------
  36. -- Records of achievement_point_log_202411
  37. -- ----------------------------
  38. BEGIN;
  39. COMMIT;
  40. -- ----------------------------
  41. -- Table structure for achievement_point_log_202502
  42. -- ----------------------------
  43. DROP TABLE IF EXISTS `achievement_point_log_202502`;
  44. CREATE TABLE `achievement_point_log_202502` (
  45. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  46. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  47. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  48. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  49. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  50. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  51. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  52. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  53. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  54. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  55. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  56. `time` datetime DEFAULT NULL COMMENT '发生时间',
  57. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  58. PRIMARY KEY (`id`)
  59. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='成就点数日志表';
  60. -- ----------------------------
  61. -- Records of achievement_point_log_202502
  62. -- ----------------------------
  63. BEGIN;
  64. COMMIT;
  65. -- ----------------------------
  66. -- Table structure for day_point_log_202411
  67. -- ----------------------------
  68. DROP TABLE IF EXISTS `day_point_log_202411`;
  69. CREATE TABLE `day_point_log_202411` (
  70. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  71. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  72. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  73. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  74. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  75. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  76. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  77. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  78. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  79. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  80. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  81. `time` datetime DEFAULT NULL COMMENT '发生时间',
  82. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  83. PRIMARY KEY (`id`)
  84. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日常活跃度日志表';
  85. -- ----------------------------
  86. -- Records of day_point_log_202411
  87. -- ----------------------------
  88. BEGIN;
  89. COMMIT;
  90. -- ----------------------------
  91. -- Table structure for day_point_log_202502
  92. -- ----------------------------
  93. DROP TABLE IF EXISTS `day_point_log_202502`;
  94. CREATE TABLE `day_point_log_202502` (
  95. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  96. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  97. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  98. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  99. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  100. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  101. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  102. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  103. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  104. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  105. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  106. `time` datetime DEFAULT NULL COMMENT '发生时间',
  107. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  108. PRIMARY KEY (`id`)
  109. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='日常活跃度日志表';
  110. -- ----------------------------
  111. -- Records of day_point_log_202502
  112. -- ----------------------------
  113. BEGIN;
  114. COMMIT;
  115. -- ----------------------------
  116. -- Table structure for diamond_log_202411
  117. -- ----------------------------
  118. DROP TABLE IF EXISTS `diamond_log_202411`;
  119. CREATE TABLE `diamond_log_202411` (
  120. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  121. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  122. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  123. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  124. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  125. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  126. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  127. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  128. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  129. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  130. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  131. `time` datetime DEFAULT NULL COMMENT '发生时间',
  132. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  133. PRIMARY KEY (`id`)
  134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='钻石日志表';
  135. -- ----------------------------
  136. -- Records of diamond_log_202411
  137. -- ----------------------------
  138. BEGIN;
  139. COMMIT;
  140. -- ----------------------------
  141. -- Table structure for diamond_log_202502
  142. -- ----------------------------
  143. DROP TABLE IF EXISTS `diamond_log_202502`;
  144. CREATE TABLE `diamond_log_202502` (
  145. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  146. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  147. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  148. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  149. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  150. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  151. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  152. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  153. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  154. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  155. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  156. `time` datetime DEFAULT NULL COMMENT '发生时间',
  157. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  158. PRIMARY KEY (`id`)
  159. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='钻石日志表';
  160. -- ----------------------------
  161. -- Records of diamond_log_202502
  162. -- ----------------------------
  163. BEGIN;
  164. COMMIT;
  165. -- ----------------------------
  166. -- Table structure for equip_log_202411
  167. -- ----------------------------
  168. DROP TABLE IF EXISTS `equip_log_202411`;
  169. CREATE TABLE `equip_log_202411` (
  170. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  171. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  172. `instance_id` bigint(20) DEFAULT '0' COMMENT '实物的ID',
  173. `instance_data` text COMMENT '实物的数据',
  174. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  175. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  176. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  177. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  178. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  179. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  180. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  181. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  182. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  183. `time` datetime DEFAULT NULL COMMENT '发生时间',
  184. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  185. PRIMARY KEY (`id`)
  186. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='装备日志表';
  187. -- ----------------------------
  188. -- Records of equip_log_202411
  189. -- ----------------------------
  190. BEGIN;
  191. COMMIT;
  192. -- ----------------------------
  193. -- Table structure for equip_log_202502
  194. -- ----------------------------
  195. DROP TABLE IF EXISTS `equip_log_202502`;
  196. CREATE TABLE `equip_log_202502` (
  197. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  198. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  199. `instance_id` bigint(20) DEFAULT '0' COMMENT '实物的ID',
  200. `instance_data` text COMMENT '实物的数据',
  201. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  202. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  203. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  204. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  205. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  206. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  207. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  208. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  209. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  210. `time` datetime DEFAULT NULL COMMENT '发生时间',
  211. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  212. PRIMARY KEY (`id`)
  213. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='装备日志表';
  214. -- ----------------------------
  215. -- Records of equip_log_202502
  216. -- ----------------------------
  217. BEGIN;
  218. COMMIT;
  219. -- ----------------------------
  220. -- Table structure for evil_catalog_log_202411
  221. -- ----------------------------
  222. DROP TABLE IF EXISTS `evil_catalog_log_202411`;
  223. CREATE TABLE `evil_catalog_log_202411` (
  224. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  225. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  226. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  227. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  228. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  229. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  230. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  231. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  232. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  233. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  234. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  235. `time` datetime DEFAULT NULL COMMENT '发生时间',
  236. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  237. PRIMARY KEY (`id`)
  238. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='妖录日志表';
  239. -- ----------------------------
  240. -- Records of evil_catalog_log_202411
  241. -- ----------------------------
  242. BEGIN;
  243. COMMIT;
  244. -- ----------------------------
  245. -- Table structure for evil_catalog_log_202502
  246. -- ----------------------------
  247. DROP TABLE IF EXISTS `evil_catalog_log_202502`;
  248. CREATE TABLE `evil_catalog_log_202502` (
  249. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  250. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  251. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  252. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  253. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  254. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  255. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  256. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  257. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  258. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  259. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  260. `time` datetime DEFAULT NULL COMMENT '发生时间',
  261. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  262. PRIMARY KEY (`id`)
  263. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='妖录日志表';
  264. -- ----------------------------
  265. -- Records of evil_catalog_log_202502
  266. -- ----------------------------
  267. BEGIN;
  268. COMMIT;
  269. -- ----------------------------
  270. -- Table structure for evil_speedup_log_202411
  271. -- ----------------------------
  272. DROP TABLE IF EXISTS `evil_speedup_log_202411`;
  273. CREATE TABLE `evil_speedup_log_202411` (
  274. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  275. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  276. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  277. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  278. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  279. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  280. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  281. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  282. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  283. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  284. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  285. `time` datetime DEFAULT NULL COMMENT '发生时间',
  286. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  287. PRIMARY KEY (`id`)
  288. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
  289. -- ----------------------------
  290. -- Records of evil_speedup_log_202411
  291. -- ----------------------------
  292. BEGIN;
  293. COMMIT;
  294. -- ----------------------------
  295. -- Table structure for evil_speedup_log_202502
  296. -- ----------------------------
  297. DROP TABLE IF EXISTS `evil_speedup_log_202502`;
  298. CREATE TABLE `evil_speedup_log_202502` (
  299. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  300. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  301. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  302. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  303. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  304. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  305. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  306. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  307. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  308. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  309. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  310. `time` datetime DEFAULT NULL COMMENT '发生时间',
  311. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  312. PRIMARY KEY (`id`)
  313. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
  314. -- ----------------------------
  315. -- Records of evil_speedup_log_202502
  316. -- ----------------------------
  317. BEGIN;
  318. COMMIT;
  319. -- ----------------------------
  320. -- Table structure for gold_log_202411
  321. -- ----------------------------
  322. DROP TABLE IF EXISTS `gold_log_202411`;
  323. CREATE TABLE `gold_log_202411` (
  324. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  325. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  326. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  327. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  328. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  329. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  330. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  331. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  332. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  333. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  334. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  335. `time` datetime DEFAULT NULL COMMENT '发生时间',
  336. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  337. PRIMARY KEY (`id`)
  338. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='金币日志表';
  339. -- ----------------------------
  340. -- Records of gold_log_202411
  341. -- ----------------------------
  342. BEGIN;
  343. INSERT INTO `gold_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:53', '2024-11-22 11:38:53', 100000001, 335879897874434, '方昊乾', 1, '金币', 10, 10, 400005, '完成主线任务', '2024-11-22 11:38:04', '');
  344. INSERT INTO `gold_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:53', '2024-11-22 11:38:53', 100000002, 335879897874434, '方昊乾', 1, '金币', 10, 20, 400005, '完成主线任务', '2024-11-22 11:38:11', '');
  345. COMMIT;
  346. -- ----------------------------
  347. -- Table structure for gold_log_202502
  348. -- ----------------------------
  349. DROP TABLE IF EXISTS `gold_log_202502`;
  350. CREATE TABLE `gold_log_202502` (
  351. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  352. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  353. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  354. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  355. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  356. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  357. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  358. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  359. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  360. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  361. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  362. `time` datetime DEFAULT NULL COMMENT '发生时间',
  363. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  364. PRIMARY KEY (`id`)
  365. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='金币日志表';
  366. -- ----------------------------
  367. -- Records of gold_log_202502
  368. -- ----------------------------
  369. BEGIN;
  370. COMMIT;
  371. -- ----------------------------
  372. -- Table structure for guide_dot
  373. -- ----------------------------
  374. DROP TABLE IF EXISTS `guide_dot`;
  375. CREATE TABLE `guide_dot` (
  376. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  377. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  378. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  379. `guide_id` int(11) DEFAULT '0' COMMENT '指引ID',
  380. `guide_name` varchar(255) DEFAULT '' COMMENT '指引名称',
  381. `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  382. `step` int(11) DEFAULT '0' COMMENT '步骤',
  383. PRIMARY KEY (`id`)
  384. ) ENGINE=InnoDB AUTO_INCREMENT=100000012 DEFAULT CHARSET=utf8mb4 COMMENT='引导打点表';
  385. -- ----------------------------
  386. -- Records of guide_dot
  387. -- ----------------------------
  388. BEGIN;
  389. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000001, 1, '进入游戏时,触发剧情对白', 335879897874434, 1);
  390. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000002, 1, '镜头移动到明月心处', 335879897874434, 2);
  391. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000003, 1, '对白完成,指引移动', 335879897874434, 3);
  392. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000004, 2, '杀完人参果,触发剧情对话', 335879897874434, 1);
  393. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000005, 2, '指引点击明月心的交互按钮', 335879897874434, 2);
  394. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000006, 2, '点击关闭明月心获得界面', 335879897874434, 3);
  395. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000007, 3, '指引点击完成任务', 335879897874434, 1);
  396. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000008, 4, '前方迷雾,触发剧情对白', 335879897874434, 1);
  397. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000009, 4, '引导点击迷雾交互按钮', 335879897874434, 2);
  398. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000010, 5, '指引点击完成任务', 335879897874434, 1);
  399. INSERT INTO `guide_dot` (`insert_time`, `update_time`, `id`, `guide_id`, `guide_name`, `player_id`, `step`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000011, 6, '接取解救雨师任务,引点击任务', 335879897874434, 1);
  400. COMMIT;
  401. -- ----------------------------
  402. -- Table structure for hero_fighting_log_202411
  403. -- ----------------------------
  404. DROP TABLE IF EXISTS `hero_fighting_log_202411`;
  405. CREATE TABLE `hero_fighting_log_202411` (
  406. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  407. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  408. `hero_id` bigint(20) DEFAULT '0' COMMENT '英雄ID',
  409. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  410. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  411. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  412. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  413. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  414. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  415. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  416. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  417. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  418. `time` datetime DEFAULT NULL COMMENT '发生时间',
  419. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  420. PRIMARY KEY (`id`)
  421. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='英雄战力变化日志表';
  422. -- ----------------------------
  423. -- Records of hero_fighting_log_202411
  424. -- ----------------------------
  425. BEGIN;
  426. COMMIT;
  427. -- ----------------------------
  428. -- Table structure for hero_fighting_log_202502
  429. -- ----------------------------
  430. DROP TABLE IF EXISTS `hero_fighting_log_202502`;
  431. CREATE TABLE `hero_fighting_log_202502` (
  432. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  433. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  434. `hero_id` bigint(20) DEFAULT '0' COMMENT '英雄ID',
  435. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  436. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  437. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  438. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  439. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  440. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  441. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  442. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  443. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  444. `time` datetime DEFAULT NULL COMMENT '发生时间',
  445. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  446. PRIMARY KEY (`id`)
  447. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='英雄战力变化日志表';
  448. -- ----------------------------
  449. -- Records of hero_fighting_log_202502
  450. -- ----------------------------
  451. BEGIN;
  452. COMMIT;
  453. -- ----------------------------
  454. -- Table structure for hero_log_202411
  455. -- ----------------------------
  456. DROP TABLE IF EXISTS `hero_log_202411`;
  457. CREATE TABLE `hero_log_202411` (
  458. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  459. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  460. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  461. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  462. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  463. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  464. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  465. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  466. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  467. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  468. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  469. `time` datetime DEFAULT NULL COMMENT '发生时间',
  470. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  471. PRIMARY KEY (`id`)
  472. ) ENGINE=InnoDB AUTO_INCREMENT=100000004 DEFAULT CHARSET=utf8mb4 COMMENT='英雄日志表';
  473. -- ----------------------------
  474. -- Records of hero_log_202411
  475. -- ----------------------------
  476. BEGIN;
  477. INSERT INTO `hero_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 100000001, 335879897874433, '宁丁兰', 1020001, '李大侠', 1, 1, 700001, '创号初始化', '2024-11-22 11:02:11', '');
  478. INSERT INTO `hero_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:37:59', '2024-11-22 11:37:59', 100000002, 335879897874434, '方昊乾', 1020001, '李大侠', 1, 1, 700001, '创号初始化', '2024-11-22 11:37:06', '');
  479. INSERT INTO `hero_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:37:59', '2024-11-22 11:37:59', 100000003, 335879897874434, '方昊乾', 1010005, '明月新', 1, 1, 400003, 'NPC开启', '2024-11-22 11:37:54', '');
  480. COMMIT;
  481. -- ----------------------------
  482. -- Table structure for hero_log_202502
  483. -- ----------------------------
  484. DROP TABLE IF EXISTS `hero_log_202502`;
  485. CREATE TABLE `hero_log_202502` (
  486. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  487. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  488. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  489. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  490. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  491. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  492. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  493. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  494. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  495. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  496. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  497. `time` datetime DEFAULT NULL COMMENT '发生时间',
  498. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  499. PRIMARY KEY (`id`)
  500. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='英雄日志表';
  501. -- ----------------------------
  502. -- Records of hero_log_202502
  503. -- ----------------------------
  504. BEGIN;
  505. COMMIT;
  506. -- ----------------------------
  507. -- Table structure for item_log_202411
  508. -- ----------------------------
  509. DROP TABLE IF EXISTS `item_log_202411`;
  510. CREATE TABLE `item_log_202411` (
  511. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  512. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  513. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  514. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  515. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  516. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  517. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  518. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  519. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  520. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  521. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  522. `time` datetime DEFAULT NULL COMMENT '发生时间',
  523. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  524. PRIMARY KEY (`id`)
  525. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='道具日志表';
  526. -- ----------------------------
  527. -- Records of item_log_202411
  528. -- ----------------------------
  529. BEGIN;
  530. COMMIT;
  531. -- ----------------------------
  532. -- Table structure for item_log_202502
  533. -- ----------------------------
  534. DROP TABLE IF EXISTS `item_log_202502`;
  535. CREATE TABLE `item_log_202502` (
  536. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  537. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  538. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  539. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  540. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  541. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  542. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  543. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  544. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  545. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  546. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  547. `time` datetime DEFAULT NULL COMMENT '发生时间',
  548. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  549. PRIMARY KEY (`id`)
  550. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='道具日志表';
  551. -- ----------------------------
  552. -- Records of item_log_202502
  553. -- ----------------------------
  554. BEGIN;
  555. COMMIT;
  556. -- ----------------------------
  557. -- Table structure for mail_log_202411
  558. -- ----------------------------
  559. DROP TABLE IF EXISTS `mail_log_202411`;
  560. CREATE TABLE `mail_log_202411` (
  561. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  562. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  563. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  564. `ori_mail_id` bigint(20) DEFAULT '0' COMMENT '原邮件ID',
  565. `owner_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  566. `owner_name` varchar(255) DEFAULT '' COMMENT '玩家名字',
  567. `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
  568. `title_args` varchar(2500) DEFAULT '' COMMENT '标题参数',
  569. `content_args` varchar(2500) DEFAULT '' COMMENT '内容参数',
  570. `attachment` varchar(2500) DEFAULT '' COMMENT '附件',
  571. `read` char(5) DEFAULT 'false' COMMENT '是否已读',
  572. `receive` char(5) DEFAULT 'false' COMMENT '是否已领',
  573. `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  574. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  575. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  576. `from_pool_id` bigint(20) DEFAULT '0' COMMENT '来自哪个系统邮件',
  577. `time` datetime DEFAULT NULL COMMENT '发生时间',
  578. PRIMARY KEY (`id`)
  579. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件日志表';
  580. -- ----------------------------
  581. -- Records of mail_log_202411
  582. -- ----------------------------
  583. BEGIN;
  584. COMMIT;
  585. -- ----------------------------
  586. -- Table structure for mail_log_202502
  587. -- ----------------------------
  588. DROP TABLE IF EXISTS `mail_log_202502`;
  589. CREATE TABLE `mail_log_202502` (
  590. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  591. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  592. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  593. `ori_mail_id` bigint(20) DEFAULT '0' COMMENT '原邮件ID',
  594. `owner_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  595. `owner_name` varchar(255) DEFAULT '' COMMENT '玩家名字',
  596. `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
  597. `title_args` varchar(2500) DEFAULT '' COMMENT '标题参数',
  598. `content_args` varchar(2500) DEFAULT '' COMMENT '内容参数',
  599. `attachment` varchar(2500) DEFAULT '' COMMENT '附件',
  600. `read` char(5) DEFAULT 'false' COMMENT '是否已读',
  601. `receive` char(5) DEFAULT 'false' COMMENT '是否已领',
  602. `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  603. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  604. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  605. `from_pool_id` bigint(20) DEFAULT '0' COMMENT '来自哪个系统邮件',
  606. `time` datetime DEFAULT NULL COMMENT '发生时间',
  607. PRIMARY KEY (`id`)
  608. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='邮件日志表';
  609. -- ----------------------------
  610. -- Records of mail_log_202502
  611. -- ----------------------------
  612. BEGIN;
  613. COMMIT;
  614. -- ----------------------------
  615. -- Table structure for mainline_boss_dot
  616. -- ----------------------------
  617. DROP TABLE IF EXISTS `mainline_boss_dot`;
  618. CREATE TABLE `mainline_boss_dot` (
  619. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  620. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  621. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  622. `boss_id` int(11) DEFAULT '0' COMMENT '领主ID',
  623. `boss_name` varchar(255) DEFAULT '' COMMENT '领主名称',
  624. `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  625. `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
  626. `timing` int(11) DEFAULT '0' COMMENT '时机',
  627. `level` int(11) DEFAULT '0' COMMENT '领主等级',
  628. PRIMARY KEY (`id`),
  629. KEY `boss_id` (`boss_id`) USING BTREE
  630. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='主线BOSS打点表';
  631. -- ----------------------------
  632. -- Records of mainline_boss_dot
  633. -- ----------------------------
  634. BEGIN;
  635. COMMIT;
  636. -- ----------------------------
  637. -- Table structure for mainline_fog_dot
  638. -- ----------------------------
  639. DROP TABLE IF EXISTS `mainline_fog_dot`;
  640. CREATE TABLE `mainline_fog_dot` (
  641. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  642. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  643. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  644. `fog_id` int(11) DEFAULT '0' COMMENT '迷雾ID',
  645. `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  646. `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
  647. `level` int(11) DEFAULT '0' COMMENT '等级',
  648. PRIMARY KEY (`id`)
  649. ) ENGINE=InnoDB AUTO_INCREMENT=100000002 DEFAULT CHARSET=utf8mb4 COMMENT='主线迷雾解锁打点表';
  650. -- ----------------------------
  651. -- Records of mainline_fog_dot
  652. -- ----------------------------
  653. BEGIN;
  654. INSERT INTO `mainline_fog_dot` (`insert_time`, `update_time`, `id`, `fog_id`, `player_id`, `fighting`, `level`) VALUES ('2024-11-22 11:39:09', '2024-11-22 11:39:09', 100000001, 1, 335879897874434, 1043, 1);
  655. COMMIT;
  656. -- ----------------------------
  657. -- Table structure for mainline_task_dot
  658. -- ----------------------------
  659. DROP TABLE IF EXISTS `mainline_task_dot`;
  660. CREATE TABLE `mainline_task_dot` (
  661. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  662. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  663. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  664. `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
  665. `task_name` varchar(255) DEFAULT '' COMMENT '任务名称',
  666. `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  667. `timing` int(11) DEFAULT '0' COMMENT '打点时机',
  668. PRIMARY KEY (`id`)
  669. ) ENGINE=InnoDB AUTO_INCREMENT=100000009 DEFAULT CHARSET=utf8mb4 COMMENT='主线任务打点表';
  670. -- ----------------------------
  671. -- Records of mainline_task_dot
  672. -- ----------------------------
  673. BEGIN;
  674. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:02:12', '2024-11-22 11:02:12', 100000001, 10001, '消灭3只人参果', 335879897874433, 1);
  675. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 100000002, 10001, '消灭3只人参果', 335879897874434, 1);
  676. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:38:09', '2024-11-22 11:38:09', 100000003, 10002, '帮助明月新', 335879897874434, 1);
  677. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:38:09', '2024-11-22 11:38:09', 100000004, 10001, '消灭3只人参果', 335879897874434, 2);
  678. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:38:09', '2024-11-22 11:38:09', 100000005, 10003, '驱散前方迷雾', 335879897874434, 1);
  679. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:38:09', '2024-11-22 11:38:09', 100000006, 10002, '帮助明月新', 335879897874434, 2);
  680. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:39:09', '2024-11-22 11:39:09', 100000007, 10004, '帮助雨师', 335879897874434, 1);
  681. INSERT INTO `mainline_task_dot` (`insert_time`, `update_time`, `id`, `task_id`, `task_name`, `player_id`, `timing`) VALUES ('2024-11-22 11:39:09', '2024-11-22 11:39:09', 100000008, 10003, '驱散前方迷雾', 335879897874434, 2);
  682. COMMIT;
  683. -- ----------------------------
  684. -- Table structure for meat_log_202411
  685. -- ----------------------------
  686. DROP TABLE IF EXISTS `meat_log_202411`;
  687. CREATE TABLE `meat_log_202411` (
  688. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  689. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  690. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  691. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  692. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  693. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  694. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  695. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  696. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  697. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  698. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  699. `time` datetime DEFAULT NULL COMMENT '发生时间',
  700. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  701. PRIMARY KEY (`id`)
  702. ) ENGINE=InnoDB AUTO_INCREMENT=100000063 DEFAULT CHARSET=utf8mb4 COMMENT='肉日志表';
  703. -- ----------------------------
  704. -- Records of meat_log_202411
  705. -- ----------------------------
  706. BEGIN;
  707. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:18', '2024-11-22 11:38:18', 100000001, 335879897874434, '方昊乾', 5, '肉', 1, 1, 400006, '主线战斗掉落', '2024-11-22 11:37:44', '');
  708. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:18', '2024-11-22 11:38:18', 100000002, 335879897874434, '方昊乾', 5, '肉', 1, 2, 400006, '主线战斗掉落', '2024-11-22 11:37:45', '');
  709. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:18', '2024-11-22 11:38:18', 100000003, 335879897874434, '方昊乾', 5, '肉', 1, 3, 400006, '主线战斗掉落', '2024-11-22 11:37:46', '');
  710. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:18', '2024-11-22 11:38:18', 100000004, 335879897874434, '方昊乾', 5, '肉', -3, 0, 400003, 'NPC开启', '2024-11-22 11:37:54', '');
  711. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:18', '2024-11-22 11:39:18', 100000005, 335879897874434, '方昊乾', 5, '肉', 1, 1, 400006, '主线战斗掉落', '2024-11-22 11:38:20', '');
  712. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:18', '2024-11-22 11:39:18', 100000006, 335879897874434, '方昊乾', 5, '肉', 1, 2, 400006, '主线战斗掉落', '2024-11-22 11:38:20', '');
  713. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:18', '2024-11-22 11:39:18', 100000007, 335879897874434, '方昊乾', 5, '肉', 2, 4, 400006, '主线战斗掉落', '2024-11-22 11:38:22', '');
  714. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:18', '2024-11-22 11:39:18', 100000008, 335879897874434, '方昊乾', 5, '肉', 1, 5, 400006, '主线战斗掉落', '2024-11-22 11:38:24', '');
  715. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:18', '2024-11-22 11:40:18', 100000009, 335879897874434, '方昊乾', 5, '肉', 1, 6, 400006, '主线战斗掉落', '2024-11-22 11:39:22', '');
  716. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:18', '2024-11-22 11:40:18', 100000010, 335879897874434, '方昊乾', 5, '肉', 1, 7, 400006, '主线战斗掉落', '2024-11-22 11:39:23', '');
  717. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:18', '2024-11-22 11:40:18', 100000011, 335879897874434, '方昊乾', 5, '肉', 2, 9, 400006, '主线战斗掉落', '2024-11-22 11:39:24', '');
  718. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:18', '2024-11-22 11:40:18', 100000012, 335879897874434, '方昊乾', 5, '肉', 1, 10, 400006, '主线战斗掉落', '2024-11-22 11:39:26', '');
  719. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:18', '2024-11-22 11:41:18', 100000013, 335879897874434, '方昊乾', 5, '肉', 1, 11, 400006, '主线战斗掉落', '2024-11-22 11:40:24', '');
  720. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:18', '2024-11-22 11:41:18', 100000014, 335879897874434, '方昊乾', 5, '肉', 1, 12, 400006, '主线战斗掉落', '2024-11-22 11:40:25', '');
  721. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:18', '2024-11-22 11:41:18', 100000015, 335879897874434, '方昊乾', 5, '肉', 1, 13, 400006, '主线战斗掉落', '2024-11-22 11:40:27', '');
  722. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:18', '2024-11-22 11:41:18', 100000016, 335879897874434, '方昊乾', 5, '肉', 1, 14, 400006, '主线战斗掉落', '2024-11-22 11:40:28', '');
  723. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:18', '2024-11-22 11:41:18', 100000017, 335879897874434, '方昊乾', 5, '肉', 1, 15, 400006, '主线战斗掉落', '2024-11-22 11:40:29', '');
  724. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:18', '2024-11-22 11:42:18', 100000018, 335879897874434, '方昊乾', 5, '肉', 1, 16, 400006, '主线战斗掉落', '2024-11-22 11:41:25', '');
  725. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:18', '2024-11-22 11:42:18', 100000019, 335879897874434, '方昊乾', 5, '肉', 1, 17, 400006, '主线战斗掉落', '2024-11-22 11:41:28', '');
  726. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:18', '2024-11-22 11:42:18', 100000020, 335879897874434, '方昊乾', 5, '肉', 1, 18, 400006, '主线战斗掉落', '2024-11-22 11:41:30', '');
  727. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:18', '2024-11-22 11:42:18', 100000021, 335879897874434, '方昊乾', 5, '肉', 1, 19, 400006, '主线战斗掉落', '2024-11-22 11:41:32', '');
  728. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:18', '2024-11-22 11:42:18', 100000022, 335879897874434, '方昊乾', 5, '肉', 1, 20, 400006, '主线战斗掉落', '2024-11-22 11:41:34', '');
  729. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:18', '2024-11-22 11:43:18', 100000023, 335879897874434, '方昊乾', 5, '肉', 1, 21, 400006, '主线战斗掉落', '2024-11-22 11:42:26', '');
  730. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:18', '2024-11-22 11:43:18', 100000024, 335879897874434, '方昊乾', 5, '肉', 1, 22, 400006, '主线战斗掉落', '2024-11-22 11:42:30', '');
  731. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:18', '2024-11-22 11:43:18', 100000025, 335879897874434, '方昊乾', 5, '肉', 1, 23, 400006, '主线战斗掉落', '2024-11-22 11:42:33', '');
  732. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:18', '2024-11-22 11:43:18', 100000026, 335879897874434, '方昊乾', 5, '肉', 1, 24, 400006, '主线战斗掉落', '2024-11-22 11:42:34', '');
  733. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:18', '2024-11-22 11:43:18', 100000027, 335879897874434, '方昊乾', 5, '肉', 1, 25, 400006, '主线战斗掉落', '2024-11-22 11:42:36', '');
  734. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:18', '2024-11-22 11:44:18', 100000028, 335879897874434, '方昊乾', 5, '肉', 1, 26, 400006, '主线战斗掉落', '2024-11-22 11:43:28', '');
  735. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:18', '2024-11-22 11:44:18', 100000029, 335879897874434, '方昊乾', 5, '肉', 1, 27, 400006, '主线战斗掉落', '2024-11-22 11:43:33', '');
  736. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:18', '2024-11-22 11:44:18', 100000030, 335879897874434, '方昊乾', 5, '肉', 1, 28, 400006, '主线战斗掉落', '2024-11-22 11:43:34', '');
  737. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:18', '2024-11-22 11:44:18', 100000031, 335879897874434, '方昊乾', 5, '肉', 1, 29, 400006, '主线战斗掉落', '2024-11-22 11:43:36', '');
  738. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:18', '2024-11-22 11:44:18', 100000032, 335879897874434, '方昊乾', 5, '肉', 1, 30, 400006, '主线战斗掉落', '2024-11-22 11:43:39', '');
  739. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:18', '2024-11-22 11:45:18', 100000033, 335879897874434, '方昊乾', 5, '肉', 1, 31, 400006, '主线战斗掉落', '2024-11-22 11:44:31', '');
  740. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:18', '2024-11-22 11:45:18', 100000034, 335879897874434, '方昊乾', 5, '肉', 1, 32, 400006, '主线战斗掉落', '2024-11-22 11:44:35', '');
  741. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:18', '2024-11-22 11:45:18', 100000035, 335879897874434, '方昊乾', 5, '肉', 1, 33, 400006, '主线战斗掉落', '2024-11-22 11:44:37', '');
  742. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:18', '2024-11-22 11:45:18', 100000036, 335879897874434, '方昊乾', 5, '肉', 1, 34, 400006, '主线战斗掉落', '2024-11-22 11:44:39', '');
  743. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:18', '2024-11-22 11:45:18', 100000037, 335879897874434, '方昊乾', 5, '肉', 1, 35, 400006, '主线战斗掉落', '2024-11-22 11:44:42', '');
  744. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:18', '2024-11-22 11:46:18', 100000038, 335879897874434, '方昊乾', 5, '肉', 1, 36, 400006, '主线战斗掉落', '2024-11-22 11:45:34', '');
  745. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:18', '2024-11-22 11:46:18', 100000039, 335879897874434, '方昊乾', 5, '肉', 1, 37, 400006, '主线战斗掉落', '2024-11-22 11:45:37', '');
  746. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:18', '2024-11-22 11:46:18', 100000040, 335879897874434, '方昊乾', 5, '肉', 1, 38, 400006, '主线战斗掉落', '2024-11-22 11:45:38', '');
  747. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:18', '2024-11-22 11:46:18', 100000041, 335879897874434, '方昊乾', 5, '肉', 1, 39, 400006, '主线战斗掉落', '2024-11-22 11:45:42', '');
  748. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:18', '2024-11-22 11:46:18', 100000042, 335879897874434, '方昊乾', 5, '肉', 1, 40, 400006, '主线战斗掉落', '2024-11-22 11:45:44', '');
  749. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:18', '2024-11-22 11:47:18', 100000043, 335879897874434, '方昊乾', 5, '肉', 1, 41, 400006, '主线战斗掉落', '2024-11-22 11:46:35', '');
  750. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:18', '2024-11-22 11:47:18', 100000044, 335879897874434, '方昊乾', 5, '肉', 1, 42, 400006, '主线战斗掉落', '2024-11-22 11:46:39', '');
  751. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:18', '2024-11-22 11:47:18', 100000045, 335879897874434, '方昊乾', 5, '肉', 1, 43, 400006, '主线战斗掉落', '2024-11-22 11:46:40', '');
  752. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:18', '2024-11-22 11:47:18', 100000046, 335879897874434, '方昊乾', 5, '肉', 1, 44, 400006, '主线战斗掉落', '2024-11-22 11:46:45', '');
  753. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:18', '2024-11-22 11:47:18', 100000047, 335879897874434, '方昊乾', 5, '肉', 1, 45, 400006, '主线战斗掉落', '2024-11-22 11:46:46', '');
  754. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:18', '2024-11-22 11:48:18', 100000048, 335879897874434, '方昊乾', 5, '肉', 1, 46, 400006, '主线战斗掉落', '2024-11-22 11:47:36', '');
  755. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:18', '2024-11-22 11:48:18', 100000049, 335879897874434, '方昊乾', 5, '肉', 1, 47, 400006, '主线战斗掉落', '2024-11-22 11:47:41', '');
  756. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:18', '2024-11-22 11:48:18', 100000050, 335879897874434, '方昊乾', 5, '肉', 1, 48, 400006, '主线战斗掉落', '2024-11-22 11:47:43', '');
  757. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:18', '2024-11-22 11:48:18', 100000051, 335879897874434, '方昊乾', 5, '肉', 1, 49, 400006, '主线战斗掉落', '2024-11-22 11:47:48', '');
  758. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:18', '2024-11-22 11:48:18', 100000052, 335879897874434, '方昊乾', 5, '肉', 1, 50, 400006, '主线战斗掉落', '2024-11-22 11:47:49', '');
  759. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:18', '2024-11-22 11:49:18', 100000053, 335879897874434, '方昊乾', 5, '肉', 1, 51, 400006, '主线战斗掉落', '2024-11-22 11:48:38', '');
  760. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:18', '2024-11-22 11:49:18', 100000054, 335879897874434, '方昊乾', 5, '肉', 1, 52, 400006, '主线战斗掉落', '2024-11-22 11:48:42', '');
  761. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:18', '2024-11-22 11:49:18', 100000055, 335879897874434, '方昊乾', 5, '肉', 1, 53, 400006, '主线战斗掉落', '2024-11-22 11:48:45', '');
  762. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:18', '2024-11-22 11:49:18', 100000056, 335879897874434, '方昊乾', 5, '肉', 1, 54, 400006, '主线战斗掉落', '2024-11-22 11:48:50', '');
  763. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:18', '2024-11-22 11:49:18', 100000057, 335879897874434, '方昊乾', 5, '肉', 1, 55, 400006, '主线战斗掉落', '2024-11-22 11:48:52', '');
  764. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:19', '2024-11-22 11:50:19', 100000058, 335879897874434, '方昊乾', 5, '肉', 1, 56, 400006, '主线战斗掉落', '2024-11-22 11:49:40', '');
  765. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:19', '2024-11-22 11:50:19', 100000059, 335879897874434, '方昊乾', 5, '肉', 1, 57, 400006, '主线战斗掉落', '2024-11-22 11:49:45', '');
  766. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:19', '2024-11-22 11:50:19', 100000060, 335879897874434, '方昊乾', 5, '肉', 1, 58, 400006, '主线战斗掉落', '2024-11-22 11:49:47', '');
  767. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:19', '2024-11-22 11:50:19', 100000061, 335879897874434, '方昊乾', 5, '肉', 1, 59, 400006, '主线战斗掉落', '2024-11-22 11:49:52', '');
  768. INSERT INTO `meat_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:19', '2024-11-22 11:50:19', 100000062, 335879897874434, '方昊乾', 5, '肉', 1, 60, 400006, '主线战斗掉落', '2024-11-22 11:49:54', '');
  769. COMMIT;
  770. -- ----------------------------
  771. -- Table structure for meat_log_202502
  772. -- ----------------------------
  773. DROP TABLE IF EXISTS `meat_log_202502`;
  774. CREATE TABLE `meat_log_202502` (
  775. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  776. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  777. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  778. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  779. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  780. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  781. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  782. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  783. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  784. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  785. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  786. `time` datetime DEFAULT NULL COMMENT '发生时间',
  787. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  788. PRIMARY KEY (`id`)
  789. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='肉日志表';
  790. -- ----------------------------
  791. -- Records of meat_log_202502
  792. -- ----------------------------
  793. BEGIN;
  794. COMMIT;
  795. -- ----------------------------
  796. -- Table structure for mine_log_202411
  797. -- ----------------------------
  798. DROP TABLE IF EXISTS `mine_log_202411`;
  799. CREATE TABLE `mine_log_202411` (
  800. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  801. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  802. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  803. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  804. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  805. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  806. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  807. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  808. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  809. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  810. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  811. `time` datetime DEFAULT NULL COMMENT '发生时间',
  812. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  813. PRIMARY KEY (`id`)
  814. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='矿日志表';
  815. -- ----------------------------
  816. -- Records of mine_log_202411
  817. -- ----------------------------
  818. BEGIN;
  819. COMMIT;
  820. -- ----------------------------
  821. -- Table structure for mine_log_202502
  822. -- ----------------------------
  823. DROP TABLE IF EXISTS `mine_log_202502`;
  824. CREATE TABLE `mine_log_202502` (
  825. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  826. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  827. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  828. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  829. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  830. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  831. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  832. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  833. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  834. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  835. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  836. `time` datetime DEFAULT NULL COMMENT '发生时间',
  837. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  838. PRIMARY KEY (`id`)
  839. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='矿日志表';
  840. -- ----------------------------
  841. -- Records of mine_log_202502
  842. -- ----------------------------
  843. BEGIN;
  844. COMMIT;
  845. -- ----------------------------
  846. -- Table structure for player_create_log
  847. -- ----------------------------
  848. DROP TABLE IF EXISTS `player_create_log`;
  849. CREATE TABLE `player_create_log` (
  850. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  851. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  852. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  853. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  854. `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  855. `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
  856. `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
  857. `born_time` datetime DEFAULT NULL COMMENT '创号时间',
  858. `ip` varchar(255) DEFAULT '' COMMENT '创号IP',
  859. `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
  860. PRIMARY KEY (`id`)
  861. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家创号日志表';
  862. -- ----------------------------
  863. -- Records of player_create_log
  864. -- ----------------------------
  865. BEGIN;
  866. INSERT INTO `player_create_log` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `device_type`, `born_time`, `ip`, `channel_id`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 100000001, 335879897874433, 'zxt', '宁丁兰', 'IOS-TEST', '2024-11-22 11:02:10', '127.0.0.1', 1);
  867. INSERT INTO `player_create_log` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `device_type`, `born_time`, `ip`, `channel_id`) VALUES ('2024-11-22 11:37:52', '2024-11-22 11:37:52', 100000002, 335879897874434, 'xg011732246612147', '方昊乾', 'IOS', '2024-11-22 11:37:06', '192.168.3.144', 2);
  868. COMMIT;
  869. -- ----------------------------
  870. -- Table structure for player_exp_log_202411
  871. -- ----------------------------
  872. DROP TABLE IF EXISTS `player_exp_log_202411`;
  873. CREATE TABLE `player_exp_log_202411` (
  874. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  875. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  876. `old_level` int(11) DEFAULT '0' COMMENT '原等级',
  877. `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
  878. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  879. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  880. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  881. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  882. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  883. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  884. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  885. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  886. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  887. `time` datetime DEFAULT NULL COMMENT '发生时间',
  888. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  889. PRIMARY KEY (`id`)
  890. ) ENGINE=InnoDB AUTO_INCREMENT=100000062 DEFAULT CHARSET=utf8mb4 COMMENT='玩家经验日志表';
  891. -- ----------------------------
  892. -- Records of player_exp_log_202411
  893. -- ----------------------------
  894. BEGIN;
  895. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:06', '2024-11-22 11:38:06', 1, 1, 100000001, 335879897874434, '方昊乾', 3, '', 8, 8, 400006, '主线战斗掉落', '2024-11-22 11:37:44', '');
  896. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:06', '2024-11-22 11:38:06', 1, 1, 100000002, 335879897874434, '方昊乾', 3, '', 8, 16, 400006, '主线战斗掉落', '2024-11-22 11:37:45', '');
  897. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:06', '2024-11-22 11:38:06', 1, 1, 100000003, 335879897874434, '方昊乾', 3, '', 8, 24, 400006, '主线战斗掉落', '2024-11-22 11:37:46', '');
  898. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:06', '2024-11-22 11:39:06', 1, 1, 100000004, 335879897874434, '方昊乾', 3, '', 8, 32, 400006, '主线战斗掉落', '2024-11-22 11:38:20', '');
  899. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:06', '2024-11-22 11:39:06', 1, 1, 100000005, 335879897874434, '方昊乾', 3, '', 8, 40, 400006, '主线战斗掉落', '2024-11-22 11:38:20', '');
  900. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:06', '2024-11-22 11:39:06', 1, 1, 100000006, 335879897874434, '方昊乾', 3, '', 16, 56, 400006, '主线战斗掉落', '2024-11-22 11:38:22', '');
  901. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:06', '2024-11-22 11:39:06', 1, 1, 100000007, 335879897874434, '方昊乾', 3, '', 8, 64, 400006, '主线战斗掉落', '2024-11-22 11:38:24', '');
  902. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:06', '2024-11-22 11:40:06', 1, 1, 100000008, 335879897874434, '方昊乾', 3, '', 8, 72, 400006, '主线战斗掉落', '2024-11-22 11:39:22', '');
  903. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:06', '2024-11-22 11:40:06', 1, 2, 100000009, 335879897874434, '方昊乾', 3, '', 8, 0, 400006, '主线战斗掉落', '2024-11-22 11:39:23', '');
  904. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:06', '2024-11-22 11:40:06', 2, 2, 100000010, 335879897874434, '方昊乾', 3, '', 16, 16, 400006, '主线战斗掉落', '2024-11-22 11:39:24', '');
  905. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:40:06', '2024-11-22 11:40:06', 2, 2, 100000011, 335879897874434, '方昊乾', 3, '', 8, 24, 400006, '主线战斗掉落', '2024-11-22 11:39:26', '');
  906. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:06', '2024-11-22 11:41:06', 2, 2, 100000012, 335879897874434, '方昊乾', 3, '', 8, 32, 400006, '主线战斗掉落', '2024-11-22 11:40:24', '');
  907. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:06', '2024-11-22 11:41:06', 2, 2, 100000013, 335879897874434, '方昊乾', 3, '', 8, 40, 400006, '主线战斗掉落', '2024-11-22 11:40:25', '');
  908. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:06', '2024-11-22 11:41:06', 2, 2, 100000014, 335879897874434, '方昊乾', 3, '', 8, 48, 400006, '主线战斗掉落', '2024-11-22 11:40:27', '');
  909. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:06', '2024-11-22 11:41:06', 2, 2, 100000015, 335879897874434, '方昊乾', 3, '', 8, 56, 400006, '主线战斗掉落', '2024-11-22 11:40:28', '');
  910. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:41:06', '2024-11-22 11:41:06', 2, 2, 100000016, 335879897874434, '方昊乾', 3, '', 8, 64, 400006, '主线战斗掉落', '2024-11-22 11:40:29', '');
  911. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:06', '2024-11-22 11:42:06', 2, 2, 100000017, 335879897874434, '方昊乾', 3, '', 8, 72, 400006, '主线战斗掉落', '2024-11-22 11:41:25', '');
  912. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:06', '2024-11-22 11:42:06', 2, 2, 100000018, 335879897874434, '方昊乾', 3, '', 8, 80, 400006, '主线战斗掉落', '2024-11-22 11:41:28', '');
  913. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:06', '2024-11-22 11:42:06', 2, 2, 100000019, 335879897874434, '方昊乾', 3, '', 8, 88, 400006, '主线战斗掉落', '2024-11-22 11:41:30', '');
  914. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:06', '2024-11-22 11:42:06', 2, 2, 100000020, 335879897874434, '方昊乾', 3, '', 8, 96, 400006, '主线战斗掉落', '2024-11-22 11:41:32', '');
  915. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:42:06', '2024-11-22 11:42:06', 2, 2, 100000021, 335879897874434, '方昊乾', 3, '', 8, 104, 400006, '主线战斗掉落', '2024-11-22 11:41:34', '');
  916. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:06', '2024-11-22 11:43:06', 2, 2, 100000022, 335879897874434, '方昊乾', 3, '', 8, 112, 400006, '主线战斗掉落', '2024-11-22 11:42:26', '');
  917. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:06', '2024-11-22 11:43:06', 2, 2, 100000023, 335879897874434, '方昊乾', 3, '', 8, 120, 400006, '主线战斗掉落', '2024-11-22 11:42:30', '');
  918. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:06', '2024-11-22 11:43:06', 2, 2, 100000024, 335879897874434, '方昊乾', 3, '', 8, 128, 400006, '主线战斗掉落', '2024-11-22 11:42:33', '');
  919. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:06', '2024-11-22 11:43:06', 2, 2, 100000025, 335879897874434, '方昊乾', 3, '', 8, 136, 400006, '主线战斗掉落', '2024-11-22 11:42:34', '');
  920. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:43:06', '2024-11-22 11:43:06', 2, 2, 100000026, 335879897874434, '方昊乾', 3, '', 8, 144, 400006, '主线战斗掉落', '2024-11-22 11:42:36', '');
  921. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:06', '2024-11-22 11:44:06', 2, 2, 100000027, 335879897874434, '方昊乾', 3, '', 8, 152, 400006, '主线战斗掉落', '2024-11-22 11:43:28', '');
  922. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:06', '2024-11-22 11:44:06', 2, 2, 100000028, 335879897874434, '方昊乾', 3, '', 8, 160, 400006, '主线战斗掉落', '2024-11-22 11:43:33', '');
  923. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:06', '2024-11-22 11:44:06', 2, 2, 100000029, 335879897874434, '方昊乾', 3, '', 8, 168, 400006, '主线战斗掉落', '2024-11-22 11:43:34', '');
  924. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:06', '2024-11-22 11:44:06', 2, 2, 100000030, 335879897874434, '方昊乾', 3, '', 8, 176, 400006, '主线战斗掉落', '2024-11-22 11:43:36', '');
  925. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:44:06', '2024-11-22 11:44:06', 2, 2, 100000031, 335879897874434, '方昊乾', 3, '', 8, 184, 400006, '主线战斗掉落', '2024-11-22 11:43:39', '');
  926. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:06', '2024-11-22 11:45:06', 2, 2, 100000032, 335879897874434, '方昊乾', 3, '', 8, 192, 400006, '主线战斗掉落', '2024-11-22 11:44:31', '');
  927. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:06', '2024-11-22 11:45:06', 2, 2, 100000033, 335879897874434, '方昊乾', 3, '', 8, 200, 400006, '主线战斗掉落', '2024-11-22 11:44:35', '');
  928. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:06', '2024-11-22 11:45:06', 2, 2, 100000034, 335879897874434, '方昊乾', 3, '', 8, 208, 400006, '主线战斗掉落', '2024-11-22 11:44:37', '');
  929. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:06', '2024-11-22 11:45:06', 2, 2, 100000035, 335879897874434, '方昊乾', 3, '', 8, 216, 400006, '主线战斗掉落', '2024-11-22 11:44:39', '');
  930. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:45:06', '2024-11-22 11:45:06', 2, 2, 100000036, 335879897874434, '方昊乾', 3, '', 8, 224, 400006, '主线战斗掉落', '2024-11-22 11:44:42', '');
  931. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:06', '2024-11-22 11:46:06', 2, 3, 100000037, 335879897874434, '方昊乾', 3, '', 8, 7, 400006, '主线战斗掉落', '2024-11-22 11:45:34', '');
  932. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:06', '2024-11-22 11:46:06', 3, 3, 100000038, 335879897874434, '方昊乾', 3, '', 8, 15, 400006, '主线战斗掉落', '2024-11-22 11:45:37', '');
  933. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:06', '2024-11-22 11:46:06', 3, 3, 100000039, 335879897874434, '方昊乾', 3, '', 8, 23, 400006, '主线战斗掉落', '2024-11-22 11:45:38', '');
  934. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:06', '2024-11-22 11:46:06', 3, 3, 100000040, 335879897874434, '方昊乾', 3, '', 8, 31, 400006, '主线战斗掉落', '2024-11-22 11:45:42', '');
  935. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:46:06', '2024-11-22 11:46:06', 3, 3, 100000041, 335879897874434, '方昊乾', 3, '', 8, 39, 400006, '主线战斗掉落', '2024-11-22 11:45:44', '');
  936. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:06', '2024-11-22 11:47:06', 3, 3, 100000042, 335879897874434, '方昊乾', 3, '', 8, 47, 400006, '主线战斗掉落', '2024-11-22 11:46:35', '');
  937. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:06', '2024-11-22 11:47:06', 3, 3, 100000043, 335879897874434, '方昊乾', 3, '', 8, 55, 400006, '主线战斗掉落', '2024-11-22 11:46:39', '');
  938. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:06', '2024-11-22 11:47:06', 3, 3, 100000044, 335879897874434, '方昊乾', 3, '', 8, 63, 400006, '主线战斗掉落', '2024-11-22 11:46:40', '');
  939. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:06', '2024-11-22 11:47:06', 3, 3, 100000045, 335879897874434, '方昊乾', 3, '', 8, 71, 400006, '主线战斗掉落', '2024-11-22 11:46:45', '');
  940. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:47:06', '2024-11-22 11:47:06', 3, 3, 100000046, 335879897874434, '方昊乾', 3, '', 8, 79, 400006, '主线战斗掉落', '2024-11-22 11:46:46', '');
  941. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:06', '2024-11-22 11:48:06', 3, 3, 100000047, 335879897874434, '方昊乾', 3, '', 8, 87, 400006, '主线战斗掉落', '2024-11-22 11:47:36', '');
  942. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:06', '2024-11-22 11:48:06', 3, 3, 100000048, 335879897874434, '方昊乾', 3, '', 8, 95, 400006, '主线战斗掉落', '2024-11-22 11:47:41', '');
  943. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:06', '2024-11-22 11:48:06', 3, 3, 100000049, 335879897874434, '方昊乾', 3, '', 8, 103, 400006, '主线战斗掉落', '2024-11-22 11:47:43', '');
  944. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:06', '2024-11-22 11:48:06', 3, 3, 100000050, 335879897874434, '方昊乾', 3, '', 8, 111, 400006, '主线战斗掉落', '2024-11-22 11:47:48', '');
  945. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:48:06', '2024-11-22 11:48:06', 3, 3, 100000051, 335879897874434, '方昊乾', 3, '', 8, 119, 400006, '主线战斗掉落', '2024-11-22 11:47:49', '');
  946. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:06', '2024-11-22 11:49:06', 3, 3, 100000052, 335879897874434, '方昊乾', 3, '', 8, 127, 400006, '主线战斗掉落', '2024-11-22 11:48:38', '');
  947. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:06', '2024-11-22 11:49:06', 3, 3, 100000053, 335879897874434, '方昊乾', 3, '', 8, 135, 400006, '主线战斗掉落', '2024-11-22 11:48:42', '');
  948. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:06', '2024-11-22 11:49:06', 3, 3, 100000054, 335879897874434, '方昊乾', 3, '', 8, 143, 400006, '主线战斗掉落', '2024-11-22 11:48:45', '');
  949. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:06', '2024-11-22 11:49:06', 3, 3, 100000055, 335879897874434, '方昊乾', 3, '', 8, 151, 400006, '主线战斗掉落', '2024-11-22 11:48:50', '');
  950. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:49:06', '2024-11-22 11:49:06', 3, 3, 100000056, 335879897874434, '方昊乾', 3, '', 8, 159, 400006, '主线战斗掉落', '2024-11-22 11:48:52', '');
  951. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:06', '2024-11-22 11:50:06', 3, 3, 100000057, 335879897874434, '方昊乾', 3, '', 8, 167, 400006, '主线战斗掉落', '2024-11-22 11:49:40', '');
  952. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:06', '2024-11-22 11:50:06', 3, 3, 100000058, 335879897874434, '方昊乾', 3, '', 8, 175, 400006, '主线战斗掉落', '2024-11-22 11:49:45', '');
  953. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:06', '2024-11-22 11:50:06', 3, 3, 100000059, 335879897874434, '方昊乾', 3, '', 8, 183, 400006, '主线战斗掉落', '2024-11-22 11:49:47', '');
  954. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:06', '2024-11-22 11:50:06', 3, 3, 100000060, 335879897874434, '方昊乾', 3, '', 8, 191, 400006, '主线战斗掉落', '2024-11-22 11:49:52', '');
  955. INSERT INTO `player_exp_log_202411` (`insert_time`, `update_time`, `old_level`, `curr_level`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:50:06', '2024-11-22 11:50:06', 3, 3, 100000061, 335879897874434, '方昊乾', 3, '', 8, 199, 400006, '主线战斗掉落', '2024-11-22 11:49:54', '');
  956. COMMIT;
  957. -- ----------------------------
  958. -- Table structure for player_exp_log_202502
  959. -- ----------------------------
  960. DROP TABLE IF EXISTS `player_exp_log_202502`;
  961. CREATE TABLE `player_exp_log_202502` (
  962. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  963. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  964. `old_level` int(11) DEFAULT '0' COMMENT '原等级',
  965. `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
  966. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  967. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  968. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  969. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  970. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  971. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  972. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  973. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  974. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  975. `time` datetime DEFAULT NULL COMMENT '发生时间',
  976. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  977. PRIMARY KEY (`id`)
  978. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家经验日志表';
  979. -- ----------------------------
  980. -- Records of player_exp_log_202502
  981. -- ----------------------------
  982. BEGIN;
  983. COMMIT;
  984. -- ----------------------------
  985. -- Table structure for player_fighting_log_202411
  986. -- ----------------------------
  987. DROP TABLE IF EXISTS `player_fighting_log_202411`;
  988. CREATE TABLE `player_fighting_log_202411` (
  989. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  990. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  991. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  992. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  993. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  994. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  995. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  996. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  997. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  998. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  999. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1000. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1001. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1002. PRIMARY KEY (`id`)
  1003. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家战斗力变化日志表';
  1004. -- ----------------------------
  1005. -- Records of player_fighting_log_202411
  1006. -- ----------------------------
  1007. BEGIN;
  1008. INSERT INTO `player_fighting_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:37:13', '2024-11-22 11:37:13', 100000001, 335879897874434, '方昊乾', 0, '战斗力', 540, 540, 300002, '进入主线战斗', '2024-11-22 11:37:06', NULL);
  1009. INSERT INTO `player_fighting_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:38:13', '2024-11-22 11:38:13', 100000002, 335879897874434, '方昊乾', 0, '战斗力', 503, 1043, 300002, '进入主线战斗', '2024-11-22 11:37:54', NULL);
  1010. COMMIT;
  1011. -- ----------------------------
  1012. -- Table structure for player_fighting_log_202502
  1013. -- ----------------------------
  1014. DROP TABLE IF EXISTS `player_fighting_log_202502`;
  1015. CREATE TABLE `player_fighting_log_202502` (
  1016. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1017. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1018. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1019. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1020. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1021. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1022. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1023. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1024. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1025. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1026. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1027. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1028. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1029. PRIMARY KEY (`id`)
  1030. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家战斗力变化日志表';
  1031. -- ----------------------------
  1032. -- Records of player_fighting_log_202502
  1033. -- ----------------------------
  1034. BEGIN;
  1035. COMMIT;
  1036. -- ----------------------------
  1037. -- Table structure for player_login_log_202411
  1038. -- ----------------------------
  1039. DROP TABLE IF EXISTS `player_login_log_202411`;
  1040. CREATE TABLE `player_login_log_202411` (
  1041. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1042. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1043. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1044. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1045. `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  1046. `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
  1047. `level` int(11) DEFAULT '0' COMMENT '等级',
  1048. `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  1049. `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
  1050. `born_time` datetime DEFAULT NULL COMMENT '创号时间',
  1051. `ip` varchar(255) DEFAULT '' COMMENT '登录IP',
  1052. `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
  1053. `create_pay` int(11) DEFAULT '0' COMMENT '是否创号当天有充值',
  1054. PRIMARY KEY (`id`)
  1055. ) ENGINE=InnoDB AUTO_INCREMENT=100000006 DEFAULT CHARSET=utf8mb4 COMMENT='玩家登录日志表';
  1056. -- ----------------------------
  1057. -- Records of player_login_log_202411
  1058. -- ----------------------------
  1059. BEGIN;
  1060. INSERT INTO `player_login_log_202411` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `level`, `login_time`, `device_type`, `born_time`, `ip`, `channel_id`, `create_pay`) VALUES ('2024-11-22 11:02:58', '2024-11-22 11:02:58', 100000001, 335879897874433, 'zxt', '宁丁兰', 1, '2024-11-22 11:02:11', 'IOS-TEST', '2024-11-22 11:02:10', '127.0.0.1', 1, 0);
  1061. INSERT INTO `player_login_log_202411` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `level`, `login_time`, `device_type`, `born_time`, `ip`, `channel_id`, `create_pay`) VALUES ('2024-11-22 11:22:17', '2024-11-22 11:22:17', 100000002, 335879897874433, 'zxt', '宁丁兰', 1, '2024-11-22 11:21:29', 'IOS-TEST', '2024-11-22 11:02:10', '127.0.0.1', 1, 0);
  1062. INSERT INTO `player_login_log_202411` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `level`, `login_time`, `device_type`, `born_time`, `ip`, `channel_id`, `create_pay`) VALUES ('2024-11-22 11:22:17', '2024-11-22 11:22:17', 100000003, 335879897874433, 'zxt', '宁丁兰', 1, '2024-11-22 11:21:29', 'IOS-TEST', '2024-11-22 11:02:10', '127.0.0.1', 1, 0);
  1063. INSERT INTO `player_login_log_202411` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `level`, `login_time`, `device_type`, `born_time`, `ip`, `channel_id`, `create_pay`) VALUES ('2024-11-22 11:22:17', '2024-11-22 11:22:17', 100000004, 335879897874433, 'zxt', '宁丁兰', 1, '2024-11-22 11:21:30', 'IOS-TEST', '2024-11-22 11:02:10', '127.0.0.1', 1, 0);
  1064. INSERT INTO `player_login_log_202411` (`insert_time`, `update_time`, `id`, `pid`, `open_id`, `nick`, `level`, `login_time`, `device_type`, `born_time`, `ip`, `channel_id`, `create_pay`) VALUES ('2024-11-22 11:37:17', '2024-11-22 11:37:17', 100000005, 335879897874434, 'xg011732246612147', '方昊乾', 1, '2024-11-22 11:37:06', 'IOS', '2024-11-22 11:37:06', '192.168.3.144', 2, 0);
  1065. COMMIT;
  1066. -- ----------------------------
  1067. -- Table structure for player_login_log_202502
  1068. -- ----------------------------
  1069. DROP TABLE IF EXISTS `player_login_log_202502`;
  1070. CREATE TABLE `player_login_log_202502` (
  1071. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1072. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1073. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1074. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1075. `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  1076. `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
  1077. `level` int(11) DEFAULT '0' COMMENT '等级',
  1078. `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  1079. `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
  1080. `born_time` datetime DEFAULT NULL COMMENT '创号时间',
  1081. `ip` varchar(255) DEFAULT '' COMMENT '登录IP',
  1082. `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
  1083. `create_pay` int(11) DEFAULT '0' COMMENT '是否创号当天有充值',
  1084. PRIMARY KEY (`id`)
  1085. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家登录日志表';
  1086. -- ----------------------------
  1087. -- Records of player_login_log_202502
  1088. -- ----------------------------
  1089. BEGIN;
  1090. COMMIT;
  1091. -- ----------------------------
  1092. -- Table structure for player_online_log
  1093. -- ----------------------------
  1094. DROP TABLE IF EXISTS `player_online_log`;
  1095. CREATE TABLE `player_online_log` (
  1096. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1097. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1098. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1099. `date_str` varchar(255) DEFAULT '' COMMENT '日期时间',
  1100. `time_period` int(11) DEFAULT '0' COMMENT '时间段',
  1101. `online_num` int(11) DEFAULT '0' COMMENT '在线人数',
  1102. `new_online_num` int(11) DEFAULT '0' COMMENT '在线新人数',
  1103. PRIMARY KEY (`id`)
  1104. ) ENGINE=InnoDB AUTO_INCREMENT=100000092 DEFAULT CHARSET=utf8mb4 COMMENT='每5分钟打点的在线人数表';
  1105. -- ----------------------------
  1106. -- Records of player_online_log
  1107. -- ----------------------------
  1108. BEGIN;
  1109. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 18:20:17', '2024-11-21 18:20:17', 100000001, '2024-11-21', 36, 0, 0);
  1110. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 18:31:37', '2024-11-21 18:31:37', 100000002, '2024-11-21', 37, 0, 0);
  1111. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 19:01:54', '2024-11-21 19:01:54', 100000003, '2024-11-21', 38, 0, 0);
  1112. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 19:30:05', '2024-11-21 19:30:05', 100000004, '2024-11-21', 39, 0, 0);
  1113. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 19:33:19', '2024-11-21 19:33:19', 100000005, '2024-11-21', 39, 0, 0);
  1114. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 19:45:02', '2024-11-21 19:45:02', 100000006, '2024-11-21', 39, 0, 0);
  1115. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 20:03:08', '2024-11-21 20:03:08', 100000007, '2024-11-21', 40, 0, 0);
  1116. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 20:35:29', '2024-11-21 20:35:29', 100000008, '2024-11-21', 41, 0, 0);
  1117. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 21:06:09', '2024-11-21 21:06:09', 100000009, '2024-11-21', 42, 0, 0);
  1118. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 21:36:48', '2024-11-21 21:36:48', 100000010, '2024-11-21', 43, 0, 0);
  1119. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 22:07:29', '2024-11-21 22:07:29', 100000011, '2024-11-21', 44, 0, 0);
  1120. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 22:38:11', '2024-11-21 22:38:11', 100000012, '2024-11-21', 45, 0, 0);
  1121. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 23:15:11', '2024-11-21 23:15:11', 100000013, '2024-11-21', 46, 0, 0);
  1122. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-21 23:52:12', '2024-11-21 23:52:12', 100000014, '2024-11-21', 47, 0, 0);
  1123. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 00:29:12', '2024-11-22 00:29:12', 100000015, '2024-11-22', 0, 0, 0);
  1124. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 01:06:13', '2024-11-22 01:06:13', 100000016, '2024-11-22', 2, 0, 0);
  1125. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 01:43:14', '2024-11-22 01:43:14', 100000017, '2024-11-22', 3, 0, 0);
  1126. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 02:20:13', '2024-11-22 02:20:13', 100000018, '2024-11-22', 4, 0, 0);
  1127. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 02:57:14', '2024-11-22 02:57:14', 100000019, '2024-11-22', 5, 0, 0);
  1128. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 03:34:14', '2024-11-22 03:34:14', 100000020, '2024-11-22', 7, 0, 0);
  1129. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 04:11:16', '2024-11-22 04:11:16', 100000021, '2024-11-22', 8, 0, 0);
  1130. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 04:36:35', '2024-11-22 04:36:35', 100000022, '2024-11-22', 9, 0, 0);
  1131. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 05:07:16', '2024-11-22 05:07:16', 100000023, '2024-11-22', 10, 0, 0);
  1132. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 05:37:55', '2024-11-22 05:37:55', 100000024, '2024-11-22', 11, 0, 0);
  1133. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 06:08:35', '2024-11-22 06:08:35', 100000025, '2024-11-22', 12, 0, 0);
  1134. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 06:45:34', '2024-11-22 06:45:34', 100000026, '2024-11-22', 13, 0, 0);
  1135. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 07:22:34', '2024-11-22 07:22:34', 100000027, '2024-11-22', 14, 0, 0);
  1136. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 07:59:35', '2024-11-22 07:59:35', 100000028, '2024-11-22', 15, 0, 0);
  1137. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 08:36:34', '2024-11-22 08:36:34', 100000029, '2024-11-22', 17, 0, 0);
  1138. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 09:06:49', '2024-11-22 09:06:49', 100000030, '2024-11-22', 18, 0, 0);
  1139. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 09:36:49', '2024-11-22 09:36:49', 100000031, '2024-11-22', 19, 0, 0);
  1140. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 10:06:49', '2024-11-22 10:06:49', 100000032, '2024-11-22', 20, 0, 0);
  1141. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 10:36:49', '2024-11-22 10:36:49', 100000033, '2024-11-22', 21, 0, 0);
  1142. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 11:06:50', '2024-11-22 11:06:50', 100000034, '2024-11-22', 22, 1, 1);
  1143. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 11:37:53', '2024-11-22 11:37:53', 100000035, '2024-11-22', 23, 1, 0);
  1144. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 12:23:33', '2024-11-22 12:23:33', 100000036, '2024-11-22', 24, 2, 1);
  1145. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 13:00:33', '2024-11-22 13:00:33', 100000037, '2024-11-22', 25, 1, 0);
  1146. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2024-11-22 13:11:15', '2024-11-22 13:11:15', 100000038, '2024-11-22', 26, 1, 0);
  1147. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 09:45:01', '2025-02-27 09:45:01', 100000039, '2025-02-27', 19, 0, 0);
  1148. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 09:46:54', '2025-02-27 09:46:54', 100000040, '2025-02-27', 19, 0, 0);
  1149. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 09:47:27', '2025-02-27 09:47:27', 100000041, '2025-02-27', 19, 0, 0);
  1150. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 10:17:52', '2025-02-27 10:17:52', 100000042, '2025-02-27', 20, 0, 0);
  1151. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 10:47:52', '2025-02-27 10:47:52', 100000043, '2025-02-27', 21, 0, 0);
  1152. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 11:17:52', '2025-02-27 11:17:52', 100000044, '2025-02-27', 22, 0, 0);
  1153. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 11:47:52', '2025-02-27 11:47:52', 100000045, '2025-02-27', 23, 0, 0);
  1154. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 12:17:53', '2025-02-27 12:17:53', 100000046, '2025-02-27', 24, 0, 0);
  1155. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 12:47:53', '2025-02-27 12:47:53', 100000047, '2025-02-27', 25, 0, 0);
  1156. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 13:17:53', '2025-02-27 13:17:53', 100000048, '2025-02-27', 26, 0, 0);
  1157. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 13:47:53', '2025-02-27 13:47:53', 100000049, '2025-02-27', 27, 0, 0);
  1158. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 14:17:54', '2025-02-27 14:17:54', 100000050, '2025-02-27', 28, 0, 0);
  1159. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 14:47:54', '2025-02-27 14:47:54', 100000051, '2025-02-27', 29, 0, 0);
  1160. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 15:17:54', '2025-02-27 15:17:54', 100000052, '2025-02-27', 30, 0, 0);
  1161. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 15:47:54', '2025-02-27 15:47:54', 100000053, '2025-02-27', 31, 0, 0);
  1162. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 16:17:55', '2025-02-27 16:17:55', 100000054, '2025-02-27', 32, 0, 0);
  1163. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 16:47:55', '2025-02-27 16:47:55', 100000055, '2025-02-27', 33, 0, 0);
  1164. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 17:17:55', '2025-02-27 17:17:55', 100000056, '2025-02-27', 34, 0, 0);
  1165. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 17:47:55', '2025-02-27 17:47:55', 100000057, '2025-02-27', 35, 0, 0);
  1166. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 18:17:56', '2025-02-27 18:17:56', 100000058, '2025-02-27', 36, 0, 0);
  1167. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 18:47:56', '2025-02-27 18:47:56', 100000059, '2025-02-27', 37, 0, 0);
  1168. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 19:17:56', '2025-02-27 19:17:56', 100000060, '2025-02-27', 38, 0, 0);
  1169. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 19:47:56', '2025-02-27 19:47:56', 100000061, '2025-02-27', 39, 0, 0);
  1170. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 20:17:56', '2025-02-27 20:17:56', 100000062, '2025-02-27', 40, 0, 0);
  1171. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 20:47:57', '2025-02-27 20:47:57', 100000063, '2025-02-27', 41, 0, 0);
  1172. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 21:17:57', '2025-02-27 21:17:57', 100000064, '2025-02-27', 42, 0, 0);
  1173. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 21:47:57', '2025-02-27 21:47:57', 100000065, '2025-02-27', 43, 0, 0);
  1174. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 22:17:57', '2025-02-27 22:17:57', 100000066, '2025-02-27', 44, 0, 0);
  1175. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 22:47:57', '2025-02-27 22:47:57', 100000067, '2025-02-27', 45, 0, 0);
  1176. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 23:17:58', '2025-02-27 23:17:58', 100000068, '2025-02-27', 46, 0, 0);
  1177. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-27 23:47:58', '2025-02-27 23:47:58', 100000069, '2025-02-27', 47, 0, 0);
  1178. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 00:17:58', '2025-02-28 00:17:58', 100000070, '2025-02-28', 0, 0, 0);
  1179. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 00:47:59', '2025-02-28 00:47:59', 100000071, '2025-02-28', 1, 0, 0);
  1180. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 01:17:59', '2025-02-28 01:17:59', 100000072, '2025-02-28', 2, 0, 0);
  1181. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 01:47:59', '2025-02-28 01:47:59', 100000073, '2025-02-28', 3, 0, 0);
  1182. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 02:17:59', '2025-02-28 02:17:59', 100000074, '2025-02-28', 4, 0, 0);
  1183. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 02:47:59', '2025-02-28 02:47:59', 100000075, '2025-02-28', 5, 0, 0);
  1184. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 03:18:00', '2025-02-28 03:18:00', 100000076, '2025-02-28', 6, 0, 0);
  1185. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 03:48:00', '2025-02-28 03:48:00', 100000077, '2025-02-28', 7, 0, 0);
  1186. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 04:18:00', '2025-02-28 04:18:00', 100000078, '2025-02-28', 8, 0, 0);
  1187. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 04:48:00', '2025-02-28 04:48:00', 100000079, '2025-02-28', 9, 0, 0);
  1188. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 05:18:01', '2025-02-28 05:18:01', 100000080, '2025-02-28', 10, 0, 0);
  1189. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 05:48:01', '2025-02-28 05:48:01', 100000081, '2025-02-28', 11, 0, 0);
  1190. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 06:18:01', '2025-02-28 06:18:01', 100000082, '2025-02-28', 12, 0, 0);
  1191. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 06:48:01', '2025-02-28 06:48:01', 100000083, '2025-02-28', 13, 0, 0);
  1192. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 07:18:02', '2025-02-28 07:18:02', 100000084, '2025-02-28', 14, 0, 0);
  1193. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 07:48:02', '2025-02-28 07:48:02', 100000085, '2025-02-28', 15, 0, 0);
  1194. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 08:18:02', '2025-02-28 08:18:02', 100000086, '2025-02-28', 16, 0, 0);
  1195. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 08:48:02', '2025-02-28 08:48:02', 100000087, '2025-02-28', 17, 0, 0);
  1196. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 09:18:03', '2025-02-28 09:18:03', 100000088, '2025-02-28', 18, 0, 0);
  1197. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 09:48:03', '2025-02-28 09:48:03', 100000089, '2025-02-28', 19, 0, 0);
  1198. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 10:18:03', '2025-02-28 10:18:03', 100000090, '2025-02-28', 20, 0, 0);
  1199. INSERT INTO `player_online_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `online_num`, `new_online_num`) VALUES ('2025-02-28 10:48:03', '2025-02-28 10:48:03', 100000091, '2025-02-28', 21, 0, 0);
  1200. COMMIT;
  1201. -- ----------------------------
  1202. -- Table structure for player_recharge_log
  1203. -- ----------------------------
  1204. DROP TABLE IF EXISTS `player_recharge_log`;
  1205. CREATE TABLE `player_recharge_log` (
  1206. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1207. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1208. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1209. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1210. `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  1211. `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
  1212. `level` int(11) DEFAULT '0' COMMENT '等级',
  1213. `recharge_time` datetime DEFAULT NULL COMMENT '充值时间',
  1214. `born_time` datetime DEFAULT NULL COMMENT '创号时间',
  1215. `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
  1216. `money` bigint(20) DEFAULT '0' COMMENT '真实支付金额',
  1217. PRIMARY KEY (`id`)
  1218. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家充值日志表,用于统计LTV';
  1219. -- ----------------------------
  1220. -- Records of player_recharge_log
  1221. -- ----------------------------
  1222. BEGIN;
  1223. COMMIT;
  1224. -- ----------------------------
  1225. -- Table structure for player_scatter_log
  1226. -- ----------------------------
  1227. DROP TABLE IF EXISTS `player_scatter_log`;
  1228. CREATE TABLE `player_scatter_log` (
  1229. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1230. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1231. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1232. `date` int(11) DEFAULT '0' COMMENT '年月日',
  1233. `time_period` int(11) DEFAULT '0' COMMENT '时间段',
  1234. `time_period_text` varchar(255) DEFAULT '' COMMENT '时间段文本',
  1235. `online_num` int(11) DEFAULT '0' COMMENT '时间段人数',
  1236. `online_base` int(11) DEFAULT '0' COMMENT '时间段基数',
  1237. PRIMARY KEY (`id`)
  1238. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家在线分布日志表';
  1239. -- ----------------------------
  1240. -- Records of player_scatter_log
  1241. -- ----------------------------
  1242. BEGIN;
  1243. INSERT INTO `player_scatter_log` (`insert_time`, `update_time`, `id`, `date`, `time_period`, `time_period_text`, `online_num`, `online_base`) VALUES ('2024-11-22 13:11:15', '2024-11-22 13:11:15', 100000001, 20241121, 900, '10-15分钟', 1, 2);
  1244. INSERT INTO `player_scatter_log` (`insert_time`, `update_time`, `id`, `date`, `time_period`, `time_period_text`, `online_num`, `online_base`) VALUES ('2024-11-22 13:11:15', '2024-11-22 13:11:15', 100000002, 20241121, 7200, '1-2小时', 1, 2);
  1245. COMMIT;
  1246. -- ----------------------------
  1247. -- Table structure for player_time_log
  1248. -- ----------------------------
  1249. DROP TABLE IF EXISTS `player_time_log`;
  1250. CREATE TABLE `player_time_log` (
  1251. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1252. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1253. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1254. `date_str` varchar(255) DEFAULT '' COMMENT '日期时间',
  1255. `time_period` varchar(255) DEFAULT '' COMMENT '时间段',
  1256. `min_online` int(11) DEFAULT '0' COMMENT '最低在线人数',
  1257. `max_online` int(11) DEFAULT '0' COMMENT '最高在线人数',
  1258. `create_num` int(11) DEFAULT '0' COMMENT '创建账号数',
  1259. `login_num` int(11) DEFAULT '0' COMMENT '登录账号数',
  1260. PRIMARY KEY (`id`)
  1261. ) ENGINE=InnoDB AUTO_INCREMENT=100000097 DEFAULT CHARSET=utf8mb4 COMMENT='分时注册与在线统计表';
  1262. -- ----------------------------
  1263. -- Records of player_time_log
  1264. -- ----------------------------
  1265. BEGIN;
  1266. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 18:20:17', '2024-11-21 18:20:17', 100000001, '2024-11-21', '18:20', 0, 0, 0, 0);
  1267. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 18:32:35', '2024-11-21 18:32:35', 100000002, '2024-11-21', '18:31', 0, 0, 0, 0);
  1268. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 19:01:05', '2024-11-21 19:01:05', 100000003, '2024-11-21', '19:00', 0, 0, 0, 0);
  1269. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 19:30:05', '2024-11-21 19:30:05', 100000004, '2024-11-21', '19:30', 0, 0, 0, 0);
  1270. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 19:30:30', '2024-11-21 19:30:30', 100000005, '2024-11-21', '19:30', 0, 0, 0, 0);
  1271. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 19:45:02', '2024-11-21 19:45:02', 100000006, '2024-11-21', '19:45', 0, 0, 0, 0);
  1272. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 20:00:09', '2024-11-21 20:00:09', 100000007, '2024-11-21', '20:00', 0, 0, 0, 0);
  1273. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 20:35:30', '2024-11-21 20:35:30', 100000008, '2024-11-21', '20:35', 0, 0, 0, 0);
  1274. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 21:06:10', '2024-11-21 21:06:10', 100000009, '2024-11-21', '21:06', 0, 0, 0, 0);
  1275. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 21:30:29', '2024-11-21 21:30:29', 100000010, '2024-11-21', '21:30', 0, 0, 0, 0);
  1276. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 22:01:11', '2024-11-21 22:01:11', 100000011, '2024-11-21', '22:01', 0, 0, 0, 0);
  1277. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 22:38:11', '2024-11-21 22:38:11', 100000012, '2024-11-21', '22:38', 0, 0, 0, 0);
  1278. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 23:03:31', '2024-11-21 23:03:31', 100000013, '2024-11-21', '23:03', 0, 0, 0, 0);
  1279. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-21 23:34:11', '2024-11-21 23:34:11', 100000014, '2024-11-21', '23:34', 0, 0, 0, 0);
  1280. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 00:04:50', '2024-11-22 00:04:50', 100000015, '2024-11-22', '00:04', 0, 0, 0, 0);
  1281. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 00:35:30', '2024-11-22 00:35:30', 100000016, '2024-11-22', '00:35', 0, 0, 0, 0);
  1282. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 01:06:13', '2024-11-22 01:06:13', 100000017, '2024-11-22', '01:06', 0, 0, 0, 0);
  1283. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 01:31:33', '2024-11-22 01:31:33', 100000018, '2024-11-22', '01:31', 0, 0, 0, 0);
  1284. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 02:02:12', '2024-11-22 02:02:12', 100000019, '2024-11-22', '02:02', 0, 0, 0, 0);
  1285. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 02:32:52', '2024-11-22 02:32:52', 100000020, '2024-11-22', '02:32', 0, 0, 0, 0);
  1286. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 03:03:32', '2024-11-22 03:03:32', 100000021, '2024-11-22', '03:03', 0, 0, 0, 0);
  1287. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 03:34:14', '2024-11-22 03:34:14', 100000022, '2024-11-22', '03:34', 0, 0, 0, 0);
  1288. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 04:11:16', '2024-11-22 04:11:16', 100000023, '2024-11-22', '04:05', 0, 0, 0, 0);
  1289. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 04:30:16', '2024-11-22 04:30:16', 100000024, '2024-11-22', '04:30', 0, 0, 0, 0);
  1290. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 05:00:56', '2024-11-22 05:00:56', 100000025, '2024-11-22', '05:00', 0, 0, 0, 0);
  1291. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 05:31:35', '2024-11-22 05:31:35', 100000026, '2024-11-22', '05:31', 0, 0, 0, 0);
  1292. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 06:08:35', '2024-11-22 06:08:35', 100000027, '2024-11-22', '06:08', 0, 0, 0, 0);
  1293. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 06:39:18', '2024-11-22 06:39:18', 100000028, '2024-11-22', '06:33', 0, 0, 0, 0);
  1294. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 07:04:37', '2024-11-22 07:04:37', 100000029, '2024-11-22', '07:04', 0, 0, 0, 0);
  1295. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 07:35:18', '2024-11-22 07:35:18', 100000030, '2024-11-22', '07:35', 0, 0, 0, 0);
  1296. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 08:05:58', '2024-11-22 08:05:58', 100000031, '2024-11-22', '08:05', 0, 0, 0, 0);
  1297. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 08:36:38', '2024-11-22 08:36:38', 100000032, '2024-11-22', '08:36', 0, 0, 0, 0);
  1298. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 09:02:57', '2024-11-22 09:02:57', 100000033, '2024-11-22', '09:01', 0, 0, 0, 0);
  1299. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 09:30:57', '2024-11-22 09:30:57', 100000034, '2024-11-22', '09:30', 0, 0, 0, 0);
  1300. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 10:00:57', '2024-11-22 10:00:57', 100000035, '2024-11-22', '10:00', 0, 0, 0, 0);
  1301. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 10:30:57', '2024-11-22 10:30:57', 100000036, '2024-11-22', '10:30', 0, 0, 0, 0);
  1302. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 11:00:58', '2024-11-22 11:00:58', 100000037, '2024-11-22', '11:00', 0, 0, 0, 0);
  1303. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 11:31:04', '2024-11-22 11:31:04', 100000038, '2024-11-22', '11:30', 0, 1, 0, 1);
  1304. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 12:11:04', '2024-11-22 12:11:04', 100000039, '2024-11-22', '12:05', 1, 2, 1, 1);
  1305. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 12:36:24', '2024-11-22 12:36:24', 100000040, '2024-11-22', '12:36', 1, 1, 0, 0);
  1306. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 13:00:43', '2024-11-22 13:00:43', 100000041, '2024-11-22', '13:00', 1, 1, 0, 0);
  1307. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2024-11-22 13:11:15', '2024-11-22 13:11:15', 100000042, '2024-11-22', '13:11', 0, 1, 0, 0);
  1308. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 09:45:01', '2025-02-27 09:45:01', 100000043, '2025-02-27', '09:45', 0, 0, 0, 0);
  1309. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 09:46:54', '2025-02-27 09:46:54', 100000044, '2025-02-27', '09:46', 0, 0, 0, 0);
  1310. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 09:47:25', '2025-02-27 09:47:25', 100000045, '2025-02-27', '09:47', 0, 0, 0, 0);
  1311. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 10:00:25', '2025-02-27 10:00:25', 100000046, '2025-02-27', '10:00', 0, 0, 0, 0);
  1312. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 10:30:38', '2025-02-27 10:30:38', 100000047, '2025-02-27', '10:30', 0, 0, 0, 0);
  1313. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 11:00:38', '2025-02-27 11:00:38', 100000048, '2025-02-27', '11:00', 0, 0, 0, 0);
  1314. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 11:30:38', '2025-02-27 11:30:38', 100000049, '2025-02-27', '11:30', 0, 0, 0, 0);
  1315. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 12:00:39', '2025-02-27 12:00:39', 100000050, '2025-02-27', '12:00', 0, 0, 0, 0);
  1316. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 12:30:39', '2025-02-27 12:30:39', 100000051, '2025-02-27', '12:30', 0, 0, 0, 0);
  1317. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 13:00:39', '2025-02-27 13:00:39', 100000052, '2025-02-27', '13:00', 0, 0, 0, 0);
  1318. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 13:30:39', '2025-02-27 13:30:39', 100000053, '2025-02-27', '13:30', 0, 0, 0, 0);
  1319. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 14:00:40', '2025-02-27 14:00:40', 100000054, '2025-02-27', '14:00', 0, 0, 0, 0);
  1320. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 14:30:40', '2025-02-27 14:30:40', 100000055, '2025-02-27', '14:30', 0, 0, 0, 0);
  1321. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 15:00:40', '2025-02-27 15:00:40', 100000056, '2025-02-27', '15:00', 0, 0, 0, 0);
  1322. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 15:30:40', '2025-02-27 15:30:40', 100000057, '2025-02-27', '15:30', 0, 0, 0, 0);
  1323. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 16:00:41', '2025-02-27 16:00:41', 100000058, '2025-02-27', '16:00', 0, 0, 0, 0);
  1324. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 16:30:41', '2025-02-27 16:30:41', 100000059, '2025-02-27', '16:30', 0, 0, 0, 0);
  1325. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 17:00:41', '2025-02-27 17:00:41', 100000060, '2025-02-27', '17:00', 0, 0, 0, 0);
  1326. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 17:30:41', '2025-02-27 17:30:41', 100000061, '2025-02-27', '17:30', 0, 0, 0, 0);
  1327. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 18:00:42', '2025-02-27 18:00:42', 100000062, '2025-02-27', '18:00', 0, 0, 0, 0);
  1328. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 18:30:42', '2025-02-27 18:30:42', 100000063, '2025-02-27', '18:30', 0, 0, 0, 0);
  1329. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 19:00:42', '2025-02-27 19:00:42', 100000064, '2025-02-27', '19:00', 0, 0, 0, 0);
  1330. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 19:30:42', '2025-02-27 19:30:42', 100000065, '2025-02-27', '19:30', 0, 0, 0, 0);
  1331. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 20:00:42', '2025-02-27 20:00:42', 100000066, '2025-02-27', '20:00', 0, 0, 0, 0);
  1332. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 20:30:43', '2025-02-27 20:30:43', 100000067, '2025-02-27', '20:30', 0, 0, 0, 0);
  1333. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 21:00:43', '2025-02-27 21:00:43', 100000068, '2025-02-27', '21:00', 0, 0, 0, 0);
  1334. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 21:30:43', '2025-02-27 21:30:43', 100000069, '2025-02-27', '21:30', 0, 0, 0, 0);
  1335. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 22:00:43', '2025-02-27 22:00:43', 100000070, '2025-02-27', '22:00', 0, 0, 0, 0);
  1336. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 22:30:43', '2025-02-27 22:30:43', 100000071, '2025-02-27', '22:30', 0, 0, 0, 0);
  1337. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 23:00:44', '2025-02-27 23:00:44', 100000072, '2025-02-27', '23:00', 0, 0, 0, 0);
  1338. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-27 23:30:44', '2025-02-27 23:30:44', 100000073, '2025-02-27', '23:30', 0, 0, 0, 0);
  1339. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 00:00:44', '2025-02-28 00:00:44', 100000074, '2025-02-28', '00:00', 0, 0, 0, 0);
  1340. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 00:30:45', '2025-02-28 00:30:45', 100000075, '2025-02-28', '00:30', 0, 0, 0, 0);
  1341. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 01:00:45', '2025-02-28 01:00:45', 100000076, '2025-02-28', '01:00', 0, 0, 0, 0);
  1342. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 01:30:45', '2025-02-28 01:30:45', 100000077, '2025-02-28', '01:30', 0, 0, 0, 0);
  1343. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 02:00:45', '2025-02-28 02:00:45', 100000078, '2025-02-28', '02:00', 0, 0, 0, 0);
  1344. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 02:30:45', '2025-02-28 02:30:45', 100000079, '2025-02-28', '02:30', 0, 0, 0, 0);
  1345. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 03:00:46', '2025-02-28 03:00:46', 100000080, '2025-02-28', '03:00', 0, 0, 0, 0);
  1346. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 03:30:46', '2025-02-28 03:30:46', 100000081, '2025-02-28', '03:30', 0, 0, 0, 0);
  1347. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 04:00:46', '2025-02-28 04:00:46', 100000082, '2025-02-28', '04:00', 0, 0, 0, 0);
  1348. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 04:30:46', '2025-02-28 04:30:46', 100000083, '2025-02-28', '04:30', 0, 0, 0, 0);
  1349. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 05:00:47', '2025-02-28 05:00:47', 100000084, '2025-02-28', '05:00', 0, 0, 0, 0);
  1350. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 05:30:47', '2025-02-28 05:30:47', 100000085, '2025-02-28', '05:30', 0, 0, 0, 0);
  1351. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 06:00:47', '2025-02-28 06:00:47', 100000086, '2025-02-28', '06:00', 0, 0, 0, 0);
  1352. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 06:30:47', '2025-02-28 06:30:47', 100000087, '2025-02-28', '06:30', 0, 0, 0, 0);
  1353. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 07:00:48', '2025-02-28 07:00:48', 100000088, '2025-02-28', '07:00', 0, 0, 0, 0);
  1354. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 07:30:48', '2025-02-28 07:30:48', 100000089, '2025-02-28', '07:30', 0, 0, 0, 0);
  1355. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 08:00:48', '2025-02-28 08:00:48', 100000090, '2025-02-28', '08:00', 0, 0, 0, 0);
  1356. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 08:30:48', '2025-02-28 08:30:48', 100000091, '2025-02-28', '08:30', 0, 0, 0, 0);
  1357. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 09:00:49', '2025-02-28 09:00:49', 100000092, '2025-02-28', '09:00', 0, 0, 0, 0);
  1358. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 09:30:49', '2025-02-28 09:30:49', 100000093, '2025-02-28', '09:30', 0, 0, 0, 0);
  1359. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 10:00:49', '2025-02-28 10:00:49', 100000094, '2025-02-28', '10:00', 0, 0, 0, 0);
  1360. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 10:30:49', '2025-02-28 10:30:49', 100000095, '2025-02-28', '10:30', 0, 0, 0, 0);
  1361. INSERT INTO `player_time_log` (`insert_time`, `update_time`, `id`, `date_str`, `time_period`, `min_online`, `max_online`, `create_num`, `login_num`) VALUES ('2025-02-28 11:00:50', '2025-02-28 11:00:50', 100000096, '2025-02-28', '11:00', 0, 0, 0, 0);
  1362. COMMIT;
  1363. -- ----------------------------
  1364. -- Table structure for promotion_control_end
  1365. -- ----------------------------
  1366. DROP TABLE IF EXISTS `promotion_control_end`;
  1367. CREATE TABLE `promotion_control_end` (
  1368. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1369. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1370. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  1371. `logic_type` int(11) DEFAULT '0' COMMENT '活动逻辑类型',
  1372. `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  1373. `name` varchar(255) DEFAULT '' COMMENT '活动名字',
  1374. `stage` varchar(255) DEFAULT '' COMMENT '活动所在阶段',
  1375. `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  1376. `still_time` datetime DEFAULT NULL COMMENT '沉寂时间',
  1377. `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  1378. `idle_time` datetime DEFAULT NULL COMMENT '空闲时间',
  1379. `settled` char(5) DEFAULT 'false' COMMENT '是否已结算',
  1380. `control_id` bigint(20) DEFAULT '0' COMMENT '原活动控制ID',
  1381. `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  1382. `config_id` int(11) DEFAULT '0' COMMENT '使用的配置ID',
  1383. PRIMARY KEY (`id`)
  1384. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='已结束的活动控制表';
  1385. -- ----------------------------
  1386. -- Records of promotion_control_end
  1387. -- ----------------------------
  1388. BEGIN;
  1389. COMMIT;
  1390. -- ----------------------------
  1391. -- Table structure for purgatory_points_log_202411
  1392. -- ----------------------------
  1393. DROP TABLE IF EXISTS `purgatory_points_log_202411`;
  1394. CREATE TABLE `purgatory_points_log_202411` (
  1395. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1396. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1397. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1398. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1399. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1400. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1401. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1402. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1403. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1404. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1405. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1406. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1407. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1408. PRIMARY KEY (`id`)
  1409. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
  1410. -- ----------------------------
  1411. -- Records of purgatory_points_log_202411
  1412. -- ----------------------------
  1413. BEGIN;
  1414. COMMIT;
  1415. -- ----------------------------
  1416. -- Table structure for purgatory_points_log_202502
  1417. -- ----------------------------
  1418. DROP TABLE IF EXISTS `purgatory_points_log_202502`;
  1419. CREATE TABLE `purgatory_points_log_202502` (
  1420. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1421. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1422. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1423. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1424. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1425. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1426. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1427. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1428. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1429. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1430. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1431. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1432. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1433. PRIMARY KEY (`id`)
  1434. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
  1435. -- ----------------------------
  1436. -- Records of purgatory_points_log_202502
  1437. -- ----------------------------
  1438. BEGIN;
  1439. COMMIT;
  1440. -- ----------------------------
  1441. -- Table structure for recruit_points_log_202411
  1442. -- ----------------------------
  1443. DROP TABLE IF EXISTS `recruit_points_log_202411`;
  1444. CREATE TABLE `recruit_points_log_202411` (
  1445. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1446. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1447. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1448. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1449. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1450. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1451. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1452. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1453. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1454. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1455. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1456. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1457. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1458. PRIMARY KEY (`id`)
  1459. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募积分日志表';
  1460. -- ----------------------------
  1461. -- Records of recruit_points_log_202411
  1462. -- ----------------------------
  1463. BEGIN;
  1464. COMMIT;
  1465. -- ----------------------------
  1466. -- Table structure for recruit_points_log_202502
  1467. -- ----------------------------
  1468. DROP TABLE IF EXISTS `recruit_points_log_202502`;
  1469. CREATE TABLE `recruit_points_log_202502` (
  1470. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1471. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1472. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1473. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1474. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1475. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1476. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1477. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1478. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1479. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1480. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1481. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1482. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1483. PRIMARY KEY (`id`)
  1484. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募积分日志表';
  1485. -- ----------------------------
  1486. -- Records of recruit_points_log_202502
  1487. -- ----------------------------
  1488. BEGIN;
  1489. COMMIT;
  1490. -- ----------------------------
  1491. -- Table structure for recruit_prize_draw_log_202411
  1492. -- ----------------------------
  1493. DROP TABLE IF EXISTS `recruit_prize_draw_log_202411`;
  1494. CREATE TABLE `recruit_prize_draw_log_202411` (
  1495. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1496. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1497. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
  1498. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1499. `multiple` int(11) DEFAULT '0' COMMENT '招募的倍数',
  1500. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1501. `date_str` varchar(255) DEFAULT '' COMMENT '日期',
  1502. PRIMARY KEY (`id`)
  1503. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募抽取次数日志表';
  1504. -- ----------------------------
  1505. -- Records of recruit_prize_draw_log_202411
  1506. -- ----------------------------
  1507. BEGIN;
  1508. COMMIT;
  1509. -- ----------------------------
  1510. -- Table structure for recruit_prize_draw_log_202502
  1511. -- ----------------------------
  1512. DROP TABLE IF EXISTS `recruit_prize_draw_log_202502`;
  1513. CREATE TABLE `recruit_prize_draw_log_202502` (
  1514. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1515. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1516. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
  1517. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1518. `multiple` int(11) DEFAULT '0' COMMENT '招募的倍数',
  1519. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1520. `date_str` varchar(255) DEFAULT '' COMMENT '日期',
  1521. PRIMARY KEY (`id`)
  1522. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募抽取次数日志表';
  1523. -- ----------------------------
  1524. -- Records of recruit_prize_draw_log_202502
  1525. -- ----------------------------
  1526. BEGIN;
  1527. COMMIT;
  1528. -- ----------------------------
  1529. -- Table structure for recruit_refresh_log_202411
  1530. -- ----------------------------
  1531. DROP TABLE IF EXISTS `recruit_refresh_log_202411`;
  1532. CREATE TABLE `recruit_refresh_log_202411` (
  1533. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1534. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1535. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
  1536. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1537. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1538. `refresh_type` int(11) DEFAULT '0' COMMENT '刷新方式',
  1539. `date_str` varchar(255) DEFAULT '' COMMENT '日期',
  1540. PRIMARY KEY (`id`)
  1541. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募手刷次数日志表';
  1542. -- ----------------------------
  1543. -- Records of recruit_refresh_log_202411
  1544. -- ----------------------------
  1545. BEGIN;
  1546. COMMIT;
  1547. -- ----------------------------
  1548. -- Table structure for recruit_refresh_log_202502
  1549. -- ----------------------------
  1550. DROP TABLE IF EXISTS `recruit_refresh_log_202502`;
  1551. CREATE TABLE `recruit_refresh_log_202502` (
  1552. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1553. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1554. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
  1555. `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  1556. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1557. `refresh_type` int(11) DEFAULT '0' COMMENT '刷新方式',
  1558. `date_str` varchar(255) DEFAULT '' COMMENT '日期',
  1559. PRIMARY KEY (`id`)
  1560. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募手刷次数日志表';
  1561. -- ----------------------------
  1562. -- Records of recruit_refresh_log_202502
  1563. -- ----------------------------
  1564. BEGIN;
  1565. COMMIT;
  1566. -- ----------------------------
  1567. -- Table structure for server_resume_log
  1568. -- ----------------------------
  1569. DROP TABLE IF EXISTS `server_resume_log`;
  1570. CREATE TABLE `server_resume_log` (
  1571. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1572. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1573. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1574. `date_str` varchar(255) DEFAULT '' COMMENT '日期',
  1575. `player_num` bigint(20) DEFAULT '0' COMMENT '总玩家数',
  1576. `new_player_num` bigint(20) DEFAULT '0' COMMENT '新玩家数',
  1577. `login_player_num` bigint(20) DEFAULT '0' COMMENT '登录玩家数',
  1578. `login_num` bigint(20) DEFAULT '0' COMMENT '登录次数',
  1579. `old_login_num` bigint(20) DEFAULT '0' COMMENT '去新登录玩家数',
  1580. `recharge_num` bigint(20) DEFAULT '0' COMMENT '充值金额',
  1581. `recharge_player_num` bigint(20) DEFAULT '0' COMMENT '充值人数',
  1582. `recharge_for_diamond` bigint(20) DEFAULT '0' COMMENT '直购钻石金额',
  1583. PRIMARY KEY (`id`),
  1584. UNIQUE KEY `date_str` (`date_str`) USING BTREE
  1585. ) ENGINE=InnoDB AUTO_INCREMENT=100000005 DEFAULT CHARSET=utf8mb4 COMMENT='游戏汇总日志表';
  1586. -- ----------------------------
  1587. -- Records of server_resume_log
  1588. -- ----------------------------
  1589. BEGIN;
  1590. INSERT INTO `server_resume_log` (`insert_time`, `update_time`, `id`, `date_str`, `player_num`, `new_player_num`, `login_player_num`, `login_num`, `old_login_num`, `recharge_num`, `recharge_player_num`, `recharge_for_diamond`) VALUES ('2024-11-21 18:31:36', '2024-11-21 18:31:36', 100000001, '20241120', 0, 0, 0, 0, 0, 0, 0, 0);
  1591. INSERT INTO `server_resume_log` (`insert_time`, `update_time`, `id`, `date_str`, `player_num`, `new_player_num`, `login_player_num`, `login_num`, `old_login_num`, `recharge_num`, `recharge_player_num`, `recharge_for_diamond`) VALUES ('2024-11-22 00:04:32', '2024-11-22 00:04:32', 100000002, '20241121', 0, 0, 0, 0, 0, 0, 0, 0);
  1592. INSERT INTO `server_resume_log` (`insert_time`, `update_time`, `id`, `date_str`, `player_num`, `new_player_num`, `login_player_num`, `login_num`, `old_login_num`, `recharge_num`, `recharge_player_num`, `recharge_for_diamond`) VALUES ('2025-02-27 09:47:25', '2025-02-27 09:47:25', 100000003, '20250226', 2, 0, 0, 0, 0, 0, 0, 0);
  1593. INSERT INTO `server_resume_log` (`insert_time`, `update_time`, `id`, `date_str`, `player_num`, `new_player_num`, `login_player_num`, `login_num`, `old_login_num`, `recharge_num`, `recharge_player_num`, `recharge_for_diamond`) VALUES ('2025-02-28 00:00:06', '2025-02-28 00:00:06', 100000004, '20250227', 2, 0, 0, 0, 0, 0, 0, 0);
  1594. COMMIT;
  1595. -- ----------------------------
  1596. -- Table structure for village_202411
  1597. -- ----------------------------
  1598. DROP TABLE IF EXISTS `village_202411`;
  1599. CREATE TABLE `village_202411` (
  1600. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1601. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1602. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1603. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1604. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1605. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1606. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1607. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1608. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1609. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1610. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1611. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1612. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1613. PRIMARY KEY (`id`)
  1614. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='村庄积分日志表';
  1615. -- ----------------------------
  1616. -- Records of village_202411
  1617. -- ----------------------------
  1618. BEGIN;
  1619. COMMIT;
  1620. -- ----------------------------
  1621. -- Table structure for village_202502
  1622. -- ----------------------------
  1623. DROP TABLE IF EXISTS `village_202502`;
  1624. CREATE TABLE `village_202502` (
  1625. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1626. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1627. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1628. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1629. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1630. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1631. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1632. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1633. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1634. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1635. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1636. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1637. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1638. PRIMARY KEY (`id`)
  1639. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='村庄积分日志表';
  1640. -- ----------------------------
  1641. -- Records of village_202502
  1642. -- ----------------------------
  1643. BEGIN;
  1644. COMMIT;
  1645. -- ----------------------------
  1646. -- Table structure for week_point_log_202411
  1647. -- ----------------------------
  1648. DROP TABLE IF EXISTS `week_point_log_202411`;
  1649. CREATE TABLE `week_point_log_202411` (
  1650. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1651. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1652. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1653. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1654. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1655. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1656. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1657. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1658. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1659. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1660. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1661. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1662. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1663. PRIMARY KEY (`id`)
  1664. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='周常活跃度日志表';
  1665. -- ----------------------------
  1666. -- Records of week_point_log_202411
  1667. -- ----------------------------
  1668. BEGIN;
  1669. COMMIT;
  1670. -- ----------------------------
  1671. -- Table structure for week_point_log_202502
  1672. -- ----------------------------
  1673. DROP TABLE IF EXISTS `week_point_log_202502`;
  1674. CREATE TABLE `week_point_log_202502` (
  1675. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1676. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1677. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1678. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1679. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1680. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1681. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1682. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1683. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1684. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1685. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1686. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1687. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1688. PRIMARY KEY (`id`)
  1689. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='周常活跃度日志表';
  1690. -- ----------------------------
  1691. -- Records of week_point_log_202502
  1692. -- ----------------------------
  1693. BEGIN;
  1694. COMMIT;
  1695. -- ----------------------------
  1696. -- Table structure for wood_log_202411
  1697. -- ----------------------------
  1698. DROP TABLE IF EXISTS `wood_log_202411`;
  1699. CREATE TABLE `wood_log_202411` (
  1700. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1701. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1702. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1703. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1704. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1705. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1706. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1707. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1708. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1709. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1710. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1711. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1712. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1713. PRIMARY KEY (`id`)
  1714. ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='木日志表';
  1715. -- ----------------------------
  1716. -- Records of wood_log_202411
  1717. -- ----------------------------
  1718. BEGIN;
  1719. INSERT INTO `wood_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:05', '2024-11-22 11:39:05', 100000001, 335879897874434, '方昊乾', 4, '木', 5, 5, 400005, '完成主线任务', '2024-11-22 11:38:05', '');
  1720. INSERT INTO `wood_log_202411` (`insert_time`, `update_time`, `id`, `owner_id`, `owner_name`, `thing_id`, `thing_name`, `delta`, `curr`, `game_cause`, `game_cause_text`, `time`, `remark`) VALUES ('2024-11-22 11:39:05', '2024-11-22 11:39:05', 100000002, 335879897874434, '方昊乾', 4, '木', -5, 0, 400002, '迷雾开启', '2024-11-22 11:38:09', '');
  1721. COMMIT;
  1722. -- ----------------------------
  1723. -- Table structure for wood_log_202502
  1724. -- ----------------------------
  1725. DROP TABLE IF EXISTS `wood_log_202502`;
  1726. CREATE TABLE `wood_log_202502` (
  1727. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1728. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1729. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1730. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1731. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1732. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1733. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1734. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1735. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1736. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1737. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1738. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1739. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1740. PRIMARY KEY (`id`)
  1741. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='木日志表';
  1742. -- ----------------------------
  1743. -- Records of wood_log_202502
  1744. -- ----------------------------
  1745. BEGIN;
  1746. COMMIT;
  1747. -- ----------------------------
  1748. -- Table structure for zhan_ling_exp_log_202411
  1749. -- ----------------------------
  1750. DROP TABLE IF EXISTS `zhan_ling_exp_log_202411`;
  1751. CREATE TABLE `zhan_ling_exp_log_202411` (
  1752. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1753. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1754. `old_level` int(11) DEFAULT '0' COMMENT '原等级',
  1755. `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
  1756. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1757. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1758. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1759. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1760. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1761. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1762. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1763. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1764. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1765. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1766. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1767. PRIMARY KEY (`id`)
  1768. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='战令经验日志表';
  1769. -- ----------------------------
  1770. -- Records of zhan_ling_exp_log_202411
  1771. -- ----------------------------
  1772. BEGIN;
  1773. COMMIT;
  1774. -- ----------------------------
  1775. -- Table structure for zhan_ling_exp_log_202502
  1776. -- ----------------------------
  1777. DROP TABLE IF EXISTS `zhan_ling_exp_log_202502`;
  1778. CREATE TABLE `zhan_ling_exp_log_202502` (
  1779. `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  1780. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  1781. `old_level` int(11) DEFAULT '0' COMMENT '原等级',
  1782. `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
  1783. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  1784. `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
  1785. `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
  1786. `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
  1787. `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
  1788. `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
  1789. `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
  1790. `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  1791. `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  1792. `time` datetime DEFAULT NULL COMMENT '发生时间',
  1793. `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
  1794. PRIMARY KEY (`id`)
  1795. ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='战令经验日志表';
  1796. -- ----------------------------
  1797. -- Records of zhan_ling_exp_log_202502
  1798. -- ----------------------------
  1799. BEGIN;
  1800. COMMIT;
  1801. SET FOREIGN_KEY_CHECKS = 1;