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

;
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 '旧值' ,
`new_value` 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 `p_log_gamedata` (
`id` bigint(20) NOT NULL  AUTO_INCREMENT  COMMENT '主键' ,
`time` int(11) NOT NULL  DEFAULT '0'  COMMENT '时间戳（秒），每天记录一次' ,
`accountnum` int(11) NOT NULL  DEFAULT '0'  COMMENT '总账号数' ,
`heronum` int(11) NOT NULL  DEFAULT '0'  COMMENT '总角色数' ,
`newaccount` int(11) NOT NULL  DEFAULT '0'  COMMENT '当天新账号数' ,
`newhero` int(11) NOT NULL  DEFAULT '0'  COMMENT '当天新角色数' ,
`loginnum` int(11) NOT NULL  DEFAULT '0'  COMMENT '当天登陆角色数' ,
`recharge` int(11) NOT NULL  DEFAULT '0'  COMMENT '当天充值' ,