查看日志: sanguobw_test_6/log/dbinitlog_2026_9_15.txt

总行数: 34 当前页: 1/1
下载完整日志
dbtools start run in [{{2026,9,15},{12,6,48}}]

CREATE TABLE IF NOT EXISTS `log_guild_war` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '日志ID' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID(0=军团汇总行)' ,
`role_name` varchar(128) NULL  DEFAULT ''  COMMENT '角色名称' ,
`account` varchar(256) NULL  DEFAULT ''  COMMENT '账号' ,
`product_name` varchar(128) NULL  DEFAULT ''  COMMENT '产品名称' ,
`platform_name` varchar(64) NULL  DEFAULT ''  COMMENT '平台名称' ,
`gameserver_no` int(11) UNSIGNED  NULL  DEFAULT '0'  COMMENT '游戏服务器编号' ,
`channel` varchar(64) NULL  DEFAULT ''  COMMENT '渠道' ,
`zone_id` int(11) UNSIGNED  NULL  DEFAULT '0'  COMMENT '大区ID' ,
`level` int(11) UNSIGNED  NULL  DEFAULT '0'  COMMENT '角色等级' ,
`vip_level` int(11) UNSIGNED  NULL  DEFAULT '0'  COMMENT 'VIP等级' ,
`date_time` varchar(64) NULL  DEFAULT ''  COMMENT '操作时间' ,
`mode` varchar(16) NULL  DEFAULT ''  COMMENT '本服/跨服' ,
`guild_id` bigint(20) UNSIGNED  NULL  DEFAULT '0'  COMMENT '军团ID' ,
`guild_name` varchar(128) NULL  DEFAULT ''  COMMENT '军团名' ,
`event_type` varchar(32) NULL  DEFAULT ''  COMMENT '事件类型(挑战/结算/开宝箱/开箱失败/宝箱清理/跨服排行奖)' ,
`event` varchar(128) NULL  DEFAULT ''  COMMENT '事件' ,
`info` varchar(1024) NULL  DEFAULT ''  COMMENT '详细信息' ,
`reward` varchar(512) NULL  DEFAULT ''  COMMENT '奖励内容' ,
`created_at` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '记录创建时间' ,
PRIMARY KEY (`id`),
INDEX `idx_created_at`  (`created_at`),
INDEX `idx_guild_id`  (`guild_id`),
INDEX `idx_role_id`  (`role_id`)
)
COMMENT='军团战日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
dbtools over in [{{2026,9,15},{12,6,50}}]