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

COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_summer_discount` (
`id` bigint(20) UNSIGNED  NOT NULL  AUTO_INCREMENT  COMMENT 'id' ,
`role_id` bigint(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '角色ID' ,
`config_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '对应配置表里的唯一id' ,
`time` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  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_op_questionnaire` (
`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 '玩家名字' ,
`round` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '第几轮活动' ,
`lv` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '玩家等级' ,
`server_id` int(20) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '显示服id' ,
`open_id` varchar(100) NOT NULL  DEFAULT ''  COMMENT 'open_id' ,
`vip` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '开始VIP等级' ,
`question_id` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '题目id' ,
`question_num` int(11) UNSIGNED  NOT NULL  DEFAULT '0'  COMMENT '题目编号' ,
`chose_answer` text NOT NULL  COMMENT '选择题答案' ,
`write_answer` text NOT NULL  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_kf_cost_rank_two` (
`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='跨服消费榜2日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_cost_rank_three` (
`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='跨服消费榜3日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_cost_rank_four` (
`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='跨服消费榜4日志表'
COLLATE='utf8_general_ci'
ENGINE=Innodb
;
CREATE TABLE IF NOT EXISTS `log_kf_cost_rank_five` (
`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`)