INSERT INTO sys_menu (uuid, version, pid, menu_type, menu_name, perm_code, sort_order, route_path, del_flag)
SELECT REPLACE(UUID(), '-', ''), 1, p.id, 3, '导入', 'config:sensitive-words:import', 50, NULL, 0
FROM sys_menu p
WHERE p.route_path = '/system/sensitive-words'
  AND p.del_flag = 0
  AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perm_code = 'config:sensitive-words:import' AND del_flag = 0);

INSERT INTO sys_role_menu (uuid, version, role_id, menu_id, del_flag)
SELECT LOWER(MD5(CONCAT(r.id, ':', m.id, ':sensitive-word-import'))), 1, r.id, m.id, 0
FROM sys_role r
JOIN sys_menu m ON m.del_flag = 0
LEFT JOIN sys_role_menu rm ON rm.role_id = r.id AND rm.menu_id = m.id AND rm.del_flag = 0
WHERE r.role_code = 'ADMIN'
  AND r.del_flag = 0
  AND m.perm_code = 'config:sensitive-words:import'
  AND rm.id IS NULL;