-- 新高电力轻量版：AI 模块未随默认后端包发布时，隐藏并禁用所有 AI 菜单。
-- 如改用 `mvn -Pwith-ai ...` 构建完整包，可按备份数据恢复菜单状态。

START TRANSACTION;

CREATE TABLE IF NOT EXISTS system_menu_ai_backup_20261025 LIKE system_menu;

INSERT IGNORE INTO system_menu_ai_backup_20261025
SELECT m.*
FROM system_menu m
WHERE m.deleted = b'0'
  AND (
      m.id = 2758
      OR m.parent_id = 2758
      OR m.parent_id IN (
          SELECT id FROM (
              SELECT id FROM system_menu WHERE deleted = b'0' AND parent_id = 2758
          ) AS ai_first_level
      )
      OR m.path = '/ai'
      OR m.component LIKE 'ai/%'
      OR m.permission LIKE 'ai:%'
  );

-- 主 AI 菜单树（含没有 permission/component 的中间目录）以及散落在其它目录下的 AI 页面。
UPDATE system_menu
SET status = 1,
    visible = b'0',
    updater = '1',
    update_time = NOW()
WHERE deleted = b'0'
  AND (
      id = 2758
      OR parent_id = 2758
      OR parent_id IN (
          SELECT id FROM (
              SELECT id FROM system_menu WHERE deleted = b'0' AND parent_id = 2758
          ) AS ai_first_level
      )
      OR path = '/ai'
      OR component LIKE 'ai/%'
      OR permission LIKE 'ai:%'
  );

COMMIT;