29 lines
830 B
MySQL
29 lines
830 B
MySQL
|
-- 修复知识库管理的parent_id
|
|||
|
|
-- 问题：parent_id=0 导致它是顶级菜单，应该在心理健康模块下
|
|||
|
|
|
|||
|
|
-- 1. 先查看心理健康模块的菜单ID
|
|||
|
|
SELECT menu_id, menu_name, parent_id, path, component
|
|||
|
|
FROM sys_menu
|
|||
|
|
WHERE parent_id = 0 AND (menu_name LIKE '%心理%' OR path LIKE '%psychology%')
|
|||
|
|
ORDER BY menu_id;
|
|||
|
|
|
|||
|
|
-- 2. 查看parent_id=2000的菜单（确认2000是心理健康模块）
|
|||
|
|
SELECT menu_id, menu_name, parent_id, path
|
|||
|
|
FROM sys_menu
|
|||
|
|
WHERE parent_id = 2000
|
|||
|
|
ORDER BY menu_id
|
|||
|
|
LIMIT 5;
|
|||
|
|
|
|||
|
|
-- 3. 修复知识库管理的parent_id
|
|||
|
|
UPDATE sys_menu
|
|||
|
|
SET parent_id = 2000
|
|||
|
|
WHERE menu_id = 2209;
|
|||
|
|
|
|||
|
|
-- 4. 验证修改
|
|||
|
|
SELECT menu_id, menu_name, parent_id, path, component
|
|||
|
|
FROM sys_menu
|
|||
|
|
WHERE menu_id = 2209;
|
|||
|
|
|
|||
|
|
-- 完成！退出登录重新登录
|
|||
|
|
SELECT '修复完成！请退出登录后重新登录' AS message;
|