nuojing-data-service/src/main/resources/db/patch-user-management.sql

use nuojing_data_admin;

insert into sys_menu (id, parent_id, menu_name, path, component, route_name, icon, permission, menu_type, sort, hidden, status)
select 7, 2, '用户管理', '/system/permission/users', 'system/UserList', 'SystemPermissionUsers', 'UserRound', 'system:user:list', 2, 1, 0, 1
where not exists (
    select 1 from sys_menu where path = '/system/permission/users'
);

insert into sys_role_menu (role_id, menu_id)
select 1, id
from sys_menu
where path = '/system/permission/users'
  and not exists (
      select 1
      from sys_role_menu
      where role_id = 1
        and menu_id = sys_menu.id
  );