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

)
COMMENT='跨服消费榜5日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_cost_rank_six` (
`id` int(11) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '自增id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`role_name` varchar(32) NOT NULL  DEFAULT ''  COMMENT '玩家名字' ,
`server_id` int(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '显示服id' ,
`cost` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费数' ,
`rank` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '排名' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '操作时间' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `rank`  (`rank`),
INDEX `role_id`  (`role_id`)
)
COMMENT='跨服消费榜6日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_smelt_chip` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_chip` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧熔炼碎片' ,
`new_chip` 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_smelt_chip` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_chip` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧熔炼碎片' ,
`new_chip` 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_produce_tianshuexp` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_exp` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原来天书经验' ,
`new_exp` 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_produce_king_integral` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_king_integral` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧王者积分' ,
`new_king_integral` 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_king_integral` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_king_integral` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧王者积分' ,
`new_king_integral` 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_produce_fairy_stamps` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,