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

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 '数值数据' ,