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

87 lines
2.4 KiB
SQL

SET FOREIGN_KEY_CHECKS = 0;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源管理',
`parent_id` = 2074,
`order_num` = 6,
`path` = 'resource',
`component` = NULL,
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'M',
`visible` = '0',
`status` = '0',
`perms` = '',
`icon` = 'FileZipFilled',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:52:07',
`update_by` = 'admin',
`update_time` = '2023-07-04 15:04:35',
`remark` = ''
WHERE `menu_id` = 2179;
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;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源领域',
`parent_id` = 2179,
`order_num` = 2,
`path` = 'domain',
`component` = 'zone/resource/domain',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 0,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resourceDomain:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:57:04',
`update_by` = 'admin',
`update_time` = '2023-07-05 10:59:10',
`remark` = ''
WHERE `menu_id` = 2186;
UPDATE `ruoyi-gitlink`.`sys_menu`
SET `menu_name` = '资源列表',
`parent_id` = 2179,
`order_num` = 3,
`path` = 'resource',
`component` = 'zone/resource/list',
`query` = NULL,
`is_frame` = 1,
`is_cache` = 1,
`menu_type` = 'C',
`visible` = '0',
`status` = '0',
`perms` = 'zone:resource:list',
`icon` = '#',
`create_by` = 'admin',
`create_time` = '2023-06-27 14:58:40',
`update_by` = 'admin',
`update_time` = '2023-07-05 10:00:36',
`remark` = ''
WHERE `menu_id` = 2192;
SET FOREIGN_KEY_CHECKS = 1;