Core: Updated to 11.0.2

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/master/2024_08_15_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_08_15_00_hotfixes.sql
new file mode 100644
index 00000000000..a07c2b5224b
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_08_15_00_hotfixes.sql
@@ -0,0 +1,21 @@
+ALTER TABLE `creature_model_data` MODIFY `MountScaleOther1` float NOT NULL DEFAULT 0 AFTER `Unknown1100`;
+ALTER TABLE `creature_model_data` MODIFY `MountScaleOther2` float NOT NULL DEFAULT 0 AFTER `MountScaleOther1`;
+
+ALTER TABLE `friendship_rep_reaction` MODIFY `FriendshipRepID` int NOT NULL DEFAULT 0 AFTER `Reaction`;
+ALTER TABLE `friendship_rep_reaction` MODIFY `ReactionThreshold` int NOT NULL DEFAULT 0 AFTER `FriendshipRepID`;
+
+ALTER TABLE `garr_mission` MODIFY `GarrFollowerTypeID` tinyint NOT NULL DEFAULT 0 AFTER `GarrMissionTypeID`;
+
+ALTER TABLE `garr_plot` MODIFY `PlotType` tinyint NOT NULL DEFAULT 0 AFTER `Name`;
+
+ALTER TABLE `map_difficulty` ADD `WorldStateExpressionID` int NOT NULL DEFAULT 0 AFTER `ContentTuningID`;
+
+ALTER TABLE `quest_sort` ADD `Flags` int NOT NULL DEFAULT 0 AFTER `UiOrderIndex`;
+
+ALTER TABLE `spell_shapeshift_form` DROP `CreatureDisplayID2`;
+ALTER TABLE `spell_shapeshift_form` DROP `CreatureDisplayID3`;
+ALTER TABLE `spell_shapeshift_form` DROP `CreatureDisplayID4`;
+
+ALTER TABLE `trait_cond` ADD `TraitNodeEntryID` int NOT NULL DEFAULT 0 AFTER `TraitNodeID`;
+
+ALTER TABLE `ui_map` ADD `MapArtZoneTextPosition` tinyint NOT NULL DEFAULT 0 AFTER `AdventureMapTextureKitID`;