From 7f54297271a8bcd9b26d22cf8dd3dab817b4e779 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 18 Jun 2013 04:19:34 +0300 Subject: DB/Misc: Cleaning db of unused/obsolete stuff --- sql/updates/world/2013_06_18_00_world_misc.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2013_06_18_00_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_06_18_00_world_misc.sql b/sql/updates/world/2013_06_18_00_world_misc.sql new file mode 100644 index 00000000000..9403c8ee0f4 --- /dev/null +++ b/sql/updates/world/2013_06_18_00_world_misc.sql @@ -0,0 +1,6 @@ +-- Cleaning the database of unused/obsolete data +DELETE FROM `game_event_creature` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`); +DELETE FROM `game_event_gameobject` WHERE `guid` NOT IN (SELECT `guid` FROM `gameobject`); +DELETE FROM `pool_pool` WHERE `mother_pool` NOT IN (SELECT `entry` FROM `pool_template`); +DELETE FROM `game_event_creature` WHERE `guid` IN (40267,40470,40471); +DELETE FROM `creature` WHERE `id` = 18963; -- Removed from game arround wow 2.2.x -- cgit v1.2.3