DB/Misc: Cleaning db of unused/obsolete stuff

2 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/characters/2013_03_23_00_characters_game_event.sql b/sql/updates/characters/2013_03_23_00_characters_game_event.sql
new file mode 100644
index 00000000000..d8a58832ce1
--- /dev/null
+++ b/sql/updates/characters/2013_03_23_00_characters_game_event.sql
@@ -0,0 +1,3 @@
+-- Delete no longer used data from Characters Database
+DELETE FROM `game_event_save` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_condition_save` WHERE `eventEntry` BETWEEN 33 AND 47;
diff --git a/sql/updates/world/2013_06_23_00_world_misc.sql b/sql/updates/world/2013_06_23_00_world_misc.sql
new file mode 100644
index 00000000000..981f1236dfd
--- /dev/null
+++ b/sql/updates/world/2013_06_23_00_world_misc.sql
@@ -0,0 +1,10 @@
+-- Delete no longer used data from World Database
+DELETE FROM `game_event_condition` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_creature_quest` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_npc_vendor` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_npcflag` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_prerequisite` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event_quest_condition` WHERE `eventEntry` BETWEEN 33 AND 47;
+DELETE FROM `game_event` WHERE `description` LIKE '%Shattered Sun Offensive:%';
+
+UPDATE `creature_template` SET `lootid`=0 WHERE `entry`=29833;