aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2024-06-13 18:56:13 +0200
committerOvahlord <dreadkiller@gmx.de>2024-06-13 19:23:44 +0200
commit3d8602276d2e24e2ce75d9ba842e4201ec35e0dd (patch)
tree29395b2a92a786be23b11ddbcc4882ea9f3f1caa /sql/updates/world
parent992c4bc13e6713833eb09fa66c31726893f26a1a (diff)
Core/Quests: update quest_template fields to 4.4.0
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/cata_classic/2024_06_13_00_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_06_13_00_world.sql b/sql/updates/world/cata_classic/2024_06_13_00_world.sql
new file mode 100644
index 00000000000..2c05528a496
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_06_13_00_world.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `quest_template`
+ DROP COLUMN `ContentTuningID`,
+ ADD COLUMN `QuestLevel` INT DEFAULT 0 NOT NULL AFTER `QuestType`,
+ ADD COLUMN `QuestScalingFactionGroup` INT DEFAULT 0 NOT NULL AFTER `QuestLevel`,
+ ADD COLUMN `QuestMaxScalingLevel` INT DEFAULT 0 NOT NULL AFTER `QuestScalingFactionGroup`,
+ ADD COLUMN `MinLevel` INT DEFAULT 0 NOT NULL AFTER `QuestPackageID`;