forked from Gitlink/microservices
78 lines
2.5 KiB
SQL
78 lines
2.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 (2169, '项目配置', 2112, 1, 'configuration', 'cms/project/configuration/index', NULL, 1, 0, 'C', '0', '0', '',
|
|
'#', 'admin', '2023-06-16 14:43:21', 'admin', '2023-06-16 15:08:52', '');
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu`
|
|
SET `menu_name` = '项目分类',
|
|
`parent_id` = 2112,
|
|
`order_num` = 2,
|
|
`path` = 'category',
|
|
`component` = 'cms/project/category/index',
|
|
`query` = NULL,
|
|
`is_frame` = 1,
|
|
`is_cache` = 0,
|
|
`menu_type` = 'C',
|
|
`visible` = '0',
|
|
`status` = '0',
|
|
`perms` = 'zone:projectType:list',
|
|
`icon` = '#',
|
|
`create_by` = 'admin',
|
|
`create_time` = '2023-05-22 16:35:27',
|
|
`update_by` = 'admin',
|
|
`update_time` = '2023-06-16 15:09:07',
|
|
`remark` = ''
|
|
WHERE `menu_id` = 2113;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu`
|
|
SET `menu_name` = '项目列表',
|
|
`parent_id` = 2112,
|
|
`order_num` = 3,
|
|
`path` = 'list',
|
|
`component` = 'cms/project/list/index',
|
|
`query` = NULL,
|
|
`is_frame` = 1,
|
|
`is_cache` = 0,
|
|
`menu_type` = 'C',
|
|
`visible` = '0',
|
|
`status` = '0',
|
|
`perms` = 'zone:project:list',
|
|
`icon` = '#',
|
|
`create_by` = 'admin',
|
|
`create_time` = '2023-05-22 16:45:01',
|
|
`update_by` = 'admin',
|
|
`update_time` = '2023-06-16 15:09:12',
|
|
`remark` = ''
|
|
WHERE `menu_id` = 2115;
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu`
|
|
SET `menu_name` = '首页配置',
|
|
`parent_id` = 2074,
|
|
`order_num` = 1,
|
|
`path` = 'configuration',
|
|
`component` = 'cms/zone/configuration',
|
|
`query` = NULL,
|
|
`is_frame` = 1,
|
|
`is_cache` = 0,
|
|
`menu_type` = 'C',
|
|
`visible` = '0',
|
|
`status` = '0',
|
|
`perms` = '',
|
|
`icon` = '#',
|
|
`create_by` = 'admin',
|
|
`create_time` = '2023-06-08 14:27:54',
|
|
`update_by` = 'admin',
|
|
`update_time` = '2023-06-16 15:09:51',
|
|
`remark` = ''
|
|
WHERE `menu_id` = 2166;
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (5, 2169);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`)
|
|
VALUES (8, 2169);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |