forked from Gitlink/microservices
136 lines
5.9 KiB
SQL
136 lines
5.9 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 (2171, 'logo分类管理', 2164, 1, 'list', NULL, NULL, 1, 0, 'C', '0', '0', 'zone:partnersType:list', '#', 'admin',
|
|
'2023-06-20 15:50:27', 'admin', '2023-06-20 15:50:41', '');
|
|
|
|
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 (2172, '查询特色专区合作伙伴分类列表', 2171, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partnersType:list',
|
|
'#', 'admin', '2023-06-20 15:51: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 (2173, '获取特色专区合作伙伴分类详细信息', 2171, 2, '', NULL, NULL, 1, 0, 'F', '0', '0',
|
|
'zone:partnersType:query', '#', 'admin', '2023-06-20 15:51: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 (2174, '新增特色专区合作伙伴分类', 2171, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partnersType:add', '#',
|
|
'admin', '2023-06-20 15:51:39', '', 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 (2175, '修改特色专区合作伙伴分类', 2171, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partnersType:edit', '#',
|
|
'admin', '2023-06-20 15:51: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 (2176, '删除特色专区合作伙伴分类', 2171, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:partnersType:remove', '#',
|
|
'admin', '2023-06-20 15:52:06', '', NULL, '');
|
|
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu`
|
|
SET `menu_name` = 'logo分类管理',
|
|
`parent_id` = 2164,
|
|
`order_num` = 1,
|
|
`path` = 'category',
|
|
`component` = 'cms/partner/category/index',
|
|
`query` = NULL,
|
|
`is_frame` = 1,
|
|
`is_cache` = 0,
|
|
`menu_type` = 'C',
|
|
`visible` = '0',
|
|
`status` = '0',
|
|
`perms` = 'zone:partnersType:list',
|
|
`icon` = '#',
|
|
`create_by` = 'admin',
|
|
`create_time` = '2023-06-20 15:50:27',
|
|
`update_by` = 'admin',
|
|
`update_time` = '2023-06-21 15:25:35',
|
|
`remark` = ''
|
|
WHERE `menu_id` = 2171;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu`
|
|
SET `menu_name` = 'logo管理',
|
|
`parent_id` = 2164,
|
|
`order_num` = 2,
|
|
`path` = 'list',
|
|
`component` = 'cms/partner/list/index',
|
|
`query` = '',
|
|
`is_frame` = 1,
|
|
`is_cache` = 1,
|
|
`menu_type` = 'C',
|
|
`visible` = '0',
|
|
`status` = '0',
|
|
`perms` = 'zone:partners:list',
|
|
`icon` = 'peoples',
|
|
`create_by` = 'admin',
|
|
`create_time` = '2023-06-07 15:56:22',
|
|
`update_by` = 'admin',
|
|
`update_time` = '2023-06-20 15:50:52',
|
|
`remark` = ''
|
|
WHERE `menu_id` = 2157;
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2171);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2172);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2173);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2174);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2175);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2176);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2171);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2172);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2173);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2174);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2175);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (7, 2176);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2171);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2172);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2173);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2174);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2175);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2176);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |