microservices/sql/update/hisotry_sql/2023-07-21-001.sql

54 lines
2.2 KiB
SQL

SET FOREIGN_KEY_CHECKS = 0;
INSERT INTO `ruoyi-gitlink`.`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 (2198, '帮助中心', 2074, 7, 'help', NULL, NULL, 1, 0, 'M', '0', '0', '', 'ProfileFilled', 'admin',
'2023-07-17 09:27:49', 'admin', '2023-07-17 09:28:14', '');
INSERT INTO `ruoyi-gitlink`.`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 (2199, '内容配置', 2198, 1, 'configuration', 'zone/help/configuration', NULL, 1, 0, 'C', '0', '0', '', '#',
'admin', '2023-07-17 09:30:24', 'admin', '2023-07-17 09:34:24', '');
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源类别',
`parent_id` = 2179,
`order_num` = 1,
`path` = 'category',
`component` = 'zone/resource/type',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resourceType:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:54:45',
`update_by` = 'admin',
`update_time` = '2023-07-06 15:52:37',
`remark` = ''
WHERE `menu_id` = 2180;
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2198);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2199);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2198);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2199);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2198);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2199);
SET FOREIGN_KEY_CHECKS = 1;