aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/cata_classic/2024_05_28_00_world.sql26
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_05_28_00_world.sql b/sql/updates/world/cata_classic/2024_05_28_00_world.sql
new file mode 100644
index 00000000000..6077c054c20
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_05_28_00_world.sql
@@ -0,0 +1,26 @@
+-- Cata classic only (cherry-pick)
+DELETE FROM `creature` WHERE `guid` BETWEEN 3000021 AND 3000025;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000021 AND 3000025;
+DELETE FROM `creature` WHERE `guid` BETWEEN 3000026 AND 3000031;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000026 AND 3000031;
+DELETE FROM `creature` WHERE `guid` BETWEEN 2000000 AND 2000004;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 2000000 AND 2000004;
+DELETE FROM `creature` WHERE `guid` BETWEEN 3000050 AND 3000054;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000050 AND 3000054;
+DELETE FROM `creature` WHERE `guid` BETWEEN 3000055 AND 3000060;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 3000055 AND 3000060;
+DELETE FROM `creature` WHERE `guid` BETWEEN 2000005 AND 2000010;
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN 2000005 AND 2000010;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3000635 AND 3000719;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 3000720 AND 3000860;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3000720 AND 3000860;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 2000000 AND 2000154;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 2000000 AND 2000154;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001025 AND 3001144;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 3001145 AND 3001258;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 2000155 AND 2000376;
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 2000155 AND 2000376;