forked from Gitlink/microservices
15 lines
1.3 KiB
SQL
15 lines
1.3 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 (2167, '待审核会员列表', 2116, 4, 'cms/member/list/index', NULL, NULL, 1, 0, 'C', '0', '0', 'zone:member:auditList', 'AuditOutlined', 'admin', '2023-06-12 10:52:48', 'admin', '2023-06-12 10:52:57', '');
|
|
|
|
UPDATE `ruoyi-gitlink`.`sys_menu` SET `menu_name` = '审核会员', `parent_id` = 2167, `order_num` = 1, `path` = '', `component` = NULL, `query` = NULL, `is_frame` = 1, `is_cache` = 0, `menu_type` = 'F', `visible` = '0', `status` = '0', `perms` = 'zone:member:audit', `icon` = '#', `create_by` = 'admin', `create_time` = '2023-05-29 10:48:16', `update_by` = 'admin', `update_time` = '2023-06-12 10:53:21', `remark` = '' WHERE `menu_id` = 2153;
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 101);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2087);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (5, 2167);
|
|
|
|
INSERT INTO `ruoyi-gitlink`.`sys_role_menu` (`role_id`, `menu_id`) VALUES (8, 2167);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1; |