forked from Gitlink/microservices
27 lines
3.5 KiB
SQL
27 lines
3.5 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 (2163, '首页配置', 2087, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'zone:zoneDetail:query', '#', 'admin', '2023-06-08 09:48:32', 'admin', '2023-06-08 09:51:48', '');
|
|
|
|
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 (2164, '合作伙伴', 2074, 2, 'partner', '', NULL, 1, 0, 'M', '0', '0', '', '#', 'admin', '2023-06-08 14:18:45', 'admin', '2023-06-09 11:15:07', '');
|
|
|
|
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 (2166, '首页配置', 2074, 1, 'configuration', 'cms/zone/configuration', NULL, 1, 0, 'C', '0', '0', '', '#', 'admin', '2023-06-08 14:27:54', 'admin', '2023-06-08 14:39:21', '');
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu` SET `menu_name` = '资讯管理', `parent_id` = 2074, `order_num` = 3, `path` = 'content', `component` = NULL, `query` = NULL, `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = 'ProfileOutlined', `create_by` = 'admin', `create_time` = '2023-05-22 16:18:15', `update_by` = 'admin', `update_time` = '2023-06-08 14:18:54', `remark` = '' WHERE `menu_id` = 2111;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu` SET `menu_name` = '项目管理', `parent_id` = 2074, `order_num` = 4, `path` = 'project', `component` = NULL, `query` = NULL, `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_time` = '2023-05-22 16:34:16', `update_by` = 'admin', `update_time` = '2023-06-08 14:18:59', `remark` = '' WHERE `menu_id` = 2112;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu` SET `menu_name` = '会员管理', `parent_id` = 2074, `order_num` = 5, `path` = 'member', `component` = NULL, `query` = NULL, `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = '#', `create_by` = 'admin', `create_time` = '2023-05-24 09:46:53', `update_by` = 'admin', `update_time` = '2023-06-08 14:19:04', `remark` = '' WHERE `menu_id` = 2116;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu` SET `menu_name` = 'logo管理', `parent_id` = 2164, `order_num` = 1, `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-09 11:22:12', `remark` = '' WHERE `menu_id` = 2157;
|
|
|
|
DELETE FROM `ruoyi-gitlink`.`sys_role_menu` WHERE `role_id` = 5 AND `menu_id` = 2087;
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2164);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2166);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2163);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2164);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |