aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/old/3.3.5a/2011_10_29_00_world_version.sql (renamed from sql/updates/world/2011_10_29_00_world_version.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_01_world_gameobject_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_02_world_gameobject_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql (renamed from sql/updates/world/2011_10_29_03_world_gameobject_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql (renamed from sql/updates/world/2011_10_29_04_world_linked_respawn.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_05_world_sai.sql (renamed from sql/updates/world/2011_10_29_05_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_06_world_misc.sql (renamed from sql/updates/world/2011_10_29_06_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_06_world_sai.sql (renamed from sql/updates/world/2011_10_29_06_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql (renamed from sql/updates/world/2011_10_29_07_world_gameobjects.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_30_00_world_misc.sql (renamed from sql/updates/world/2011_10_30_00_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_30_01_world_misc.sql (renamed from sql/updates/world/2011_10_30_01_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql (renamed from sql/updates/world/2011_10_30_02_world_creature_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql (renamed from sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_01_00_world_sai.sql (renamed from sql/updates/world/2011_11_01_00_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql (renamed from sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql (renamed from sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_07_02_world_misc.sql (renamed from sql/updates/world/2011_11_07_02_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_07_03_world_misc.sql (renamed from sql/updates/world/2011_11_07_03_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_11_11_00_world_spell_proc_event.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_11_01_world_misc.sql (renamed from sql/updates/world/2011_11_11_01_world_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql (renamed from sql/updates/world/2011_11_13_00_world_spell_proc_event.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_01_world_sai.sql (renamed from sql/updates/world/2011_11_13_01_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql (renamed from sql/updates/world/2011_11_13_02_world_pool_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql (renamed from sql/updates/world/2011_11_13_03_world_npc_trainer.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_04_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_05_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql (renamed from sql/updates/world/2011_11_13_06_world_reference_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_07_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_08_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_09_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_10_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_11_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql (renamed from sql/updates/world/2011_11_13_12_world_creature_loot_template.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_00_world_command.sql (renamed from sql/updates/world/2011_11_20_00_world_command.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_01_world_sai.sql (renamed from sql/updates/world/2011_11_20_01_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_02_world_sai.sql (renamed from sql/updates/world/2011_11_20_02_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_03_world_sai.sql (renamed from sql/updates/world/2011_11_20_03_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_04_world_sai.sql (renamed from sql/updates/world/2011_11_20_04_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_05_world_sai.sql (renamed from sql/updates/world/2011_11_20_05_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_06_world_sai.sql (renamed from sql/updates/world/2011_11_20_06_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_07_world_sai.sql (renamed from sql/updates/world/2011_11_20_07_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_09_world_sai.sql (renamed from sql/updates/world/2011_11_20_09_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_10_world_sai.sql (renamed from sql/updates/world/2011_11_20_10_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_11_world_sai.sql (renamed from sql/updates/world/2011_11_20_11_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_12_world_sai.sql (renamed from sql/updates/world/2011_11_20_12_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_13_world_sai.sql (renamed from sql/updates/world/2011_11_20_13_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_14_world_revert.sql (renamed from sql/updates/world/2011_11_20_14_world_revert.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_20_15_world_sai.sql (renamed from sql/updates/world/2011_11_20_15_world_sai.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql (renamed from sql/updates/world/2011_11_21_00_world_db_errors.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql (renamed from sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql (renamed from sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql (renamed from sql/updates/world/2011_11_21_03_pilgrim_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql (renamed from sql/updates/world/2011_11_21_04_pilgrim_misc.sql)0
-rw-r--r--sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql (renamed from sql/updates/world/2011_11_21_05_pilgrim_tables.sql)0
-rw-r--r--sql/updates/world/2011_11_24_00_world_version.sql1
-rw-r--r--sql/updates/world/2011_11_25_00_world_quest_template.sql38
-rw-r--r--sql/updates/world/2011_11_25_01_world_quest_template.sql1
-rw-r--r--sql/updates/world/2011_11_25_02_world_creature.sql4
-rw-r--r--sql/updates/world/2011_11_26_00_world_quest_template.sql177
-rw-r--r--sql/updates/world/2011_11_26_01_world_quest_template.sql1
61 files changed, 222 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_29_00_world_version.sql b/sql/old/3.3.5a/2011_10_29_00_world_version.sql
index 17a94041a33..17a94041a33 100644
--- a/sql/updates/world/2011_10_29_00_world_version.sql
+++ b/sql/old/3.3.5a/2011_10_29_00_world_version.sql
diff --git a/sql/updates/world/2011_10_29_01_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql
index 744a549eebd..744a549eebd 100644
--- a/sql/updates/world/2011_10_29_01_world_gameobject_template.sql
+++ b/sql/old/3.3.5a/2011_10_29_01_world_gameobject_template.sql
diff --git a/sql/updates/world/2011_10_29_02_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql
index 9134a66ee2b..9134a66ee2b 100644
--- a/sql/updates/world/2011_10_29_02_world_gameobject_template.sql
+++ b/sql/old/3.3.5a/2011_10_29_02_world_gameobject_template.sql
diff --git a/sql/updates/world/2011_10_29_03_world_gameobject_template.sql b/sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql
index 6b73da94441..6b73da94441 100644
--- a/sql/updates/world/2011_10_29_03_world_gameobject_template.sql
+++ b/sql/old/3.3.5a/2011_10_29_03_world_gameobject_template.sql
diff --git a/sql/updates/world/2011_10_29_04_world_linked_respawn.sql b/sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql
index 94d2c0d730d..94d2c0d730d 100644
--- a/sql/updates/world/2011_10_29_04_world_linked_respawn.sql
+++ b/sql/old/3.3.5a/2011_10_29_04_world_linked_respawn.sql
diff --git a/sql/updates/world/2011_10_29_05_world_sai.sql b/sql/old/3.3.5a/2011_10_29_05_world_sai.sql
index fc17ca8a1a7..fc17ca8a1a7 100644
--- a/sql/updates/world/2011_10_29_05_world_sai.sql
+++ b/sql/old/3.3.5a/2011_10_29_05_world_sai.sql
diff --git a/sql/updates/world/2011_10_29_06_world_misc.sql b/sql/old/3.3.5a/2011_10_29_06_world_misc.sql
index 7706777b32f..7706777b32f 100644
--- a/sql/updates/world/2011_10_29_06_world_misc.sql
+++ b/sql/old/3.3.5a/2011_10_29_06_world_misc.sql
diff --git a/sql/updates/world/2011_10_29_06_world_sai.sql b/sql/old/3.3.5a/2011_10_29_06_world_sai.sql
index a3d1626a8f9..a3d1626a8f9 100644
--- a/sql/updates/world/2011_10_29_06_world_sai.sql
+++ b/sql/old/3.3.5a/2011_10_29_06_world_sai.sql
diff --git a/sql/updates/world/2011_10_29_07_world_gameobjects.sql b/sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql
index 541cadd71a0..541cadd71a0 100644
--- a/sql/updates/world/2011_10_29_07_world_gameobjects.sql
+++ b/sql/old/3.3.5a/2011_10_29_07_world_gameobjects.sql
diff --git a/sql/updates/world/2011_10_30_00_world_misc.sql b/sql/old/3.3.5a/2011_10_30_00_world_misc.sql
index 912f13f364c..912f13f364c 100644
--- a/sql/updates/world/2011_10_30_00_world_misc.sql
+++ b/sql/old/3.3.5a/2011_10_30_00_world_misc.sql
diff --git a/sql/updates/world/2011_10_30_01_world_misc.sql b/sql/old/3.3.5a/2011_10_30_01_world_misc.sql
index 9c42045c821..9c42045c821 100644
--- a/sql/updates/world/2011_10_30_01_world_misc.sql
+++ b/sql/old/3.3.5a/2011_10_30_01_world_misc.sql
diff --git a/sql/updates/world/2011_10_30_02_world_creature_template.sql b/sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql
index 50fc50e9c14..50fc50e9c14 100644
--- a/sql/updates/world/2011_10_30_02_world_creature_template.sql
+++ b/sql/old/3.3.5a/2011_10_30_02_world_creature_template.sql
diff --git a/sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql b/sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql
index 5f7c3bf46f6..5f7c3bf46f6 100644
--- a/sql/updates/world/2011_10_30_02_world_player_factionchange_achievement.sql
+++ b/sql/old/3.3.5a/2011_10_30_02_world_player_factionchange_achievement.sql
diff --git a/sql/updates/world/2011_11_01_00_world_sai.sql b/sql/old/3.3.5a/2011_11_01_00_world_sai.sql
index f4e12082ea9..f4e12082ea9 100644
--- a/sql/updates/world/2011_11_01_00_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_01_00_world_sai.sql
diff --git a/sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql b/sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql
index 54a36473fb3..54a36473fb3 100644
--- a/sql/updates/world/2011_11_07_00_world_player_factionchange_items.sql
+++ b/sql/old/3.3.5a/2011_11_07_00_world_player_factionchange_items.sql
diff --git a/sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql b/sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql
index 2164d24ef5f..2164d24ef5f 100644
--- a/sql/updates/world/2011_11_07_01_world_areatrigger_teleport.sql
+++ b/sql/old/3.3.5a/2011_11_07_01_world_areatrigger_teleport.sql
diff --git a/sql/updates/world/2011_11_07_02_world_misc.sql b/sql/old/3.3.5a/2011_11_07_02_world_misc.sql
index b40ad4dc7bf..b40ad4dc7bf 100644
--- a/sql/updates/world/2011_11_07_02_world_misc.sql
+++ b/sql/old/3.3.5a/2011_11_07_02_world_misc.sql
diff --git a/sql/updates/world/2011_11_07_03_world_misc.sql b/sql/old/3.3.5a/2011_11_07_03_world_misc.sql
index 97b538237bd..97b538237bd 100644
--- a/sql/updates/world/2011_11_07_03_world_misc.sql
+++ b/sql/old/3.3.5a/2011_11_07_03_world_misc.sql
diff --git a/sql/updates/world/2011_11_11_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql
index 997ede4a886..997ede4a886 100644
--- a/sql/updates/world/2011_11_11_00_world_spell_proc_event.sql
+++ b/sql/old/3.3.5a/2011_11_11_00_world_spell_proc_event.sql
diff --git a/sql/updates/world/2011_11_11_01_world_misc.sql b/sql/old/3.3.5a/2011_11_11_01_world_misc.sql
index f48d3f8200e..f48d3f8200e 100644
--- a/sql/updates/world/2011_11_11_01_world_misc.sql
+++ b/sql/old/3.3.5a/2011_11_11_01_world_misc.sql
diff --git a/sql/updates/world/2011_11_13_00_world_spell_proc_event.sql b/sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql
index 393282c229c..393282c229c 100644
--- a/sql/updates/world/2011_11_13_00_world_spell_proc_event.sql
+++ b/sql/old/3.3.5a/2011_11_13_00_world_spell_proc_event.sql
diff --git a/sql/updates/world/2011_11_13_01_world_sai.sql b/sql/old/3.3.5a/2011_11_13_01_world_sai.sql
index 1a4ed5b29d9..1a4ed5b29d9 100644
--- a/sql/updates/world/2011_11_13_01_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_13_01_world_sai.sql
diff --git a/sql/updates/world/2011_11_13_02_world_pool_template.sql b/sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql
index 257398d4457..257398d4457 100644
--- a/sql/updates/world/2011_11_13_02_world_pool_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_02_world_pool_template.sql
diff --git a/sql/updates/world/2011_11_13_03_world_npc_trainer.sql b/sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql
index 0db753c008b..0db753c008b 100644
--- a/sql/updates/world/2011_11_13_03_world_npc_trainer.sql
+++ b/sql/old/3.3.5a/2011_11_13_03_world_npc_trainer.sql
diff --git a/sql/updates/world/2011_11_13_04_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql
index b68d12a031d..b68d12a031d 100644
--- a/sql/updates/world/2011_11_13_04_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_04_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_05_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql
index 722027bd343..722027bd343 100644
--- a/sql/updates/world/2011_11_13_05_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_05_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql b/sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql
index efb2fec72f3..efb2fec72f3 100644
--- a/sql/updates/world/2011_11_13_06_world_reference_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_06_world_reference_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_07_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql
index 728ce731313..728ce731313 100644
--- a/sql/updates/world/2011_11_13_07_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_07_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_08_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql
index 55f58d4fbba..55f58d4fbba 100644
--- a/sql/updates/world/2011_11_13_08_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_08_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_09_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql
index 6356c93a9ba..6356c93a9ba 100644
--- a/sql/updates/world/2011_11_13_09_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_09_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql
index 3052ba96745..3052ba96745 100644
--- a/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_10_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql
index 9f753577844..9f753577844 100644
--- a/sql/updates/world/2011_11_13_11_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_11_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql b/sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql
index 7982910cee6..7982910cee6 100644
--- a/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql
+++ b/sql/old/3.3.5a/2011_11_13_12_world_creature_loot_template.sql
diff --git a/sql/updates/world/2011_11_20_00_world_command.sql b/sql/old/3.3.5a/2011_11_20_00_world_command.sql
index 73d52974766..73d52974766 100644
--- a/sql/updates/world/2011_11_20_00_world_command.sql
+++ b/sql/old/3.3.5a/2011_11_20_00_world_command.sql
diff --git a/sql/updates/world/2011_11_20_01_world_sai.sql b/sql/old/3.3.5a/2011_11_20_01_world_sai.sql
index dbb4f39a499..dbb4f39a499 100644
--- a/sql/updates/world/2011_11_20_01_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_01_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_02_world_sai.sql b/sql/old/3.3.5a/2011_11_20_02_world_sai.sql
index f064aa67f9f..f064aa67f9f 100644
--- a/sql/updates/world/2011_11_20_02_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_02_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_03_world_sai.sql b/sql/old/3.3.5a/2011_11_20_03_world_sai.sql
index bd47430acd8..bd47430acd8 100644
--- a/sql/updates/world/2011_11_20_03_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_03_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_04_world_sai.sql b/sql/old/3.3.5a/2011_11_20_04_world_sai.sql
index e362b0d0866..e362b0d0866 100644
--- a/sql/updates/world/2011_11_20_04_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_04_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_05_world_sai.sql b/sql/old/3.3.5a/2011_11_20_05_world_sai.sql
index 464d0635bb8..464d0635bb8 100644
--- a/sql/updates/world/2011_11_20_05_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_05_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_06_world_sai.sql b/sql/old/3.3.5a/2011_11_20_06_world_sai.sql
index 68bffade858..68bffade858 100644
--- a/sql/updates/world/2011_11_20_06_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_06_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_07_world_sai.sql b/sql/old/3.3.5a/2011_11_20_07_world_sai.sql
index efb89f6ba5a..efb89f6ba5a 100644
--- a/sql/updates/world/2011_11_20_07_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_07_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql
index 6e121274acb..6e121274acb 100644
--- a/sql/updates/world/2011_11_20_08_world_achievement_criteria_data.sql
+++ b/sql/old/3.3.5a/2011_11_20_08_world_achievement_criteria_data.sql
diff --git a/sql/updates/world/2011_11_20_09_world_sai.sql b/sql/old/3.3.5a/2011_11_20_09_world_sai.sql
index 8931a7084d9..8931a7084d9 100644
--- a/sql/updates/world/2011_11_20_09_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_09_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_10_world_sai.sql b/sql/old/3.3.5a/2011_11_20_10_world_sai.sql
index b56fd826e95..b56fd826e95 100644
--- a/sql/updates/world/2011_11_20_10_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_10_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_11_world_sai.sql b/sql/old/3.3.5a/2011_11_20_11_world_sai.sql
index a05b26e6831..a05b26e6831 100644
--- a/sql/updates/world/2011_11_20_11_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_11_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_12_world_sai.sql b/sql/old/3.3.5a/2011_11_20_12_world_sai.sql
index 527db0e02e7..527db0e02e7 100644
--- a/sql/updates/world/2011_11_20_12_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_12_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_13_world_sai.sql b/sql/old/3.3.5a/2011_11_20_13_world_sai.sql
index c4cd10912a3..c4cd10912a3 100644
--- a/sql/updates/world/2011_11_20_13_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_13_world_sai.sql
diff --git a/sql/updates/world/2011_11_20_14_world_revert.sql b/sql/old/3.3.5a/2011_11_20_14_world_revert.sql
index 067c750b694..067c750b694 100644
--- a/sql/updates/world/2011_11_20_14_world_revert.sql
+++ b/sql/old/3.3.5a/2011_11_20_14_world_revert.sql
diff --git a/sql/updates/world/2011_11_20_15_world_sai.sql b/sql/old/3.3.5a/2011_11_20_15_world_sai.sql
index 8e0b4141379..8e0b4141379 100644
--- a/sql/updates/world/2011_11_20_15_world_sai.sql
+++ b/sql/old/3.3.5a/2011_11_20_15_world_sai.sql
diff --git a/sql/updates/world/2011_11_21_00_world_db_errors.sql b/sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql
index d3ae6fb197b..d3ae6fb197b 100644
--- a/sql/updates/world/2011_11_21_00_world_db_errors.sql
+++ b/sql/old/3.3.5a/2011_11_21_00_world_db_errors.sql
diff --git a/sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql b/sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql
index 7083107a8c2..7083107a8c2 100644
--- a/sql/updates/world/2011_11_21_01_pilgrim_achievement_reward.sql
+++ b/sql/old/3.3.5a/2011_11_21_01_pilgrim_achievement_reward.sql
diff --git a/sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql b/sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql
index 589dbb0b2a4..589dbb0b2a4 100644
--- a/sql/updates/world/2011_11_21_02_pilgrim_achievement_criteria_data.sql
+++ b/sql/old/3.3.5a/2011_11_21_02_pilgrim_achievement_criteria_data.sql
diff --git a/sql/updates/world/2011_11_21_03_pilgrim_misc.sql b/sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql
index 6547fe9a53a..6547fe9a53a 100644
--- a/sql/updates/world/2011_11_21_03_pilgrim_misc.sql
+++ b/sql/old/3.3.5a/2011_11_21_03_pilgrim_misc.sql
diff --git a/sql/updates/world/2011_11_21_04_pilgrim_misc.sql b/sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql
index 194c084ebc5..194c084ebc5 100644
--- a/sql/updates/world/2011_11_21_04_pilgrim_misc.sql
+++ b/sql/old/3.3.5a/2011_11_21_04_pilgrim_misc.sql
diff --git a/sql/updates/world/2011_11_21_05_pilgrim_tables.sql b/sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql
index 18881e14eaf..18881e14eaf 100644
--- a/sql/updates/world/2011_11_21_05_pilgrim_tables.sql
+++ b/sql/old/3.3.5a/2011_11_21_05_pilgrim_tables.sql
diff --git a/sql/updates/world/2011_11_24_00_world_version.sql b/sql/updates/world/2011_11_24_00_world_version.sql
new file mode 100644
index 00000000000..ad2396f29e1
--- /dev/null
+++ b/sql/updates/world/2011_11_24_00_world_version.sql
@@ -0,0 +1 @@
+UPDATE `version` SET `db_version`='TDB 335.11.44' LIMIT 1;
diff --git a/sql/updates/world/2011_11_25_00_world_quest_template.sql b/sql/updates/world/2011_11_25_00_world_quest_template.sql
new file mode 100644
index 00000000000..eee92a3761b
--- /dev/null
+++ b/sql/updates/world/2011_11_25_00_world_quest_template.sql
@@ -0,0 +1,38 @@
+ALTER TABLE `quest_template` ADD COLUMN `RequiredClasses` smallint(5) unsigned NOT NULL default '0' AFTER `Type`;
+
+UPDATE `quest_template`
+ SET `RequiredClasses` = `RequiredClasses`|
+ CASE `SkillOrClassMask`
+ WHEN -1 THEN 1 -- warrior
+ WHEN -2 THEN 2 -- paladin
+ WHEN -3 THEN 4 -- hunter
+ WHEN -4 THEN 8 -- rogue
+ WHEN -5 THEN 16 -- priest
+ WHEN -6 THEN 32 -- dk
+ WHEN -7 THEN 64 -- shaman
+ WHEN -8 THEN 128 -- mage
+ WHEN -9 THEN 256 -- warlock
+ WHEN -11 THEN 1024 -- druid
+ ELSE 0
+ END
+ WHERE `SkillOrClassMask` < 0;
+
+UPDATE `quest_template`
+ SET `RequiredClasses` = `RequiredClasses`|
+ CASE `ZoneOrSort`
+ WHEN -81 THEN 1 -- warrior
+ WHEN -141 THEN 2 -- paladin
+ WHEN -261 THEN 4 -- hunter
+ WHEN -162 THEN 8 -- rogue
+ WHEN -262 THEN 16 -- priest
+ WHEN -372 THEN 32 -- dk
+ WHEN -82 THEN 64 -- shaman
+ WHEN -161 THEN 128 -- mage
+ WHEN -61 THEN 256 -- warlock
+ WHEN -263 THEN 1024 -- druid
+ ELSE 0
+ END
+ WHERE `ZoneOrSort` < 0;
+
+UPDATE `quest_template` SET `SkillOrClassMask`=0 WHERE `SkillOrClassMask`<0;
+ALTER TABLE `quest_template` CHANGE COLUMN `SkillOrClassMask` `RequiredSkill` smallint(5) unsigned NOT NULL default '0' AFTER `RequiredRaces`;
diff --git a/sql/updates/world/2011_11_25_01_world_quest_template.sql b/sql/updates/world/2011_11_25_01_world_quest_template.sql
new file mode 100644
index 00000000000..f7e4555f093
--- /dev/null
+++ b/sql/updates/world/2011_11_25_01_world_quest_template.sql
@@ -0,0 +1 @@
+UPDATE `quest_template` SET `RequiredClasses`=0 WHERE `entry`=8249; -- Junkboxes Needed
diff --git a/sql/updates/world/2011_11_25_02_world_creature.sql b/sql/updates/world/2011_11_25_02_world_creature.sql
new file mode 100644
index 00000000000..0b26187f196
--- /dev/null
+++ b/sql/updates/world/2011_11_25_02_world_creature.sql
@@ -0,0 +1,4 @@
+-- re-guid
+DELETE FROM `creature` WHERE `guid`=1022681 OR (`guid`=48191 AND `id`=18069);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
+(48191, 18069, 530, 1, 1, 0, 0, -714.823, 7931.65, 58.8672, 4.3693, 300, 0, 0, 60720, 29330, 0, 0, 0, 0);
diff --git a/sql/updates/world/2011_11_26_00_world_quest_template.sql b/sql/updates/world/2011_11_26_00_world_quest_template.sql
new file mode 100644
index 00000000000..6a7834e0a76
--- /dev/null
+++ b/sql/updates/world/2011_11_26_00_world_quest_template.sql
@@ -0,0 +1,177 @@
+-- Naming
+ALTER TABLE `quest_template`
+ CHANGE `entry` `Id` mediumint(8) UNSIGNED NOT NULL default '0',
+ CHANGE `QuestLevel` `Level` smallint(3) NOT NULL DEFAULT '1',
+ CHANGE `RequiredSkill` `RequiredSkillId` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
+ CHANGE `RequiredSkillValue` `RequiredSkillPoints` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
+ CHANGE `RepObjectiveFaction` `RequiredFactionId1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
+ CHANGE `RepObjectiveFaction2` `RequiredFactionId2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
+ CHANGE `RepObjectiveValue` `RequiredFactionValue1` mediumint(9) default '0' NOT NULL,
+ CHANGE `RepObjectiveValue2` `RequiredFactionValue2` mediumint(9) default '0' NOT NULL,
+ CHANGE `QuestFlags` `Flags` int(10) UNSIGNED default '0' NOT NULL,
+ CHANGE `SpecialFlags` `SpecialFlags` tinyint(3) UNSIGNED default '0' NOT NULL,
+ CHANGE `CharTitleId` `RewardTitleId` tinyint(3) UNSIGNED default '0' NOT NULL,
+ CHANGE `PlayersSlain` `RequiredPlayerKills` tinyint(3) UNSIGNED default '0' NOT NULL,
+ CHANGE `BonusTalents` `RewardTalents` tinyint(3) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewardArenaPoints` `RewardArenaPoints` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `NextQuestInChain` `NextQuestIdChain` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewXPId` `RewardXPId` tinyint(2) UNSIGNED default '0' NOT NULL,
+ CHANGE `SrcItemId` `SourceItemId` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `SrcItemCount` `SourceItemCount` tinyint(3) UNSIGNED default '0' NOT NULL,
+ CHANGE `SrcSpell` `SourceSpellId` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId1` `RequiredItemId1` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId2` `RequiredItemId2` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId3` `RequiredItemId3` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId4` `RequiredItemId4` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId5` `RequiredItemId5` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemId6` `RequiredItemId6` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount1` `RequiredItemCount1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount2` `RequiredItemCount2` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount3` `RequiredItemCount3` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount4` `RequiredItemCount4` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount5` `RequiredItemCount5` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqItemCount6` `RequiredItemCount6` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceId1` `RequiredSourceItemId1` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceId2` `RequiredSourceItemId2` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceId3` `RequiredSourceItemId3` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceId4` `RequiredSourceItemId4` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceCount1` `RequiredSourceItemCount1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceCount2` `RequiredSourceItemCount2` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceCount3` `RequiredSourceItemCount3` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSourceCount4` `RequiredSourceItemCount4` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOId1` `RequiredNpcOrGo1` mediumint(9) default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOId2` `RequiredNpcOrGo2` mediumint(9) default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOId3` `RequiredNpcOrGo3` mediumint(9) default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOId4` `RequiredNpcOrGo4` mediumint(9) default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOCount1` `RequiredNpcOrGoCount1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOCount2` `RequiredNpcOrGoCount2` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOCount3` `RequiredNpcOrGoCount3` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqCreatureOrGOCount4` `RequiredNpcOrGoCount4` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSpellCast1` `RequiredSpellCast1` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSpellCast2` `RequiredSpellCast2` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSpellCast3` `RequiredSpellCast3` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `ReqSpellCast4` `RequiredSpellCast4` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId1` `RewardChoiceItemId1` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId2` `RewardChoiceItemId2` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId3` `RewardChoiceItemId3` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId4` `RewardChoiceItemId4` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId5` `RewardChoiceItemId5` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemId6` `RewardChoiceItemId6` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount1` `RewardChoiceItemCount1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount2` `RewardChoiceItemCount2` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount3` `RewardChoiceItemCount3` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount4` `RewardChoiceItemCount4` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount5` `RewardChoiceItemCount5` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewChoiceItemCount6` `RewardChoiceItemCount6` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemId1` `RewardItemId1` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemId2` `RewardItemId2` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemId3` `RewardItemId3` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemId4` `RewardItemId4` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemCount1` `RewardItemCount1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemCount2` `RewardItemCount2` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemCount3` `RewardItemCount3` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewItemCount4` `RewardItemCount4` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewRepFaction1` `RewardFactionId1` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case',
+ CHANGE `RewRepFaction2` `RewardFactionId2` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case',
+ CHANGE `RewRepFaction3` `RewardFactionId3` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case',
+ CHANGE `RewRepFaction4` `RewardFactionId4` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case',
+ CHANGE `RewRepFaction5` `RewardFactionId5` smallint(5) UNSIGNED default '0' NOT NULL comment 'faction id from Faction.dbc in this case',
+ CHANGE `RewRepValueId1` `RewardFactionValueId1` mediumint(6) default '0' NOT NULL,
+ CHANGE `RewRepValueId2` `RewardFactionValueId2` mediumint(6) default '0' NOT NULL,
+ CHANGE `RewRepValueId3` `RewardFactionValueId3` mediumint(6) default '0' NOT NULL,
+ CHANGE `RewRepValueId4` `RewardFactionValueId4` mediumint(6) default '0' NOT NULL,
+ CHANGE `RewRepValueId5` `RewardFactionValueId5` mediumint(6) default '0' NOT NULL,
+ CHANGE `RewRepValue1` `RewardFactionValueIdOverride1` mediumint(9) default '0' NOT NULL,
+ CHANGE `RewRepValue2` `RewardFactionValueIdOverride2` mediumint(9) default '0' NOT NULL,
+ CHANGE `RewRepValue3` `RewardFactionValueIdOverride3` mediumint(9) default '0' NOT NULL,
+ CHANGE `RewRepValue4` `RewardFactionValueIdOverride4` mediumint(9) default '0' NOT NULL,
+ CHANGE `RewRepValue5` `RewardFactionValueIdOverride5` mediumint(9) default '0' NOT NULL,
+ CHANGE `RewHonorAddition` `RewardHonor` int(10) default '0' NOT NULL,
+ CHANGE `RewHonorMultiplier` `RewardHonorMultiplier` float default '1' NOT NULL,
+ CHANGE `RewOrReqMoney` `RewardOrRequiredMoney` int(11) default '0' NOT NULL,
+ CHANGE `RewMoneyMaxLevel` `RewardMoneyMaxLevel` int(10) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewSpell` `RewardSpell` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewSpellCast` `RewardSpellCast` int(11) default '0' NOT NULL,
+ CHANGE `RewMailTemplateId` `RewardMailTemplateId` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `RewMailDelaySecs` `RewardMailDelay` int(11) UNSIGNED default '0' NOT NULL,
+ CHANGE `PointOpt` `PointOption` mediumint(8) UNSIGNED default '0' NOT NULL,
+ CHANGE `DetailsEmote1` `DetailsEmote1` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `IncompleteEmote` `EmoteOnIncomplete` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `CompleteEmote` `EmoteOnComplete` smallint(5) UNSIGNED default '0' NOT NULL,
+ CHANGE `unk0` `Unknown0` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
+
+-- Order
+ALTER TABLE `quest_template` CHANGE COLUMN `Level` `Level` SMALLINT(3) NOT NULL DEFAULT '1' AFTER `Method`,
+ CHANGE COLUMN `ZoneOrSort` `ZoneOrSort` SMALLINT(6) NOT NULL DEFAULT '0' AFTER `MaxLevel`,
+ CHANGE COLUMN `SuggestedPlayers` `SuggestedPlayers` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Type`,
+ CHANGE COLUMN `LimitTime` `LimitTime` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `SuggestedPlayers`,
+ CHANGE COLUMN `RequiredFactionId2` `RequiredFactionId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredFactionId1`,
+ CHANGE COLUMN `RequiredMaxRepFaction` `RequiredMaxRepFaction` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredMinRepFaction`,
+ CHANGE COLUMN `RewardOrRequiredMoney` `RewardOrRequiredMoney` INT(11) NOT NULL DEFAULT '0' AFTER `RewardXPId`,
+ CHANGE COLUMN `RewardMoneyMaxLevel` `RewardMoneyMaxLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardOrRequiredMoney`,
+ CHANGE COLUMN `RewardSpell` `RewardSpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMoneyMaxLevel`,
+ CHANGE COLUMN `RewardSpellCast` `RewardSpellCast` INT(11) NOT NULL DEFAULT '0' AFTER `RewardSpell`,
+ CHANGE COLUMN `RewardHonor` `RewardHonor` INT(10) NOT NULL DEFAULT '0' AFTER `RewardSpellCast`,
+ CHANGE COLUMN `RewardHonorMultiplier` `RewardHonorMultiplier` FLOAT NOT NULL DEFAULT '1' AFTER `RewardHonor`,
+ CHANGE COLUMN `RewardMailTemplateId` `RewardMailTemplateId` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardHonorMultiplier`,
+ CHANGE COLUMN `RewardMailDelay` `RewardMailDelay` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMailTemplateId`,
+ CHANGE COLUMN `Flags` `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `SourceSpellId`,
+ CHANGE COLUMN `SpecialFlags` `SpecialFlags` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`,
+ CHANGE COLUMN `RewardTitleId` `RewardTitleId` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `SpecialFlags`,
+ CHANGE COLUMN `RequiredPlayerKills` `RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTitleId`,
+ CHANGE COLUMN `RewardTalents` `RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredPlayerKills`,
+ CHANGE COLUMN `RewardArenaPoints` `RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTalents`,
+ CHANGE COLUMN `RewardItemId1` `RewardItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardArenaPoints`,
+ CHANGE COLUMN `RewardItemId2` `RewardItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId1`,
+ CHANGE COLUMN `RewardItemId3` `RewardItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId2`,
+ CHANGE COLUMN `RewardItemId4` `RewardItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId3`,
+ CHANGE COLUMN `RewardItemCount1` `RewardItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemId4`,
+ CHANGE COLUMN `RewardItemCount2` `RewardItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount1`,
+ CHANGE COLUMN `RewardItemCount3` `RewardItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount2`,
+ CHANGE COLUMN `RewardItemCount4` `RewardItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardItemCount3`,
+ CHANGE COLUMN `Title` `Title` TEXT NULL DEFAULT NULL AFTER `PointOption`,
+ CHANGE COLUMN `Objectives` `Objectives` TEXT NULL DEFAULT NULL AFTER `Title`,
+ CHANGE COLUMN `Details` `Details` TEXT NULL DEFAULT NULL AFTER `Objectives`,
+ CHANGE COLUMN `EndText` `EndText` TEXT NULL DEFAULT NULL AFTER `Details`,
+ CHANGE COLUMN `OfferRewardText` `OfferRewardText` TEXT NULL DEFAULT NULL AFTER `EndText`,
+ CHANGE COLUMN `RequestItemsText` `RequestItemsText` TEXT NULL DEFAULT NULL AFTER `OfferRewardText`,
+ CHANGE COLUMN `CompletedText` `CompletedText` TEXT NULL DEFAULT NULL AFTER `RequestItemsText`,
+ CHANGE COLUMN `RequiredNpcOrGo1` `RequiredNpcOrGo1` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `CompletedText`,
+ CHANGE COLUMN `RequiredNpcOrGo2` `RequiredNpcOrGo2` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo1`,
+ CHANGE COLUMN `RequiredNpcOrGo3` `RequiredNpcOrGo3` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo2`,
+ CHANGE COLUMN `RequiredNpcOrGo4` `RequiredNpcOrGo4` MEDIUMINT(9) NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo3`,
+ CHANGE COLUMN `RequiredNpcOrGoCount1` `RequiredNpcOrGoCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGo4`,
+ CHANGE COLUMN `RequiredNpcOrGoCount2` `RequiredNpcOrGoCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount1`,
+ CHANGE COLUMN `RequiredNpcOrGoCount3` `RequiredNpcOrGoCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount2`,
+ CHANGE COLUMN `RequiredNpcOrGoCount4` `RequiredNpcOrGoCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount3`,
+ CHANGE COLUMN `RequiredSourceItemId1` `RequiredSourceItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredNpcOrGoCount4`,
+ CHANGE COLUMN `RequiredSourceItemId2` `RequiredSourceItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId1`,
+ CHANGE COLUMN `RequiredSourceItemId3` `RequiredSourceItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId2`,
+ CHANGE COLUMN `RequiredSourceItemId4` `RequiredSourceItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId3`,
+ CHANGE COLUMN `RequiredSourceItemCount1` `RequiredSourceItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemId4`,
+ CHANGE COLUMN `RequiredSourceItemCount2` `RequiredSourceItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount1`,
+ CHANGE COLUMN `RequiredSourceItemCount3` `RequiredSourceItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount2`,
+ CHANGE COLUMN `RequiredSourceItemCount4` `RequiredSourceItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount3`,
+ CHANGE COLUMN `RequiredItemId1` `RequiredItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSourceItemCount4`,
+ CHANGE COLUMN `RequiredItemId2` `RequiredItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId1`,
+ CHANGE COLUMN `RequiredItemId3` `RequiredItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId2`,
+ CHANGE COLUMN `RequiredItemId4` `RequiredItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId3`,
+ CHANGE COLUMN `RequiredItemId5` `RequiredItemId5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId4`,
+ CHANGE COLUMN `RequiredItemId6` `RequiredItemId6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId5`,
+ CHANGE COLUMN `RequiredItemCount1` `RequiredItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemId6`,
+ CHANGE COLUMN `RequiredItemCount2` `RequiredItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount1`,
+ CHANGE COLUMN `RequiredItemCount3` `RequiredItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount2`,
+ CHANGE COLUMN `RequiredItemCount4` `RequiredItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount3`,
+ CHANGE COLUMN `RequiredItemCount5` `RequiredItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount4`,
+ CHANGE COLUMN `RequiredItemCount6` `RequiredItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount5`,
+ CHANGE COLUMN `RequiredSpellCast1` `RequiredSpellCast1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredItemCount6`,
+ CHANGE COLUMN `RequiredSpellCast2` `RequiredSpellCast2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast1`,
+ CHANGE COLUMN `RequiredSpellCast3` `RequiredSpellCast3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast2`,
+ CHANGE COLUMN `RequiredSpellCast4` `RequiredSpellCast4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast3`,
+ CHANGE COLUMN `Unknown0` `Unknown0` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredSpellCast4`,
+ CHANGE COLUMN `ObjectiveText1` `ObjectiveText1` TEXT NULL DEFAULT NULL AFTER `Unknown0`,
+ CHANGE COLUMN `ObjectiveText2` `ObjectiveText2` TEXT NULL DEFAULT NULL AFTER `ObjectiveText1`,
+ CHANGE COLUMN `ObjectiveText3` `ObjectiveText3` TEXT NULL DEFAULT NULL AFTER `ObjectiveText2`,
+ CHANGE COLUMN `ObjectiveText4` `ObjectiveText4` TEXT NULL DEFAULT NULL AFTER `ObjectiveText3`;
+
+-- Note: These two ALTER could have been merged into one
diff --git a/sql/updates/world/2011_11_26_01_world_quest_template.sql b/sql/updates/world/2011_11_26_01_world_quest_template.sql
new file mode 100644
index 00000000000..44548ec9981
--- /dev/null
+++ b/sql/updates/world/2011_11_26_01_world_quest_template.sql
@@ -0,0 +1 @@
+UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=14171;