dbtools start run in [{{2025,8,20},{13,42,13}}] CREATE TABLE IF NOT EXISTS `node` ( `gs_type` varchar(20) NOT NULL DEFAULT '' COMMENT '启动类型' , `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip地址' , `port` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '端口号' , `node` varchar(100) NOT NULL DEFAULT '' COMMENT '节点' , `cookie` varchar(100) NULL DEFAULT '' COMMENT 'cookie' , PRIMARY KEY (`gs_type`) ) COMMENT='节点' COLLATE='utf8_general_ci' ENGINE=Innodb ; ALTER TABLE `role_login` MODIFY COLUMN `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id'; alter table `role_login` add column `zone_aid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分区唯一Id' ; alter table `role_login` add column `reg_channel` varchar(255) NOT NULL DEFAULT '' COMMENT '注冊渠道' ; alter table `role_login` add column `device_id` varchar(255) NOT NULL DEFAULT '' COMMENT '设备号' ; alter table `role_login` add column `dispense` varchar(255) NOT NULL DEFAULT '' COMMENT '分发号' ; alter table `role_login` add column `device_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '设备类型' ; ALTER TABLE `role_login` DROP COLUMN `sid`; ALTER TABLE `role_login` DROP INDEX `zone_unique`; ALTER TABLE `role_login` ADD INDEX `zone_index` (`account`,`zone_aid`); CREATE TABLE IF NOT EXISTS `role` ( `id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'id' , `name` varchar(32) NOT NULL DEFAULT '' COMMENT '姓名' , `first_charge_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上次充值时间' , `last_charge_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后一次充值时间' , PRIMARY KEY (`id`), INDEX `last_charge_time` (`last_charge_time`), INDEX `first_charge_time` (`first_charge_time`), INDEX `name` (`name`) ) COMMENT='玩家信息，给后台显示用' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `zj_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `accname` varchar(60) NOT NULL DEFAULT '' COMMENT '帐号' , `password` varchar(60) NOT NULL DEFAULT '' COMMENT '密码' , `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间' , PRIMARY KEY (`id`), UNIQUE INDEX `username` (`accname`) ) COMMENT='专家表' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_item_use` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `type` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '类型' , `item_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品ID' , `item_num` int(11) 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 `item_id` (`item_id`), INDEX `role_id` (`role_id`) ) COMMENT='物品使用日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_item` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `type` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '类型' , `item_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品类型ID' , `item_num` int(11) 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 `role_id` (`role_id`), INDEX `item_id` (`item_id`), INDEX `type` (`type`), INDEX `time` (`time`) ) COMMENT='物品产出日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_consume_coin` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费时间' , `consume_type` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费类型，1为购买' , `cost_coin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗铜钱' , `cost_bcoin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗绑定的铜钱' , `remain_coin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '铜钱余额' , `remain_bcoin` 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`), INDEX `consume_type` (`consume_type`) ) COMMENT='铜钱消费日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_consume_gold` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费时间' , `consume_type` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消费类型，1为购买' , `cost_gold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗元宝' , `cost_bgold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗绑定元宝' , `remain_gold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '元宝余额' , `remain_bgold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '绑定元宝余额' , `type_str` varchar(60) NOT NULL DEFAULT '' COMMENT '类型字符串' , `spent` int(11) NOT NULL DEFAULT '0' COMMENT '' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '账号' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , PRIMARY KEY (`id`), INDEX `time` (`time`), INDEX `role_id` (`role_id`), INDEX `consume_type` (`consume_type`) ) COMMENT='元宝消费日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_produce_gold` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产时间' , `produce_type` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产类型' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `got_gold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产金币' , `got_bgold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产银两' , `remain_gold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金币余额' , `remain_bgold` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '银两余额' , `type_str` varchar(60) NOT NULL DEFAULT '' COMMENT '类型字符串' , `spent` int(11) NOT NULL DEFAULT '0' COMMENT '' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '账号' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , PRIMARY KEY (`id`), INDEX `time` (`time`), INDEX `role_id` (`role_id`), INDEX `produce_type` (`produce_type`) ) COMMENT='元宝生产日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_produce_coin` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产时间' , `produce_type` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产类型' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `role_lv` int(6) NOT NULL DEFAULT '0' COMMENT '玩家等级' , `got_coin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产铜钱' , `got_bcoin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生产绑定的铜钱' , `remain_coin` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '铜钱余额' , `remain_bcoin` 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`), INDEX `produce_type` (`produce_type`) ) COMMENT='铜钱生产日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_uplv` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `lv` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级' , `exp` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '当前经验' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '升级时间' , PRIMARY KEY (`id`), INDEX `lv` (`lv`), INDEX `role_id` (`role_id`) ) COMMENT='玩家升级日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_login` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `ip` varchar(100) NOT NULL DEFAULT '' COMMENT '登录IP' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '登录时间' , `vip` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'vip等级' , `isappenter` tinyint(3) 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_task` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家id' , `task_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '任务id' , `log_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '日志类型 0-接收 1-完成' , `role_lv` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家等级' , `task_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '任务类型' , `task_name` varchar(60) NOT NULL DEFAULT '' COMMENT '任务名' , `task_lev` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '任务等级' , `atime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '任务接收时间(没什么用)' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '记录时间' , PRIMARY KEY (`id`), INDEX `task_id` (`task_id`), INDEX `role_id` (`role_id`) ) COMMENT='任务日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_activity_op` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `aid` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '活动id' , `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作类型 1-开启 2-结束 3-发奖励 4-清数据' , `start_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '开始时间' , `end_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '结束时间' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '时间' , PRIMARY KEY (`id`) ) COMMENT='运营活动日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_advance` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家id' , `sys_type` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '进阶系统类型' , `operate_type` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作类型' , `target_id` int(11) 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 '操作时间' , PRIMARY KEY (`id`), INDEX `role_id` (`role_id`) ) COMMENT='进阶系统操作日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_market` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `sell_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '摊主id' , `buy_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '买主id' , `base_id` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买的物品' , `num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '数量' , `price` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '价格' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作时间' , PRIMARY KEY (`id`), INDEX `base_id` (`base_id`), INDEX `buy_id` (`buy_id`), INDEX `sell_id` (`sell_id`) ) COMMENT='市场购买日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_market_request` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `buy_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '买主id' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作时间' , `num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '数量' , `base_id` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买的物品' , `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`), INDEX `role_id` (`role_id`) ) COMMENT='功勋(比武大会)消耗日志表' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_produce_guildwar_score` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_guildwar_score` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原帮战积分' , `new_guildwar_score` 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_guildwar_score` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_guildwar_score` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原帮战积分' , `new_guildwar_score` 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_produce_lilian` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_lilian` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原历练积分' , `new_lilian` 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_lilian` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_lilian` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原历练积分' , `new_lilian` 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_produce_shengwang` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_shengwang` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原声望积分' , `new_shengwang` 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_shengwang` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_shengwang` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原声望积分' , `new_shengwang` 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_medal_up` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `medal_type` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '勋章类型' , `old_lv` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原等级' , `new_lv` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '新等级' , `cost_goods_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消耗道具id' , `cost_goods_num` 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 `time` (`time`), INDEX `medal_type` (`medal_type`), INDEX `role_id` (`role_id`) ) COMMENT='勋章升级日志表' COLLATE='utf8_general_ci' ENGINE=Innodb ; 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 '当天充值' , `sysConsumption` bigint(20) NOT NULL DEFAULT '0' COMMENT '当前系统消费' , `inventory` int(11) NOT NULL DEFAULT '0' COMMENT '当天充值库存' , `sysInventory` bigint(20) NOT NULL DEFAULT '0' COMMENT '当天系统库存' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_goodrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `sysId` int(11) NOT NULL DEFAULT '0' COMMENT '道具或装备Id' , `num` int(11) NOT NULL DEFAULT '0' COMMENT '数量' , `bind` int(11) NOT NULL DEFAULT '0' COMMENT '绑定状态(0不绑定,2绑定)' , `leflnum` int(11) NOT NULL DEFAULT '0' COMMENT '剩余数量' , `reason` int(11) NOT NULL DEFAULT '0' COMMENT '原因（资源流水编号）' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '腾讯openid' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '玩家操作时间' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_instructor` ( `rid` bigint(20) NOT NULL COMMENT '角色ID' , `name` varchar(32) NOT NULL DEFAULT '' COMMENT '游戏角色名' , `realname` varchar(50) NOT NULL DEFAULT '' COMMENT '玩家真实姓名' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '职权类型' , `state` int(11) NOT NULL DEFAULT '0' COMMENT '启用状态; 0: 默认待审核; 1: 启用状态; 2: 暂停状态' , `applyaccount` varchar(100) NOT NULL DEFAULT '' COMMENT '申请人后台账号' , `checkaccount` varchar(100) NOT NULL DEFAULT '' COMMENT '审核人后台账号' , `applytime` int(11) NOT NULL DEFAULT '0' COMMENT '申请时间' , `passtime` int(11) NOT NULL DEFAULT '0' COMMENT '审核通过时间' , `zoneid` int(10) NOT NULL DEFAULT '0' COMMENT '区ID' , PRIMARY KEY (`rid`), INDEX `i_state` (`state`), INDEX `i_type` (`type`) ) COMMENT='游戏内部特殊身份表(GM,新手指导员)' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_levellose` ( `id` int(1) NOT NULL AUTO_INCREMENT COMMENT '主键' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间戳（秒），每天记录一次' , `level` int(11) NOT NULL DEFAULT '0' COMMENT '等级' , `baseNum` int(11) NOT NULL DEFAULT '0' COMMENT '基数' , `reachNum` int(11) NOT NULL DEFAULT '0' COMMENT '到达人数' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_loginfo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `logintime` int(11) NOT NULL DEFAULT '0' COMMENT '登陆时间,格式:20120720' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '登陆时间（秒）' , `regtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `logip` varchar(32) NOT NULL DEFAULT '' COMMENT '登陆ip' , `times` int(11) NOT NULL DEFAULT '0' COMMENT '登陆次数' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '角色账号' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '当天第一次登陆的平台' , `ireldaimond` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关vip' , `ireldaimondlevel` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关vip' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '用户登录时的等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区号' , `rollmark` tinyint(1) NOT NULL DEFAULT '0' COMMENT '滚服标识,0-否，1-是' , `isappenter` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '微端登录' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_loginfolord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `logintime` int(11) NOT NULL DEFAULT '0' COMMENT '登陆时间,格式:20120720' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `logip` varchar(32) NOT NULL DEFAULT '' COMMENT '登陆ip' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '角色账号' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '当天第一次登陆的平台' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '用户登录时的等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区号' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_loginlose` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `cancreate` bigint(20) NOT NULL DEFAULT '0' COMMENT '到达创建角色页面数' , `newhero` int(11) NOT NULL DEFAULT '0' COMMENT '创建角色数' , `ingame` int(11) NOT NULL DEFAULT '0' COMMENT '进入游戏角色数' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '当天时间（秒）' , `newaccount` int(11) NOT NULL DEFAULT '0' COMMENT '新注册账号数' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , PRIMARY KEY (`id`), INDEX `time` (`time`), INDEX `pf` (`pf`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_loginlose_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `accname` varchar(128) NOT NULL DEFAULT '' COMMENT '账号' , `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '进入到哪一步（创建、进入创建角色页，创建角色，进入游戏）' , `pf` varchar(255) NOT NULL DEFAULT 'qzone' COMMENT '平台' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '时间' , `zoneid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分区Id' , `app_custom` varchar(60) NOT NULL DEFAULT '' COMMENT 'app_custom' , `via` varchar(60) NOT NULL DEFAULT '' COMMENT 'via' , `is_market` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否集市用户' , PRIMARY KEY (`id`), INDEX `time` (`time`), INDEX `pf` (`pf`), INDEX `type` (`type`), INDEX `accname` (`accname`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_marketrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `sysId` int(11) NOT NULL DEFAULT '0' COMMENT '道具或装备Id' , `num` int(11) NOT NULL DEFAULT '0' COMMENT '数量' , `bind` int(11) NOT NULL DEFAULT '0' COMMENT '绑定状态(0不绑定,1绑' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '1银两，2元宝' , `yuanbao` int(11) NOT NULL DEFAULT '0' COMMENT '银两与元宝' , `reason` int(11) NOT NULL DEFAULT '0' COMMENT '原因（资源流水编号）' , `sellId` bigint(20) NOT NULL DEFAULT '0' COMMENT '出售玩家ID' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '账号' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '玩家操作时间' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_onlinelog` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `onlineNum` int(11) NOT NULL DEFAULT '0' COMMENT '在线角色数' , `ipNum` int(11) NOT NULL DEFAULT '0' COMMENT 'Ip数' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间戳（秒），每五分钟记录' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb AUTO_INCREMENT=5000000001 ; CREATE TABLE IF NOT EXISTS `p_log_onlinetime` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '时间戳（秒），每天记录一次' , `time` bigint(20) NOT NULL DEFAULT '0' COMMENT '时间戳（秒），每天记录一次' , `min1` int(11) NOT NULL DEFAULT '0' COMMENT '零至一分钟' , `min2` int(11) NOT NULL DEFAULT '0' COMMENT '一至两分钟' , `min3` int(11) NOT NULL DEFAULT '0' COMMENT '两至三分钟' , `min4` int(11) NOT NULL DEFAULT '0' COMMENT '三至四分钟' , `min5` int(11) NOT NULL DEFAULT '0' COMMENT '四至五分钟' , `min6` int(11) NOT NULL DEFAULT '0' COMMENT '五至六分钟' , `min7` int(11) NOT NULL DEFAULT '0' COMMENT '六至七分钟' , `min8` int(11) NOT NULL DEFAULT '0' COMMENT '七至八分钟' , `min9` int(11) NOT NULL DEFAULT '0' COMMENT '八至九分钟' , `min10` int(11) NOT NULL DEFAULT '0' COMMENT '九至十分钟' , `min15` int(11) NOT NULL DEFAULT '0' COMMENT '十至十五分钟' , `min30` int(11) NOT NULL DEFAULT '0' COMMENT '十五至三十分钟' , `min60` int(11) NOT NULL DEFAULT '0' COMMENT '一个小时至两个小时' , `min120` int(11) NOT NULL DEFAULT '0' COMMENT '一个小时至两个小时' , `min240` int(11) NOT NULL DEFAULT '0' COMMENT '两个小时四个小时' , `min480` int(11) NOT NULL DEFAULT '0' COMMENT '四个小时八个小时' , `min500` int(11) NOT NULL DEFAULT '0' COMMENT '八小时以上' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_payaccount` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `time` int(10) NOT NULL DEFAULT '0' COMMENT '时间' , `onePayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '当天充值的所有帐号数' , `oneNewPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '当天新增充值（第一次充值）的帐号数' , `sevenPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '7天内充值的总帐号数，包含今天' , `sevenNewPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '7天内新增充值（第一次充值）的帐号数' , `oneMonPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '一个月内充值的总帐号数量，包含今天' , `oneMonNewPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '一个月内新增充值（第一次充值）的帐号数' , `allPayAcc` int(6) NOT NULL DEFAULT '0' COMMENT '开服第一天至今的所有充值帐号数' , `zoneid` int(6) NOT NULL DEFAULT '0' COMMENT '大区ID' , PRIMARY KEY (`id`), INDEX `index_time` (`time`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_recharge_sum` ( `id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色id' , `total` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总充值金额' , PRIMARY KEY (`id`) ) COMMENT='平台充值统计表（排除使用道具添加元宝）' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_register` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '记录时间' , `newaccount` int(11) NOT NULL DEFAULT '0' COMMENT '新账号数' , `newrole` int(11) NOT NULL DEFAULT '0' COMMENT '新角色数' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区号' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '大渠道(平台)' , `pd` varchar(255) NOT NULL DEFAULT '' COMMENT '小渠道' , PRIMARY KEY (`id`), INDEX `i_pd` (`pd`), INDEX `i_pf` (`pf`), INDEX `i_time` (`time`) ) COMMENT='注册统计表' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_silver_recycle` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `rid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `openid` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家openid' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区id' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '记录时间' , `num` bigint(20) NOT NULL DEFAULT '0' COMMENT '消耗数量' , `sourcetype` smallint(6) NOT NULL DEFAULT '0' COMMENT '来源类型' , `level` smallint(6) NOT NULL DEFAULT '0' COMMENT '消费时的等级' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `pd` varchar(255) NOT NULL DEFAULT '' COMMENT '注册时的子站点' , `curpf` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家在线时的平台' , `curpd` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家在线时的子站点' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `ireldaimond` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员' , `ireldaimondlevel` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员等级' , PRIMARY KEY (`id`), INDEX `i_zoneid` (`zoneid`), INDEX `i_createtime` (`createtime`), INDEX `i_pd` (`pd`), INDEX `i_pf` (`pf`), INDEX `i_sourcetype` (`sourcetype`), INDEX `i_time` (`time`), INDEX `i_rid` (`rid`) ) COMMENT='系统消耗未绑定仙玉表' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_strengthrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `usenum` int(11) NOT NULL DEFAULT '0' COMMENT '得到战力' , `leftnum` int(11) NOT NULL DEFAULT '0' COMMENT '角色当前战力' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '流水编号' , `spent` int(11) NOT NULL DEFAULT '0' COMMENT '消费划分类型' , `ireldaimond` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员' , `ireldaimondlevel` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员等级' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '腾讯openid' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '玩家操作时间' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_tasklose` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间戳（秒），每天记录一次' , `cansee` int(11) NOT NULL DEFAULT '0' COMMENT '可接任务角色数' , `accepted` int(11) NOT NULL DEFAULT '0' COMMENT '已接任务角色数' , `finish` int(11) NOT NULL DEFAULT '0' COMMENT '完成任务角色数' , `commit` int(11) NOT NULL DEFAULT '0' COMMENT '交过任务角色数' , `taskid` int(11) NOT NULL DEFAULT '0' COMMENT '任务id' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区Id' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `acceptLevel` int(11) NOT NULL DEFAULT '0' COMMENT '接受任务的等级' , `taskName` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_user_control` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '监控类型，1:道具，2:绑定仙玉，3:非绑定仙玉' , `userid` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色id' , `level` smallint(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT '等级' , `login_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '登陆ip' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '记录时间' , `zoneid` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '服务器id' , `type_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品类型id' , `num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '拥有数量' , `set_num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '设定监控数量' , PRIMARY KEY (`id`), INDEX `type` (`type`,`userid`,`type_id`) ) COMMENT='玩家物品信息监控' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_ybconsume` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `usenum` int(11) NOT NULL DEFAULT '0' COMMENT '总数量' , `useunbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '数量' , `leftunbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '剩余数量' , `usebindnum` int(11) NOT NULL DEFAULT '0' COMMENT '绑定数量' , `leftbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '剩余绑定数量' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '流水编号(参考资源流水编号表)' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '玩家操作时间' , `spent` int(11) NOT NULL DEFAULT '0' COMMENT '' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '账号' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_ybrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id' , `hid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `usenum` int(11) NOT NULL DEFAULT '0' COMMENT '总数量' , `useunbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '数量' , `leftunbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '剩余数量' , `usebindnum` int(11) NOT NULL DEFAULT '0' COMMENT '绑定数量' , `leftbindnum` int(11) NOT NULL DEFAULT '0' COMMENT '剩余绑定数量' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '流水编号(参考资源流水编号表)' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '玩家操作时间' , `spent` int(11) NOT NULL DEFAULT '0' COMMENT '' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `currentpf` varchar(255) NOT NULL DEFAULT '' COMMENT '消费时平台' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '账号' , `ireldaimond` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员（会员编号表）' , `ireldaimondlevel` int(11) NOT NULL DEFAULT '0' COMMENT 'ireldaimondlevel' , `ilevel` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_yuanbaostats` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '时间' , `totalNum` int(11) NOT NULL DEFAULT '0' COMMENT '总数' , `totalCount` int(11) NOT NULL DEFAULT '0' COMMENT '总次数' , `tolalRole` int(11) NOT NULL DEFAULT '0' COMMENT '总人数' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '分区id' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '流水编号' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_task_add` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `player_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id' , `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务ID' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '' , `kind` int(11) NOT NULL DEFAULT '0' COMMENT '' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_task_finish` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `player_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id' , `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务ID' , `type` int(11) NOT NULL DEFAULT '0' COMMENT '' , `kind` int(11) NOT NULL DEFAULT '0' COMMENT '' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '时间' , PRIMARY KEY (`id`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `payamt_coins` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '' , `openid` varchar(255) NOT NULL DEFAULT '' COMMENT '账号id' , `billno` varchar(255) NOT NULL DEFAULT '' COMMENT '支付流水号,该字段和openid合起来是唯一的' , `payitem` varchar(1000) NOT NULL DEFAULT '' COMMENT '请使用ID*price*num的格式，批量购买套餐物品则用“;”分隔，长度必须<=512字符。' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区号ZONEID' , `time` int(10) NOT NULL DEFAULT '0' COMMENT '充值时间' , `providetype` smallint(2) NOT NULL DEFAULT '0' COMMENT '发货类型，0表示道具购买，1表示营销活动中的道具赠送，2表示交叉营销任务集市中的奖励发放' , `amt` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Q点/Q币消耗金额或财付通游戏子账户的扣款金额，以0.1Q点为单位。这里的amt的值将纳入结算，参与分成' , `payamt_coins` varchar(255) NOT NULL DEFAULT '0' COMMENT '扣取的游戏币总数,单位为Q点。游戏币由平台赠送或由好友打赏，平台赠送的游戏币不纳入结算，即不参与分成；好友打赏的游戏币按消耗量参与结算' , `pubacct_payamt_coins` varchar(255) NULL DEFAULT '0' COMMENT '扣取的抵用券总金额,单位为Q点.金券银券消耗将和Q点消耗一起纳入收益计算' , `paytotal` int(10) NOT NULL DEFAULT '0' COMMENT '总额,单位0.1Q点' , `silver` bigint(20) NOT NULL DEFAULT '0' COMMENT '充值银两(两)' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `ilevel` int(10) NULL DEFAULT '0' COMMENT '充值时等级' , `rollmark` tinyint(1) NULL DEFAULT '0' COMMENT '是否是滚服用户. 0: 新用户, 1: 滚服用户' , `ireldaimond` int(10) NULL DEFAULT '0' COMMENT '平台相关会员' , `ireldaimondlevel` int(10) NULL DEFAULT '0' COMMENT '平台相关会员等级' , `vunreldaimond` varchar(200) NULL DEFAULT '0' COMMENT '平台无关会员(可能多种情况,按照表格位置顺序将编号用”_”分隔)' , `vunreldaimondlevel` varchar(200) NULL DEFAULT '0' COMMENT '平台无关会员等级(多种情况,用”_”分开)' , `rid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色ID' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台来源' , `pd` varchar(255) NOT NULL DEFAULT '' COMMENT '注册子平台来源' , `curpf` varchar(255) NOT NULL DEFAULT '' COMMENT '充值时平台来源' , `curpd` varchar(255) NOT NULL DEFAULT '' COMMENT '充值时子平台来源' , PRIMARY KEY (`id`), UNIQUE INDEX `openid_billno_Index` (`openid`,`billno`), INDEX `index_time` (`time`), INDEX `index_createtime` (`createtime`), INDEX `index_pd` (`pd`), INDEX `index_pf` (`pf`), INDEX `index_rid` (`rid`), INDEX `index_silver` (`silver`), INDEX `ilevel` (`ilevel`) ) COMMENT='腾讯平台对应的充值表' COLLATE='utf8_general_ci' ENGINE=Innodb AUTO_INCREMENT=5000000001 ; CREATE TABLE IF NOT EXISTS `p_log_charge` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id' , `rid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `openid` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家openid' , `gold` int(11) NOT NULL DEFAULT '0' COMMENT '元宝数' , `money` int(11) NOT NULL DEFAULT '0' COMMENT '金钱数' , `zoneid` int(11) NOT NULL DEFAULT '0' COMMENT '区id' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '记录时间' , `level` smallint(6) NOT NULL DEFAULT '0' COMMENT '消费时的等级' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '注册平台' , `pd` varchar(255) NOT NULL DEFAULT '' COMMENT '注册时的子站点' , `curpf` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家在线时的平台' , `curpd` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家在线时的子站点' , `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间' , `ireldaimond` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员' , `ireldaimondlevel` int(11) NOT NULL DEFAULT '0' COMMENT '平台相关会员等级' , `sn` varchar(255) NOT NULL DEFAULT '' COMMENT 'sn' , PRIMARY KEY (`id`), INDEX `i_sn` (`sn`), INDEX `i_time` (`time`), INDEX `i_rid` (`rid`) ) COMMENT='充值日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `p_log_especialhero` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '' , `heroid` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id' , `heroname` varchar(50) NOT NULL COMMENT '角色名' , `realName` varchar(50) NOT NULL COMMENT '玩家真实姓名' , `tequanLev` int(10) NOT NULL DEFAULT '0' COMMENT '特权级别(1-4)' , `givetimes` int(11) NULL DEFAULT '0' COMMENT '发放时间（每次发放都更新一次）' , `cancel` int(2) NULL DEFAULT '1' COMMENT '0-正常发放,1-审核中,2-暂停发放' , `canceltime` int(11) NULL DEFAULT '0' COMMENT '取消时间' , `applytime` int(11) NOT NULL DEFAULT '0' COMMENT '特权玩家申请时间' , `passtime` int(11) NULL DEFAULT '0' COMMENT '特权玩家通过时间' , `applyaccount` varchar(100) NULL COMMENT '申请人账号' , `checkaccount` varchar(100) NULL COMMENT '审核人账号' , `resetaccount` varchar(100) NULL COMMENT '重新确定特权号账号' , `zoneid` int(10) NOT NULL DEFAULT '0' COMMENT '区zoneid' , PRIMARY KEY (`id`), INDEX `espindex` (`heroname`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `mail_no_review` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '' , `ids` text NOT NULL COMMENT '' , `names` text NOT NULL COMMENT '' , `title` text NOT NULL COMMENT '' , `content` text NOT NULL COMMENT '' , `goods_id` int(11) NOT NULL COMMENT '' , `goods_num` int(11) NOT NULL COMMENT '' , `bind` tinyint(1) NOT NULL COMMENT '' , `bcoin` int(11) NOT NULL COMMENT '' , `coin` int(11) NOT NULL COMMENT '' , `silver` int(11) NOT NULL COMMENT '' , `gold` int(11) NOT NULL COMMENT '' , `type` tinyint(1) NOT NULL COMMENT '' , `ctime` int(10) NOT NULL COMMENT '' , `admin_username` varchar(20) NOT NULL COMMENT '' , `node` smallint(3) NOT NULL COMMENT '线路' , `minlv` smallint(3) NOT NULL COMMENT '' , `maxlv` smallint(3) NOT NULL COMMENT '' , `acc_name` text NOT NULL COMMENT '' , `stren` tinyint(3) NOT NULL COMMENT '强化' , `prefix` tinyint(3) NOT NULL COMMENT '前缀' , `realname` varchar(20) NOT NULL COMMENT '审核批准的管理员名称' , `point` int(11) NOT NULL DEFAULT '0' COMMENT '积分' , `charge` int(11) NOT NULL DEFAULT '0' COMMENT 'charge' , `is_online` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'is_online' , PRIMARY KEY (`id`), INDEX `admin_username` (`admin_username`), INDEX `ctime` (`ctime`) ) COMMENT='后台需要等待审核的邮件' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_gm_mail` ( `mid` int(11) NOT NULL AUTO_INCREMENT COMMENT '' , `id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户ID' , `accname` varchar(100) NOT NULL COMMENT '用户名' , `last_login_time` int(10) NOT NULL COMMENT '最后登录时间' , `nickname` varchar(255) NOT NULL COMMENT '昵称' , `title` varchar(512) NOT NULL COMMENT '标题' , `content` varchar(1024) NOT NULL COMMENT '内容' , `goods_id` int(11) NOT NULL COMMENT '物品ID' , `goods_num` int(11) NOT NULL COMMENT '物品数量' , `bcoin` int(11) NOT NULL COMMENT '绑定铜币' , `coin` int(11) NOT NULL COMMENT '铜币' , `silver` int(11) NOT NULL COMMENT '绑定元宝' , `gold` int(11) NOT NULL COMMENT '元宝' , `admin_name` varchar(50) NOT NULL COMMENT '发送管理员账号' , `ctime` int(11) NOT NULL COMMENT '发送时间' , `stren` int(11) NOT NULL COMMENT '强化等级' , `prefix` int(11) NOT NULL COMMENT '品质前缀' , `realname` varchar(50) NOT NULL COMMENT '真实姓名' , `lv` int(11) NOT NULL COMMENT '等级' , `role_gold` int(11) NOT NULL COMMENT '剩余元宝' , `pass_admin_name` varchar(50) NOT NULL COMMENT '通过管理员' , `charge` int(11) NOT NULL DEFAULT '0' COMMENT 'charge' , `is_online` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'is_online' , PRIMARY KEY (`mid`), INDEX `nickname` (`nickname`), INDEX `accname` (`accname`), INDEX `id` (`id`), INDEX `goods_id` (`goods_id`), INDEX `ctime` (`ctime`) ) COMMENT='' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_ban` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '' , `type` tinyint(1) NOT NULL COMMENT '类型：0：封号，1：IP黑名单' , `object` varchar(2000) NOT NULL COMMENT '对象' , `description` varchar(100) NOT NULL COMMENT '描述' , `time` int(10) NOT NULL COMMENT '时间' , `admin` varchar(50) NOT NULL COMMENT '操作管理员' , PRIMARY KEY (`id`), INDEX `type` (`type`), INDEX `time` (`time`) ) COMMENT='查封日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `sys_notice` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `order` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序，越小顺序越前' , `pos` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '位置 1-在顶部 2-左下角' , `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '公告类型 1-7 表示开服第一天 8-开服7天内 9-开服7天后 10-无限制' , `interval` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '公告间隔秒数，10秒轮询一次' , `btime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '公告生效开始时间，0 表示不受开始时间限制' , `etime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '公告生效结束时间，0 表示不受结束时间限制' , `msg` varchar(1000) NOT NULL DEFAULT '' COMMENT '公告内容，1000字符以内' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间' , `channel_names` varchar(2000) NOT NULL DEFAULT '' COMMENT '渠道号' , PRIMARY KEY (`id`) ) COMMENT='公告系统' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_rename` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `player_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家id' , `old_name` varchar(32) NOT NULL DEFAULT '' COMMENT '改名前姓名' , `new_name` varchar(32) NOT NULL DEFAULT '' COMMENT '改名后姓名' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '改名时间' , PRIMARY KEY (`id`), INDEX `player_id` (`player_id`) ) COMMENT='改名日志表' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_shop_buy` ( `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 '玩家名字' , `role_lv` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家等级' , `goods_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品id' , `goods_name` varchar(32) NOT NULL DEFAULT '' COMMENT '物品名字' , `goods_num` int(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品数量' , `gold_type` varchar(32) NOT NULL DEFAULT '' COMMENT '货币类型' , `gold_num` 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_item_charge` ( `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 '玩家名字' , `role_lv` int(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家等级' , `goods_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品id' , `gold_num` 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_onlinetime` ( `datetime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '当天0点时间戳' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `online_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '在线时长' , `ctime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '记录时间' , PRIMARY KEY (`datetime`,`role_id`), INDEX `ctime` (`ctime`), INDEX `role_id` (`role_id`) ) COMMENT='在线时间日志，可能有10分钟的误差' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_mail_info` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id' , `rid1` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发送玩家id' , `rid2` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '接收玩家id' , `assets` varchar(500) NOT NULL DEFAULT '' COMMENT '数值数据' , `items` varchar(2000) NOT NULL DEFAULT '' COMMENT '物品' , `subject` varchar(500) NOT NULL DEFAULT '' COMMENT '邮件头' , `content` varchar(500) NOT NULL DEFAULT '' COMMENT '邮件内容' , `send_time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发送时间' , PRIMARY KEY (`id`), INDEX `send_time` (`send_time`), INDEX `rid2` (`rid2`), INDEX `rid1` (`rid1`) ) COMMENT='邮件日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_send_flower` ( `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 '玩家名字' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作时间' , `target_role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被送玩家id' , `target_role_name` varchar(32) NOT NULL DEFAULT '' COMMENT '被送玩家名字' , `goods_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '物品id' , `goods_name` varchar(32) NOT NULL DEFAULT '' COMMENT '物品名字' , `goods_num` 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_produce_charm` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_charm` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '旧魅力值' , `new_charm` 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_charm` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_charm` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '旧魅力值' , `new_charm` 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_svip` ( `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_charm` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '旧魅力值,废弃' , `new_charm` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '新魅力值,废弃' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间' , `real_name` varchar(20) NOT NULL DEFAULT '' COMMENT '姓名' , `phone` varchar(20) NOT NULL DEFAULT '' COMMENT '电话' , `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '性别' , `qq` varchar(20) NOT NULL DEFAULT '' COMMENT 'qq' , `birthday` varchar(20) NOT NULL DEFAULT '' COMMENT '生日' , `address` varchar(100) NOT NULL DEFAULT '' COMMENT '地址' , PRIMARY KEY (`role_id`), INDEX `time` (`time`) ) COMMENT='超级会员日志' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `log_produce_f_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_f_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_produce_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 '更新时间' , `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_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='夏日活动全服限购' 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`) ) 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' , `old_fairy_stamps` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '旧仙劵' , `new_fairy_stamps` 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 `friend_circle_report` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `mid` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '朋友圈状态id' , `platform` varchar(20) NOT NULL DEFAULT '' COMMENT '平台id' , `zone_id` mediumint(7) UNSIGNED NOT NULL DEFAULT '0' COMMENT '区域id' , `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '举报时间' , `lev` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被举报等级' , `name` varchar(255) NOT NULL DEFAULT '' COMMENT '被举报名字' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被举报玩家' , `role_platform` varchar(255) NOT NULL DEFAULT '' COMMENT '被举报玩家平台' , `role_zone_id` mediumint(7) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被举报玩家服' , `report_type` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '举报类型' , `spec_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '举报内容id' , `content` varchar(255) NOT NULL DEFAULT '' COMMENT '举报内容' , `reporter_id` bigint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '举报人' , `reporter_platform` varchar(255) NOT NULL DEFAULT '' COMMENT '举报人平台' , `reporter_zone_id` mediumint(7) UNSIGNED NOT NULL DEFAULT '0' COMMENT '举报人服' , `reporter_name` varchar(255) NOT NULL DEFAULT '' COMMENT '举报人名字' , `reporter_lev` 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_consume_fairy_stamps` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色ID' , `old_fairy_stamps` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '旧仙劵' , `new_fairy_stamps` 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 `mod_white_ip` ( `id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'id' , `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态' , `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'ip地址' , `reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因' , PRIMARY KEY (`id`) ) COMMENT='白名单' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `mod_white_account` ( `id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'id' , `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态' , `account` varchar(255) NOT NULL DEFAULT '' COMMENT '账号' , `reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因' , PRIMARY KEY (`id`) ) COMMENT='白名单账号' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `sys_notice_board2` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' , `type` smallint(6) UNSIGNED NULL DEFAULT '1' COMMENT '通知类型 1:更新公告 2:gm补偿 3:奖励 4:普通' , `sort` smallint(6) UNSIGNED NULL DEFAULT '0' COMMENT '排序值(值越大优先级越高)' , `start_time` int(10) UNSIGNED NOT NULL COMMENT '开始时间' , `end_time` int(10) UNSIGNED NOT NULL COMMENT '结束时间' , `open_day_min` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最小开服天数' , `open_day_max` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最大开服天数' , `lev` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '可读等级' , `channel_names` varchar(2000) NOT NULL DEFAULT '' COMMENT '渠道号' , `title` text NULL COMMENT '标题' , `summary` text NULL COMMENT '概要' , `content` text NULL COMMENT '内容' , PRIMARY KEY (`id`), INDEX `end_time` (`end_time`), INDEX `start_time` (`start_time`) ) COMMENT='系统公告' COLLATE='utf8_general_ci' ENGINE=Innodb ; CREATE TABLE IF NOT EXISTS `charge_back_account` ( `account` varchar(255) NOT NULL DEFAULT '' COMMENT '账号' , `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '返利状态,0-未返利，1-已返利' , `zone_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '服id' , `time` int(11) NOT NULL DEFAULT '0' COMMENT '记录时间' , `pf` varchar(255) NOT NULL DEFAULT '' COMMENT '平台号' , PRIMARY KEY (`account`), INDEX `i_time` (`time`) ) COMMENT='返利账号' COLLATE='utf8_general_ci' ENGINE=Innodb ; dbtools over in [{{2025,8,20},{13,42,15}}]