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}}]