forked from Gitlink/microservices
35 lines
1.6 KiB
SQL
35 lines
1.6 KiB
SQL
-- cms文章表中添加审核相关字段，并添加文章审核menu及赋予角色menu权限
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 0;
|
||
|
||
ALTER TABLE `zone_detail`
|
||
ADD COLUMN `need_audit` tinyint(1) DEFAULT 0 COMMENT '是否需要审核（0：不需要，1：需要）';
|
||
|
||
ALTER TABLE `cms_doc`
|
||
ADD COLUMN `audit_status` char(1) DEFAULT '1' COMMENT '审核状态（0：审核不通过，1：审核通过 2：待审核）';
|
||
|
||
ALTER TABLE `cms_doc`
|
||
ADD COLUMN `audit_type` varchar(50) default null COMMENT '文章审核类型-原文章id,文章审核类型：create || update || delete ';
|
||
|
||
ALTER TABLE `cms_doc`
|
||
ADD COLUMN `audit_tmp_branch_name` varchar(255) default null COMMENT '文章审核临时分支名';
|
||
|
||
ALTER TABLE `cms_doc`
|
||
ADD COLUMN `audit_pr_number` varchar(255) default null COMMENT 'giteaPrNumber-gitLinkPrId,文章审核合并请求编号';
|
||
|
||
ALTER TABLE `cms_doc`
|
||
MODIFY COLUMN file_sha VARCHAR(255) DEFAULT NULL COMMENT '文件SHA';
|
||
|
||
insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`,
|
||
`is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`,
|
||
`update_by`, `update_time`, `remark`)
|
||
values (2200, '审核文章', '2086', '6', '', NULL, NULL, '1', '0', 'F', '0', '0', 'cms:doc:audit', '#', 'admin',
|
||
'2023-08-22 11:36:28', '', NULL, '2090');
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
SELECT 5, menu_id
|
||
FROM sys_menu
|
||
WHERE perms = 'cms:doc:audit' and menu_name = '审核文章';
|
||
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 1; |