Core/DataStores: Updated db2 structures to 11.0.5

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql
new file mode 100644
index 00000000000..30d26be018b
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_10_23_00_hotfixes.sql
@@ -0,0 +1,11 @@
+ALTER TABLE `broadcast_text_duration` MODIFY `BroadcastTextID` int UNSIGNED NOT NULL DEFAULT 0 AFTER `Duration`;
+
+ALTER TABLE `chr_customization_option`
+  DROP `ChrRacesID`,
+  DROP `Sex`;
+
+ALTER TABLE `difficulty` ADD `Unknown1105` int NOT NULL DEFAULT 0 AFTER `GroupSizeSpellPointsCurveID`;
+
+ALTER TABLE `lfg_dungeons` ADD `MaxPremadeGroupSize` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `MentorCharLevel`;
+
+ALTER TABLE `spell_misc` ADD `Attributes16` int NOT NULL DEFAULT 0 AFTER `Attributes15`;