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

`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 '被送玩家名字' ,