diff options
| author | Aokromes <jipr@hotmail.com> | 2013-06-18 04:19:34 +0300 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2013-06-18 04:19:34 +0300 |
| commit | 7f54297271a8bcd9b26d22cf8dd3dab817b4e779 (patch) | |
| tree | 8fa649669b5203b18e073447d84f9bbff4b720d8 | |
| parent | 2d892465d0e74bd1819f09745e5a3a75c3fe33f9 (diff) | |
DB/Misc: Cleaning db of unused/obsolete stuff
| -rw-r--r-- | sql/updates/world/2013_06_18_00_world_misc.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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 |