forked from Gitlink/microservices
22 lines
875 B
SQL
22 lines
875 B
SQL
-- menu表中添加咨询配置菜单，并赋予响应角色菜单权限
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 0;
|
||
|
||
UPDATE `sys_menu`
|
||
SET perms = 'cms:doc:removeDir'
|
||
WHERE menu_id = 2091;
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
VALUES ('5', '2202');
|
||
|
||
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`)
|
||
VALUES ('8', '2202');
|
||
|
||
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 ('2202', '资讯配置', '2111', '1', 'configuration', 'zone/cms/doc/configuration', NULL, '1', '0', 'C', '0', '0',
|
||
'cms:doc:configuration', '#', 'admin', '2023-08-24 14:14:09', 'admin', '2023-08-24 14:15:18', '');
|
||
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 1; |