查看日志: sanguobw_test_2/log/dbinitlog_2025_8_13.txt
总行数: 1832
当前页: 5/19
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'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_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'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_lilian` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`old_lilian` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原历练积分' ,
`new_lilian` 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_lilian` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`old_lilian` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原历练积分' ,
`new_lilian` 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_shengwang` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`old_shengwang` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原声望积分' ,
`new_shengwang` 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_shengwang` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`old_shengwang` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原声望积分' ,
`new_shengwang` 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'