查看日志: sanguobw_test_4/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}}]