From 513b8d9fca6b52e2182a15b0391460cb8b6a8835 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 30 May 2016 09:36:55 +0200 Subject: DB/Quest: Delete unused values --- sql/updates/world/3.3.5/2016_05_30_02_world.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_05_30_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_05_30_02_world.sql b/sql/updates/world/3.3.5/2016_05_30_02_world.sql new file mode 100644 index 00000000000..2742f9c8ca9 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_05_30_02_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `quest_template_addon` WHERE `MaxLevel` = 0 AND `AllowableClasses` = 0 AND `SourceSpellID` = 0 AND `PrevQuestID` = 0 AND `NextQuestID` = 0 AND `ExclusiveGroup` = 0 AND `RewardMailTemplateID` = 0 AND `RewardMailDelay` = 0 AND `RequiredSkillID` = 0 AND `RequiredSkillPoints` = 0 AND `RequiredMinRepFaction` = 0 AND `RequiredMaxRepFaction` = 0 AND `RequiredMinRepValue` = 0 AND `RequiredMaxRepValue` = 0 AND `ProvidedItemCount` = 0 AND `SpecialFlags` = 0; -- cgit v1.2.3