-- 仅在需要撤销20261027查询权限清理时执行,恢复原菜单权限、删除标记、角色授权及套餐菜单。 -- 若清理后又手动调整过套餐菜单,请先核对备份中的menu_ids再恢复。 START TRANSACTION; UPDATE system_menu m JOIN xgdl_query_menu_backup_20261027 b ON b.id = m.id SET m.permission = b.permission, m.deleted = b.deleted, m.updater = b.updater, m.update_time = b.update_time; UPDATE system_role_menu r JOIN xgdl_query_role_menu_backup_20261027 b ON b.id = r.id SET r.deleted = b.deleted, r.updater = b.updater, r.update_time = b.update_time; UPDATE system_tenant_package p JOIN xgdl_query_tenant_package_backup_20261027 b ON b.id = p.id SET p.menu_ids = b.menu_ids, p.updater = b.updater, p.update_time = b.update_time; COMMIT;