查看日志: sanguobw_test_2/log/dbinitlog_2025_8_13.txt

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
;
CREATE TABLE IF NOT EXISTS `log_produce_t_soul` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魂魄值' ,
`new_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魂魄值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出类型' ,
PRIMARY KEY (`id`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='法宝魂魄值产出日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_t_soul` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧魂魄值' ,
`new_soul` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新魂魄值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`consume_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消耗类型' ,
PRIMARY KEY (`id`),
INDEX `consume_type`  (`consume_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='法宝魂魄值消耗日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_exp` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_lev` smallint(6) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原来等级' ,
`old_exp` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原来经验' ,
`new_lev` smallint(6) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '现在等级' ,
`new_exp` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '现在经验' ,
`get_exp` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '获得经验' ,
`type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '时间' ,
`type_str` varchar(60) NOT NULL  DEFAULT ''  COMMENT '类型字符串' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`)
)
COMMENT='经验日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_online` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`online_num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '总在线' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '时间戳' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`)
)
COMMENT='在线人数统计'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_honor` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_value` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧值' ,
`new_value` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '新值' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
`produce_type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '产出类型' ,
PRIMARY KEY (`id`),
INDEX `produce_type`  (`produce_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='法宝魂魄值产出日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_honor` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_value` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧值' ,