| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924 |
- /*
- Navicat Premium Data Transfer
- Source Server : 192.168.3.245
- Source Server Type : MySQL
- Source Server Version : 50727 (5.7.27)
- Source Host : 192.168.3.245:33061
- Source Schema : x1_4_log
- Target Server Type : MySQL
- Target Server Version : 50727 (5.7.27)
- File Encoding : 65001
- Date: 05/03/2025 09:32:31
- */
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for achievement_point_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `achievement_point_log_202411`;
- CREATE TABLE `achievement_point_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='成就点数日志表';
- -- ----------------------------
- -- Records of achievement_point_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for achievement_point_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `achievement_point_log_202502`;
- CREATE TABLE `achievement_point_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='成就点数日志表';
- -- ----------------------------
- -- Records of achievement_point_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for day_point_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `day_point_log_202411`;
- CREATE TABLE `day_point_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日常活跃度日志表';
- -- ----------------------------
- -- Records of day_point_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for day_point_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `day_point_log_202502`;
- CREATE TABLE `day_point_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='日常活跃度日志表';
- -- ----------------------------
- -- Records of day_point_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for diamond_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `diamond_log_202411`;
- CREATE TABLE `diamond_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='钻石日志表';
- -- ----------------------------
- -- Records of diamond_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for diamond_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `diamond_log_202502`;
- CREATE TABLE `diamond_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='钻石日志表';
- -- ----------------------------
- -- Records of diamond_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for equip_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `equip_log_202411`;
- CREATE TABLE `equip_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `instance_id` bigint(20) DEFAULT '0' COMMENT '实物的ID',
- `instance_data` text COMMENT '实物的数据',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='装备日志表';
- -- ----------------------------
- -- Records of equip_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for equip_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `equip_log_202502`;
- CREATE TABLE `equip_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `instance_id` bigint(20) DEFAULT '0' COMMENT '实物的ID',
- `instance_data` text COMMENT '实物的数据',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='装备日志表';
- -- ----------------------------
- -- Records of equip_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for evil_catalog_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `evil_catalog_log_202411`;
- CREATE TABLE `evil_catalog_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='妖录日志表';
- -- ----------------------------
- -- Records of evil_catalog_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for evil_catalog_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `evil_catalog_log_202502`;
- CREATE TABLE `evil_catalog_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='妖录日志表';
- -- ----------------------------
- -- Records of evil_catalog_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for evil_speedup_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `evil_speedup_log_202411`;
- CREATE TABLE `evil_speedup_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
- -- ----------------------------
- -- Records of evil_speedup_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for evil_speedup_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `evil_speedup_log_202502`;
- CREATE TABLE `evil_speedup_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
- -- ----------------------------
- -- Records of evil_speedup_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for gold_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `gold_log_202411`;
- CREATE TABLE `gold_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='金币日志表';
- -- ----------------------------
- -- Records of gold_log_202411
- -- ----------------------------
- BEGIN;
- 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', '');
- 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', '');
- COMMIT;
- -- ----------------------------
- -- Table structure for gold_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `gold_log_202502`;
- CREATE TABLE `gold_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='金币日志表';
- -- ----------------------------
- -- Records of gold_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for guide_dot
- -- ----------------------------
- DROP TABLE IF EXISTS `guide_dot`;
- CREATE TABLE `guide_dot` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `guide_id` int(11) DEFAULT '0' COMMENT '指引ID',
- `guide_name` varchar(255) DEFAULT '' COMMENT '指引名称',
- `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `step` int(11) DEFAULT '0' COMMENT '步骤',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000012 DEFAULT CHARSET=utf8mb4 COMMENT='引导打点表';
- -- ----------------------------
- -- Records of guide_dot
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for hero_fighting_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `hero_fighting_log_202411`;
- CREATE TABLE `hero_fighting_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `hero_id` bigint(20) DEFAULT '0' COMMENT '英雄ID',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='英雄战力变化日志表';
- -- ----------------------------
- -- Records of hero_fighting_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for hero_fighting_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `hero_fighting_log_202502`;
- CREATE TABLE `hero_fighting_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `hero_id` bigint(20) DEFAULT '0' COMMENT '英雄ID',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='英雄战力变化日志表';
- -- ----------------------------
- -- Records of hero_fighting_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for hero_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `hero_log_202411`;
- CREATE TABLE `hero_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000004 DEFAULT CHARSET=utf8mb4 COMMENT='英雄日志表';
- -- ----------------------------
- -- Records of hero_log_202411
- -- ----------------------------
- BEGIN;
- 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', '');
- 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', '');
- 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', '');
- COMMIT;
- -- ----------------------------
- -- Table structure for hero_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `hero_log_202502`;
- CREATE TABLE `hero_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='英雄日志表';
- -- ----------------------------
- -- Records of hero_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for item_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `item_log_202411`;
- CREATE TABLE `item_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='道具日志表';
- -- ----------------------------
- -- Records of item_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for item_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `item_log_202502`;
- CREATE TABLE `item_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='道具日志表';
- -- ----------------------------
- -- Records of item_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mail_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `mail_log_202411`;
- CREATE TABLE `mail_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `ori_mail_id` bigint(20) DEFAULT '0' COMMENT '原邮件ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '玩家名字',
- `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
- `title_args` varchar(2500) DEFAULT '' COMMENT '标题参数',
- `content_args` varchar(2500) DEFAULT '' COMMENT '内容参数',
- `attachment` varchar(2500) DEFAULT '' COMMENT '附件',
- `read` char(5) DEFAULT 'false' COMMENT '是否已读',
- `receive` char(5) DEFAULT 'false' COMMENT '是否已领',
- `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `from_pool_id` bigint(20) DEFAULT '0' COMMENT '来自哪个系统邮件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件日志表';
- -- ----------------------------
- -- Records of mail_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mail_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `mail_log_202502`;
- CREATE TABLE `mail_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `ori_mail_id` bigint(20) DEFAULT '0' COMMENT '原邮件ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '玩家名字',
- `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
- `title_args` varchar(2500) DEFAULT '' COMMENT '标题参数',
- `content_args` varchar(2500) DEFAULT '' COMMENT '内容参数',
- `attachment` varchar(2500) DEFAULT '' COMMENT '附件',
- `read` char(5) DEFAULT 'false' COMMENT '是否已读',
- `receive` char(5) DEFAULT 'false' COMMENT '是否已领',
- `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `from_pool_id` bigint(20) DEFAULT '0' COMMENT '来自哪个系统邮件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='邮件日志表';
- -- ----------------------------
- -- Records of mail_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mainline_boss_dot
- -- ----------------------------
- DROP TABLE IF EXISTS `mainline_boss_dot`;
- CREATE TABLE `mainline_boss_dot` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `boss_id` int(11) DEFAULT '0' COMMENT '领主ID',
- `boss_name` varchar(255) DEFAULT '' COMMENT '领主名称',
- `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
- `timing` int(11) DEFAULT '0' COMMENT '时机',
- `level` int(11) DEFAULT '0' COMMENT '领主等级',
- PRIMARY KEY (`id`),
- KEY `boss_id` (`boss_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='主线BOSS打点表';
- -- ----------------------------
- -- Records of mainline_boss_dot
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mainline_fog_dot
- -- ----------------------------
- DROP TABLE IF EXISTS `mainline_fog_dot`;
- CREATE TABLE `mainline_fog_dot` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `fog_id` int(11) DEFAULT '0' COMMENT '迷雾ID',
- `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
- `level` int(11) DEFAULT '0' COMMENT '等级',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000002 DEFAULT CHARSET=utf8mb4 COMMENT='主线迷雾解锁打点表';
- -- ----------------------------
- -- Records of mainline_fog_dot
- -- ----------------------------
- BEGIN;
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for mainline_task_dot
- -- ----------------------------
- DROP TABLE IF EXISTS `mainline_task_dot`;
- CREATE TABLE `mainline_task_dot` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `task_id` int(11) DEFAULT '0' COMMENT '任务ID',
- `task_name` varchar(255) DEFAULT '' COMMENT '任务名称',
- `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `timing` int(11) DEFAULT '0' COMMENT '打点时机',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000009 DEFAULT CHARSET=utf8mb4 COMMENT='主线任务打点表';
- -- ----------------------------
- -- Records of mainline_task_dot
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for meat_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `meat_log_202411`;
- CREATE TABLE `meat_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000063 DEFAULT CHARSET=utf8mb4 COMMENT='肉日志表';
- -- ----------------------------
- -- Records of meat_log_202411
- -- ----------------------------
- BEGIN;
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- COMMIT;
- -- ----------------------------
- -- Table structure for meat_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `meat_log_202502`;
- CREATE TABLE `meat_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='肉日志表';
- -- ----------------------------
- -- Records of meat_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mine_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `mine_log_202411`;
- CREATE TABLE `mine_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='矿日志表';
- -- ----------------------------
- -- Records of mine_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for mine_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `mine_log_202502`;
- CREATE TABLE `mine_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='矿日志表';
- -- ----------------------------
- -- Records of mine_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for player_create_log
- -- ----------------------------
- DROP TABLE IF EXISTS `player_create_log`;
- CREATE TABLE `player_create_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
- `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
- `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
- `born_time` datetime DEFAULT NULL COMMENT '创号时间',
- `ip` varchar(255) DEFAULT '' COMMENT '创号IP',
- `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家创号日志表';
- -- ----------------------------
- -- Records of player_create_log
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for player_exp_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `player_exp_log_202411`;
- CREATE TABLE `player_exp_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `old_level` int(11) DEFAULT '0' COMMENT '原等级',
- `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000062 DEFAULT CHARSET=utf8mb4 COMMENT='玩家经验日志表';
- -- ----------------------------
- -- Records of player_exp_log_202411
- -- ----------------------------
- BEGIN;
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- COMMIT;
- -- ----------------------------
- -- Table structure for player_exp_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `player_exp_log_202502`;
- CREATE TABLE `player_exp_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `old_level` int(11) DEFAULT '0' COMMENT '原等级',
- `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家经验日志表';
- -- ----------------------------
- -- Records of player_exp_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for player_fighting_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `player_fighting_log_202411`;
- CREATE TABLE `player_fighting_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家战斗力变化日志表';
- -- ----------------------------
- -- Records of player_fighting_log_202411
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for player_fighting_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `player_fighting_log_202502`;
- CREATE TABLE `player_fighting_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家战斗力变化日志表';
- -- ----------------------------
- -- Records of player_fighting_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for player_login_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `player_login_log_202411`;
- CREATE TABLE `player_login_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
- `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
- `level` int(11) DEFAULT '0' COMMENT '等级',
- `login_time` datetime DEFAULT NULL COMMENT '登录时间',
- `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
- `born_time` datetime DEFAULT NULL COMMENT '创号时间',
- `ip` varchar(255) DEFAULT '' COMMENT '登录IP',
- `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
- `create_pay` int(11) DEFAULT '0' COMMENT '是否创号当天有充值',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000006 DEFAULT CHARSET=utf8mb4 COMMENT='玩家登录日志表';
- -- ----------------------------
- -- Records of player_login_log_202411
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for player_login_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `player_login_log_202502`;
- CREATE TABLE `player_login_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
- `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
- `level` int(11) DEFAULT '0' COMMENT '等级',
- `login_time` datetime DEFAULT NULL COMMENT '登录时间',
- `device_type` varchar(10) DEFAULT '' COMMENT '客户端类型,ANDROID,IOS,H5',
- `born_time` datetime DEFAULT NULL COMMENT '创号时间',
- `ip` varchar(255) DEFAULT '' COMMENT '登录IP',
- `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
- `create_pay` int(11) DEFAULT '0' COMMENT '是否创号当天有充值',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家登录日志表';
- -- ----------------------------
- -- Records of player_login_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for player_online_log
- -- ----------------------------
- DROP TABLE IF EXISTS `player_online_log`;
- CREATE TABLE `player_online_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期时间',
- `time_period` int(11) DEFAULT '0' COMMENT '时间段',
- `online_num` int(11) DEFAULT '0' COMMENT '在线人数',
- `new_online_num` int(11) DEFAULT '0' COMMENT '在线新人数',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000092 DEFAULT CHARSET=utf8mb4 COMMENT='每5分钟打点的在线人数表';
- -- ----------------------------
- -- Records of player_online_log
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for player_recharge_log
- -- ----------------------------
- DROP TABLE IF EXISTS `player_recharge_log`;
- CREATE TABLE `player_recharge_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
- `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
- `level` int(11) DEFAULT '0' COMMENT '等级',
- `recharge_time` datetime DEFAULT NULL COMMENT '充值时间',
- `born_time` datetime DEFAULT NULL COMMENT '创号时间',
- `channel_id` int(11) DEFAULT '0' COMMENT '渠道ID',
- `money` bigint(20) DEFAULT '0' COMMENT '真实支付金额',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='玩家充值日志表,用于统计LTV';
- -- ----------------------------
- -- Records of player_recharge_log
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for player_scatter_log
- -- ----------------------------
- DROP TABLE IF EXISTS `player_scatter_log`;
- CREATE TABLE `player_scatter_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `date` int(11) DEFAULT '0' COMMENT '年月日',
- `time_period` int(11) DEFAULT '0' COMMENT '时间段',
- `time_period_text` varchar(255) DEFAULT '' COMMENT '时间段文本',
- `online_num` int(11) DEFAULT '0' COMMENT '时间段人数',
- `online_base` int(11) DEFAULT '0' COMMENT '时间段基数',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='玩家在线分布日志表';
- -- ----------------------------
- -- Records of player_scatter_log
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for player_time_log
- -- ----------------------------
- DROP TABLE IF EXISTS `player_time_log`;
- CREATE TABLE `player_time_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期时间',
- `time_period` varchar(255) DEFAULT '' COMMENT '时间段',
- `min_online` int(11) DEFAULT '0' COMMENT '最低在线人数',
- `max_online` int(11) DEFAULT '0' COMMENT '最高在线人数',
- `create_num` int(11) DEFAULT '0' COMMENT '创建账号数',
- `login_num` int(11) DEFAULT '0' COMMENT '登录账号数',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000097 DEFAULT CHARSET=utf8mb4 COMMENT='分时注册与在线统计表';
- -- ----------------------------
- -- Records of player_time_log
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for promotion_control_end
- -- ----------------------------
- DROP TABLE IF EXISTS `promotion_control_end`;
- CREATE TABLE `promotion_control_end` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
- `logic_type` int(11) DEFAULT '0' COMMENT '活动逻辑类型',
- `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
- `name` varchar(255) DEFAULT '' COMMENT '活动名字',
- `stage` varchar(255) DEFAULT '' COMMENT '活动所在阶段',
- `start_time` datetime DEFAULT NULL COMMENT '开始时间',
- `still_time` datetime DEFAULT NULL COMMENT '沉寂时间',
- `end_time` datetime DEFAULT NULL COMMENT '结束时间',
- `idle_time` datetime DEFAULT NULL COMMENT '空闲时间',
- `settled` char(5) DEFAULT 'false' COMMENT '是否已结算',
- `control_id` bigint(20) DEFAULT '0' COMMENT '原活动控制ID',
- `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
- `config_id` int(11) DEFAULT '0' COMMENT '使用的配置ID',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='已结束的活动控制表';
- -- ----------------------------
- -- Records of promotion_control_end
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for purgatory_points_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `purgatory_points_log_202411`;
- CREATE TABLE `purgatory_points_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
- -- ----------------------------
- -- Records of purgatory_points_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for purgatory_points_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `purgatory_points_log_202502`;
- CREATE TABLE `purgatory_points_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='炼狱积分日志表';
- -- ----------------------------
- -- Records of purgatory_points_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_points_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_points_log_202411`;
- CREATE TABLE `recruit_points_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募积分日志表';
- -- ----------------------------
- -- Records of recruit_points_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_points_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_points_log_202502`;
- CREATE TABLE `recruit_points_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募积分日志表';
- -- ----------------------------
- -- Records of recruit_points_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_prize_draw_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_prize_draw_log_202411`;
- CREATE TABLE `recruit_prize_draw_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `multiple` int(11) DEFAULT '0' COMMENT '招募的倍数',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募抽取次数日志表';
- -- ----------------------------
- -- Records of recruit_prize_draw_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_prize_draw_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_prize_draw_log_202502`;
- CREATE TABLE `recruit_prize_draw_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `multiple` int(11) DEFAULT '0' COMMENT '招募的倍数',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募抽取次数日志表';
- -- ----------------------------
- -- Records of recruit_prize_draw_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_refresh_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_refresh_log_202411`;
- CREATE TABLE `recruit_refresh_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `refresh_type` int(11) DEFAULT '0' COMMENT '刷新方式',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募手刷次数日志表';
- -- ----------------------------
- -- Records of recruit_refresh_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for recruit_refresh_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `recruit_refresh_log_202502`;
- CREATE TABLE `recruit_refresh_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一Id',
- `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `refresh_type` int(11) DEFAULT '0' COMMENT '刷新方式',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='招募手刷次数日志表';
- -- ----------------------------
- -- Records of recruit_refresh_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for server_resume_log
- -- ----------------------------
- DROP TABLE IF EXISTS `server_resume_log`;
- CREATE TABLE `server_resume_log` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `date_str` varchar(255) DEFAULT '' COMMENT '日期',
- `player_num` bigint(20) DEFAULT '0' COMMENT '总玩家数',
- `new_player_num` bigint(20) DEFAULT '0' COMMENT '新玩家数',
- `login_player_num` bigint(20) DEFAULT '0' COMMENT '登录玩家数',
- `login_num` bigint(20) DEFAULT '0' COMMENT '登录次数',
- `old_login_num` bigint(20) DEFAULT '0' COMMENT '去新登录玩家数',
- `recharge_num` bigint(20) DEFAULT '0' COMMENT '充值金额',
- `recharge_player_num` bigint(20) DEFAULT '0' COMMENT '充值人数',
- `recharge_for_diamond` bigint(20) DEFAULT '0' COMMENT '直购钻石金额',
- PRIMARY KEY (`id`),
- UNIQUE KEY `date_str` (`date_str`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=100000005 DEFAULT CHARSET=utf8mb4 COMMENT='游戏汇总日志表';
- -- ----------------------------
- -- Records of server_resume_log
- -- ----------------------------
- BEGIN;
- 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);
- 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);
- 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);
- 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);
- COMMIT;
- -- ----------------------------
- -- Table structure for village_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `village_202411`;
- CREATE TABLE `village_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='村庄积分日志表';
- -- ----------------------------
- -- Records of village_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for village_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `village_202502`;
- CREATE TABLE `village_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='村庄积分日志表';
- -- ----------------------------
- -- Records of village_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for week_point_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `week_point_log_202411`;
- CREATE TABLE `week_point_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='周常活跃度日志表';
- -- ----------------------------
- -- Records of week_point_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for week_point_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `week_point_log_202502`;
- CREATE TABLE `week_point_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='周常活跃度日志表';
- -- ----------------------------
- -- Records of week_point_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for wood_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `wood_log_202411`;
- CREATE TABLE `wood_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='木日志表';
- -- ----------------------------
- -- Records of wood_log_202411
- -- ----------------------------
- BEGIN;
- 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', '');
- 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', '');
- COMMIT;
- -- ----------------------------
- -- Table structure for wood_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `wood_log_202502`;
- CREATE TABLE `wood_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='木日志表';
- -- ----------------------------
- -- Records of wood_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for zhan_ling_exp_log_202411
- -- ----------------------------
- DROP TABLE IF EXISTS `zhan_ling_exp_log_202411`;
- CREATE TABLE `zhan_ling_exp_log_202411` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `old_level` int(11) DEFAULT '0' COMMENT '原等级',
- `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='战令经验日志表';
- -- ----------------------------
- -- Records of zhan_ling_exp_log_202411
- -- ----------------------------
- BEGIN;
- COMMIT;
- -- ----------------------------
- -- Table structure for zhan_ling_exp_log_202502
- -- ----------------------------
- DROP TABLE IF EXISTS `zhan_ling_exp_log_202502`;
- CREATE TABLE `zhan_ling_exp_log_202502` (
- `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
- `update_time` datetime DEFAULT NULL COMMENT '更新时间',
- `old_level` int(11) DEFAULT '0' COMMENT '原等级',
- `curr_level` int(11) DEFAULT '0' COMMENT '当前等级',
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
- `owner_id` bigint(20) DEFAULT '0' COMMENT '持有者ID',
- `owner_name` varchar(255) DEFAULT '' COMMENT '持有者名字',
- `thing_id` int(11) DEFAULT '0' COMMENT '物品标识',
- `thing_name` varchar(255) DEFAULT '' COMMENT '物品名称',
- `delta` bigint(20) DEFAULT '0' COMMENT '变化量',
- `curr` bigint(20) DEFAULT '0' COMMENT '变化后的当前量',
- `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
- `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
- `time` datetime DEFAULT NULL COMMENT '发生时间',
- `remark` varchar(255) DEFAULT '' COMMENT '备注信息',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='战令经验日志表';
- -- ----------------------------
- -- Records of zhan_ling_exp_log_202502
- -- ----------------------------
- BEGIN;
- COMMIT;
- SET FOREIGN_KEY_CHECKS = 1;
|