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

COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_intimacy` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_intimacy` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧亲密度值' ,
`new_intimacy` 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 `ban_info` (
`id` int(10) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '禁止序号' ,
`type` smallint(5) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '禁止类型(1:ip)' ,
`value` varchar(20) NOT NULL  COMMENT '禁止的值' ,
PRIMARY KEY (`id`),
INDEX `value`  (`value`),
INDEX `type`  (`type`)
)
COMMENT=''
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_cost_rank` (
`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='跨服消费榜日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_recharge_rank` (
`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' ,
`recharge` 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='跨服充值榜日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_change_sex` (
`id` int(11) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '自增id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`old_sex` varchar(32) NOT NULL  DEFAULT ''  COMMENT '改前性别' ,
`new_sex` varchar(32) NOT NULL  DEFAULT ''  COMMENT '改后性别' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '时间' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='改性别日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_hefu_consume_rank` (
`id` int(11) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '自增id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`day` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '活动天数' ,
`consume` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费时间' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='改性别日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_summer_kf_xiangou` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`type` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '物品类型' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '更新时间' ,
PRIMARY KEY (`id`),
INDEX `time`  (`time`),
INDEX `role_id`  (`role_id`)
)
COMMENT='夏日活动全服限购'