GitLab

一、企业经营信息图片保存表

数据库：wiki

表名：admin_audit_wiki_manage_imgs

CREATE TABLE `admin_audit_wiki_manage_imgs` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `admin_wiki_id` int(11) NOT NULL COMMENT '百科提单表id',
 `path` varchar(255) NOT NULL COMMENT '企业经营信息图片路径',
 `status` tinyint(1) NOT NULL DEFAULT '1',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

二、角色表

数据库：wiki

表名：admin_role

CREATE TABLE `admin_role` (
 `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
 `name` varchar(255) NOT NULL COMMENT '角色名称',
 `permission_list` varchar(2500) NOT NULL DEFAULT '' COMMENT '角色权限',
 `status` tinyint(1) NOT NULL DEFAULT '1',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

三、用户表

数据库：wiki

表名：admin_user

CREATE TABLE `admin_user` (
 `admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
 `p_id` int(11) NOT NULL DEFAULT '0' COMMENT '主账号id',
 `username` varchar(40) NOT NULL COMMENT '用户名',
 `password` varchar(32) NOT NULL COMMENT '密码',
 `salt` varchar(6) NOT NULL,
 `status` tinyint(2) NOT NULL DEFAULT '1',
 `stop` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表正常，2代表停用',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

四、用户角色表

数据库：wiki

表名：admin_user_role

CREATE TABLE `admin_user_role` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `admin_id` int(11) NOT NULL COMMENT '用户id',
 `role_id` int(11) NOT NULL COMMENT '角色id',
 `status` tinyint(4) NOT NULL DEFAULT '1',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 UNIQUE KEY `admin_id` (`admin_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

五、百科审核记录表

数据库：wiki

表名：admin_wiki_audit_log

CREATE TABLE `admin_wiki_audit_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `admin_wiki_id` int(11) NOT NULL COMMENT '百科订单id',
 `operation_result` varchar(255) NOT NULL COMMENT '操作结果',
 `operation_user_id` int(11) NOT NULL,
 `operation_user` varchar(255) NOT NULL COMMENT '操作人',
 `note` varchar(255) DEFAULT NULL COMMENT '备注',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

六、百科舆情记录表

数据库：wiki

表名：admin_wiki_company_news

CREATE TABLE `admin_wiki_company_news` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `admin_wiki_id` int(11) NOT NULL,
 `company_name` varchar(500) NOT NULL,
 `news_title` varchar(1000) NOT NULL,
 `news_content` varchar(1000) NOT NULL,
 `news_url` varchar(255) NOT NULL,
 `news_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `site_name` varchar(255) NOT NULL,
 `path` varchar(1000) NOT NULL DEFAULT '',
 `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1代表有效',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `admin_wiki_id` (`admin_wiki_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

七、企业资质信息记录表

数据库：wiki

表名：admin_wiki_intelligence_log

CREATE TABLE `admin_wiki_intelligence_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `admin_wiki_id` int(11) NOT NULL COMMENT '百科提单id',
 `path` varchar(255) NOT NULL COMMENT '企业资质信息图片路径',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8