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

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,13},{17,35,38}}]