aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2023-11-16 09:44:07 +0100
committerOvahlord <dreadkiller@gmx.de>2023-11-16 09:44:07 +0100
commit59af16fd047fe3f5c2857b1a17705f0ddc9e6a1d (patch)
tree33d6c1f38e0fdc4cc77e98e1b7a07210c744d379 /sql/updates
parent0626473f8b3710161a75196c1d25e2a5e4efa1c2 (diff)
Core/Quests: downgrade quest fields
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.4.x/2023_11_16_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.4.x/2023_11_16_00_world.sql b/sql/updates/world/3.4.x/2023_11_16_00_world.sql
new file mode 100644
index 00000000000..47b00ad137d
--- /dev/null
+++ b/sql/updates/world/3.4.x/2023_11_16_00_world.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `quest_template`
+ 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`,
+ CHANGE `ContentTuningID` `QuestMinLevel` INT UNSIGNED DEFAULT 0 NOT NULL;