查看日志: sanguobw_test_4/log/dbinitlog_2025_8_20.txt
总行数: 1812
当前页: 5/19
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'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_medal_up` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' ,
`medal_type` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '勋章类型' ,
`old_lv` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原等级' ,
`new_lv` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '新等级' ,
`cost_goods_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗道具id' ,
`cost_goods_num` 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 `time` (`time`),
INDEX `medal_type` (`medal_type`),
INDEX `role_id` (`role_id`)
)
COMMENT='勋章升级日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb