Core: Updated to 11.2.7

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_12_15_00_world.sql b/sql/updates/world/master/2025_12_15_00_world.sql
new file mode 100644
index 00000000000..ffb348fc854
--- /dev/null
+++ b/sql/updates/world/master/2025_12_15_00_world.sql
@@ -0,0 +1,24 @@
+ALTER TABLE `gameobject_template` ADD `RequiredLevel` int NOT NULL DEFAULT 0 AFTER `ContentTuningId`;
+
+ALTER TABLE `quest_objectives`
+  ADD `SecondaryAmount` int NOT NULL DEFAULT 0 AFTER `Amount`,
+  ADD `ParentObjectiveID` int NOT NULL DEFAULT 0 AFTER `ProgressBarWeight`,
+  ADD `Visible` tinyint(1) unsigned NOT NULL DEFAULT 1 AFTER `ParentObjectiveID`;
+
+DROP TABLE IF EXISTS `quest_reward_house_room`;
+CREATE TABLE `quest_reward_house_room` (
+  `QuestID` int unsigned NOT NULL,
+  `OrderIndex` int NOT NULL,
+  `HouseRoomID` int NOT NULL,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`OrderIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+DROP TABLE IF EXISTS `quest_reward_house_decor`;
+CREATE TABLE `quest_reward_house_decor` (
+  `QuestID` int unsigned NOT NULL,
+  `OrderIndex` int NOT NULL,
+  `HouseDecorID` int NOT NULL,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`OrderIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;