Core/Packets: updated packet structures for 4.4.1

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_11_01_00_world.sql b/sql/updates/world/cata_classic/2024_11_01_00_world.sql
new file mode 100644
index 00000000000..c17061079ba
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_11_01_00_world.sql
@@ -0,0 +1,14 @@
+ALTER TABLE `gossip_menu_addon` ADD `LfgDungeonsID` int NOT NULL DEFAULT '0' AFTER `FriendshipFactionID`;
+
+DROP TABLE IF EXISTS `quest_treasure_pickers`;
+CREATE TABLE `quest_treasure_pickers` (
+  `QuestID` int unsigned NOT NULL,
+  `TreasurePickerID` int NOT NULL,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`TreasurePickerID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+INSERT INTO `quest_treasure_pickers` SELECT `ID`, `TreasurePickerID`, 0 FROM `quest_template` WHERE `TreasurePickerID` <> 0;
+
+ALTER TABLE `quest_template`
+  DROP `TreasurePickerID`;