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

)
COMMENT='剑池系统升级操作日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_guild_create` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`player_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '创建人id' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '创建时间' ,
`init_lv` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '1'  COMMENT '初始等级' ,
PRIMARY KEY (`id`),
INDEX `player_id`  (`player_id`)
)
COMMENT='帮派创建日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_donate` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`old_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费前帮贡' ,
`new_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费后帮贡' ,
`consume_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费时间' ,
PRIMARY KEY (`id`),
INDEX `guild_id`  (`guild_id`),
INDEX `time`  (`time`),
INDEX `consume_type`  (`consume_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='帮贡消费日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_donate` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`old_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费前帮贡' ,
`new_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费后帮贡' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费时间' ,
PRIMARY KEY (`id`),
INDEX `guild_id`  (`guild_id`),
INDEX `time`  (`time`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='帮贡产出日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_exploit` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原功勋' ,
`new_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新功勋' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产时间' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='功勋(比武大会)产出日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_exploit` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原功勋' ,
`new_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新功勋' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产时间' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='功勋(比武大会)消耗日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_guildwar_score` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_guildwar_score` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原帮战积分' ,
`new_guildwar_score` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新帮战积分' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '生产时间' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='帮战积分产出日志表'
COLLATE='utf8_general_ci'