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

`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` (