-- 新高电力轻量版：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;
|
