V20260619_09__lobster_menu_rename.sql 1.4 KB

123456789101112131415161718192021222324252627
  1. -- 数字员工菜单重命名:工作流模板库 -> 工作流模板,工作流执行任务 -> 工作流执行
  2. -- 总后台 adminui (sys_menu)
  3. UPDATE sys_menu SET menu_name = '工作流模板'
  4. WHERE menu_name IN ('工作流模板库', '工作流模板')
  5. AND (parent_id = 2864 OR path IN ('template', 'company-workflowLobster'));
  6. UPDATE sys_menu SET menu_name = '工作流执行'
  7. WHERE menu_name IN ('工作流执行任务', '工作流执行')
  8. AND (parent_id = 2864 OR path = 'workflow-execution');
  9. -- 主库租户菜单模板
  10. UPDATE tenant_sys_menu SET menu_name = '工作流模板'
  11. WHERE menu_name IN ('工作流模板库', '工作流模板')
  12. AND (parent_id = 29900 OR path IN ('template', 'company-workflowLobster') OR menu_id IN (29903, 32481));
  13. UPDATE tenant_sys_menu SET menu_name = '工作流执行'
  14. WHERE menu_name IN ('工作流执行任务', '工作流执行')
  15. AND (parent_id = 29900 OR path = 'workflow-execution' OR menu_id = 29949);
  16. UPDATE tenant_company_menu SET menu_name = '工作流模板'
  17. WHERE menu_name IN ('工作流模板库', '工作流模板')
  18. AND (parent_id = 29900 OR path IN ('template', 'company-workflowLobster') OR menu_id IN (29903, 32481));
  19. UPDATE tenant_company_menu SET menu_name = '工作流执行'
  20. WHERE menu_name IN ('工作流执行任务', '工作流执行')
  21. AND (parent_id = 29900 OR path = 'workflow-execution' OR menu_id = 29949);