2 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2024_07_31_00_characters.sql b/sql/updates/characters/master/2024_07_31_00_characters.sql
new file mode 100644
index 00000000000..1411b4697dc
--- /dev/null
+++ b/sql/updates/characters/master/2024_07_31_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `groups` ADD `pingRestriction` tinyint AFTER `masterLooterGuid`;
+
+UPDATE `groups` SET `pingRestriction`=0;
+
+ALTER TABLE `groups` MODIFY `pingRestriction` tinyint NOT NULL;
diff --git a/sql/updates/world/master/2024_07_31_00_world.sql b/sql/updates/world/master/2024_07_31_00_world.sql
new file mode 100644
index 00000000000..6d7c72832de
--- /dev/null
+++ b/sql/updates/world/master/2024_07_31_00_world.sql
@@ -0,0 +1,15 @@
+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`
+  ADD `ResetByScheduler` tinyint NOT NULL DEFAULT '0' AFTER `QuestCompletionLog`,
+  DROP `TreasurePickerID`;