V20260613_00__lobster_master_menus.sql 1.3 KB

12345678910111213
  1. -- Master DB: lobster menus 29933-29935 (June 2026 upgrade)
  2. -- tenant_sys_menu + tenant_company_menu 四表同步(主库侧)
  3. INSERT IGNORE INTO tenant_sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, is_frame, is_cache, perms, create_by, create_time, remark)
  4. VALUES
  5. (29933, '租户语义关键词', 29900, 20, 'semantic-keywords', 'lobster/semantic-keywords/index', 'C', 'el-icon-collection-tag', '0', '0', 0, 0, 'workflow:lobster:semantic', 'admin', NOW(), 'lobster semantic keywords'),
  6. (29934, '对外角色配置', 29900, 21, 'identity-config', 'lobster/identity-config/index', 'C', 'el-icon-view', '0', '0', 0, 0, 'workflow:lobster:identity', 'admin', NOW(), 'identity hiding'),
  7. (29935, '行业方案引导', 29900, 22, 'industry-bootstrap', 'lobster/industry-bootstrap/index', 'C', 'el-icon-suitcase', '0', '0', 0, 0, 'workflow:lobster:bootstrap', 'admin', NOW(), 'industry bootstrap');
  8. INSERT IGNORE INTO tenant_company_menu
  9. (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, company_id, remark)
  10. SELECT menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, NULL, remark
  11. FROM tenant_sys_menu WHERE menu_id IN (29933, 29934, 29935);