aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-05-30 09:36:55 +0200
committerAokromes <Aokromes@users.noreply.github.com>2016-05-30 09:36:55 +0200
commit513b8d9fca6b52e2182a15b0391460cb8b6a8835 (patch)
tree34f8bb003c4c832c11fe5154bfcda2d58f9d556f
parent90ed4a934617a2e03ee64c5f9a4bc60dd00ef5b5 (diff)
DB/Quest: Delete unused values
-rw-r--r--sql/updates/world/3.3.5/2016_05_30_02_world.sql2
1 files changed, 2 insertions, 0 deletions
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;