yystopf
/
microservices
forked from Gitlink/microservices
0
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
microservices/sql/update/hisotry_sql/2023-06-27-002.sql

288 lines
14 KiB
SQL
Raw Permalink Blame History

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 (2179, '资源管理', 2074, 6, 'resource', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'zip', 'admin',
'2023-06-27 14:52:07', '', NULL, '');
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 (2180, '资源类别', 2179, 1, 'category', NULL, NULL, 1, 0, 'C', '0', '0', 'zone:resourceType:list', '#', 'admin',
'2023-06-27 14:54:45', '', NULL, '');
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 (2181, '查询特色专区资源类别列表', 2180, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceType:list', '#',
'admin', '2023-06-27 14:55:12', '', NULL, '');
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 (2182, '获取特色专区资源类别详细信息', 2180, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceType:query',
'#', 'admin', '2023-06-27 14:55:37', '', NULL, '');
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 (2183, '新增特色专区资源类别', 2180, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceType:add', '#',
'admin', '2023-06-27 14:55:54', '', NULL, '');
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 (2184, '修改特色专区资源类别', 2180, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceType:edit', '#',
'admin', '2023-06-27 14:56:08', '', NULL, '');
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 (2185, '删除特色专区资源类别', 2180, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceType:remove', '#',
'admin', '2023-06-27 14:56:23', '', NULL, '');
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 (2186, '资源领域', 2179, 2, 'domain', NULL, NULL, 1, 0, 'C', '0', '0', 'zone:resourceDomain:list', '#', 'admin',
'2023-06-27 14:57:04', '', NULL, '');
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 (2187, '查询特色专区资源领域列表', 2186, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceDomain:list', '#',
'admin', '2023-06-27 14:57:17', '', NULL, '');
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 (2188, '获取特色专区资源领域详细信息', 2186, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceDomain:query',
'#', 'admin', '2023-06-27 14:57:28', '', NULL, '');
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 (2189, '新增特色专区资源领域', 2186, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceDomain:add', '#',
'admin', '2023-06-27 14:57:40', '', NULL, '');
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 (2190, '修改特色专区资源领域', 2186, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceDomain:edit', '#',
'admin', '2023-06-27 14:57:51', '', NULL, '');
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 (2191, '删除特色专区资源领域', 2186, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resourceDomain:remove', '#',
'admin', '2023-06-27 14:58:04', '', NULL, '');
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 (2192, '资源列表', 2179, 3, 'resource', NULL, NULL, 1, 0, 'C', '0', '0', 'zone:resource:list', '#', 'admin',
'2023-06-27 14:58:40', '', NULL, '');
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 (2193, '查询特色专区资源聚合列表', 2192, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resource:list', '#',
'admin', '2023-06-27 14:58:52', '', NULL, '');
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 (2194, '获取特色专区资源聚合详细信息', 2192, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resource:query', '#',
'admin', '2023-06-27 14:59:05', '', NULL, '');
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 (2195, '新增特色专区资源聚合', 2192, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resource:add', '#', 'admin',
'2023-06-27 14:59:14', '', NULL, '');
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 (2196, '修改特色专区资源聚合', 2192, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resource:edit', '#', 'admin',
'2023-06-27 14:59:26', '', NULL, '');
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 (2197, '删除特色专区资源聚合', 2192, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:resource:remove', '#',
'admin', '2023-06-27 14:59:36', '', NULL, '');
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2179);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2180);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2181);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2182);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2183);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2184);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2185);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2186);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2187);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2188);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2189);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2190);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2191);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2192);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2193);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2194);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2195);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2196);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (5, 2197);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2179);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2180);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2181);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2182);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2183);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2184);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2185);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2186);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2187);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2188);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2189);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2190);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2191);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2192);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2193);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2194);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2195);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2196);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (7, 2197);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2179);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2180);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2181);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2182);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2183);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2184);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2185);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2186);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2187);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2188);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2189);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2190);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2191);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2192);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2193);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2194);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2195);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2196);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
VALUES (8, 2197);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink