From 6de12ffcfa30355687f293a051dfae58ceac5cc7 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Fri, 1 Nov 2024 08:09:15 +0100 Subject: Core/Packets: updated packet structures for 4.4.1 --- sql/updates/world/cata_classic/2024_11_01_00_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/cata_classic/2024_11_01_00_world.sql (limited to 'sql') 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`; -- cgit v1.2.3