microservices/sql/update/hisotry_sql/2023-06-07-002.sql

39 lines
3.6 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 (2157, '合作伙伴', 2087, 1, 'zone/partners/index', NULL, '', 1, 1, 'C', '0', '0', 'zone:partners:list', 'peoples', 'admin', '2023-06-07 15:56:22', 'admin', '2023-06-07 15:57:29', '');
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 (2158, '查询特色专区合作伙伴列表', 2157, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partners:list', '#', 'admin', '2023-06-07 15:57:43', '', 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 (2159, '获取特色专区合作伙伴详细信息', 2157, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partners:query', '#', 'admin', '2023-06-07 15:58:02', '', 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 (2160, '新增特色专区合作伙伴', 2157, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partners:add', '#', 'admin', '2023-06-07 15:58:15', '', 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 (2161, '修改特色专区合作伙伴', 2157, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partners:edit', '#', 'admin', '2023-06-07 15:58:27', '', 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 (2162, '删除特色专区合作伙伴', 2157, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partners:remove', '#', 'admin', '2023-06-07 15:58:39', '', NULL, '');
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2157);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2158);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2159);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2160);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2161);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2162);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2157);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2158);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2159);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2160);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2161);
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2162);
SET FOREIGN_KEY_CHECKS = 1;