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

`price` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '价格' ,
`sell_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '发布求购玩家id' ,
PRIMARY KEY (`id`),
INDEX `base_id`  (`base_id`),
INDEX `buy_id`  (`buy_id`),
INDEX `id`  (`id`)
)
COMMENT='求购出售日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_sword_up` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`old_lv` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '旧值' ,
`new_lv` 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 '操作时间' ,
PRIMARY KEY (`id`),
INDEX `role_id`  (`role_id`)
)
COMMENT='剑池系统升级操作日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_guild_create` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`player_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '创建人id' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '创建时间' ,
`init_lv` tinyint(1) UNSIGNED  NOT NULL  DEFAULT '1'  COMMENT '初始等级' ,
PRIMARY KEY (`id`),
INDEX `player_id`  (`player_id`)
)
COMMENT='帮派创建日志'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_consume_donate` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`old_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费前帮贡' ,
`new_donate` 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 `guild_id`  (`guild_id`),
INDEX `time`  (`time`),
INDEX `consume_type`  (`consume_type`),
INDEX `role_id`  (`role_id`)
)
COMMENT='帮贡消费日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_produce_donate` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家id' ,
`guild_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '帮派id' ,
`old_donate` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '消费前帮贡' ,
`new_donate` 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 `guild_id`  (`guild_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_exploit` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原功勋' ,
`new_expoit` 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_exploit` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT '编号' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`old_expoit` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '原功勋' ,
`new_expoit` 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`),