Core: Update to 10.0.7

2 files changed, 29 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2023_03_22_00_auth.sql b/sql/updates/auth/master/2023_03_22_00_auth.sql
new file mode 100644
index 00000000000..46edc6b85f7
--- /dev/null
+++ b/sql/updates/auth/master/2023_03_22_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=48676;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(48676,10,0,7,NULL,NULL,'E059FB74DFF6438CC20C7F28900F64CA',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=48676 WHERE `gamebuild`=48526;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48676';
diff --git a/sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql
new file mode 100644
index 00000000000..1a8a2278925
--- /dev/null
+++ b/sql/updates/hotfixes/master/2023_03_22_00_hotfixes.sql
@@ -0,0 +1,22 @@
+ALTER TABLE `area_trigger` MODIFY `AreaTriggerActionSetID` int NOT NULL DEFAULT 0 AFTER `ShapeID`;
+
+ALTER TABLE `currency_container` MODIFY `ContainerQuality` tinyint NOT NULL DEFAULT 0 AFTER `ContainerIconID`;
+
+ALTER TABLE `difficulty` MODIFY `GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT 0 AFTER `ToggleDifficultyID`;
+ALTER TABLE `difficulty` MODIFY `GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT 0 AFTER `GroupSizeHealthCurveID`;
+ALTER TABLE `difficulty` MODIFY `GroupSizeSpellPointsCurveID` int unsigned NOT NULL DEFAULT 0 AFTER `GroupSizeDmgCurveID`;
+
+ALTER TABLE `garr_building` MODIFY `GarrTypeID` tinyint NOT NULL DEFAULT 0 AFTER `Tooltip`;
+
+ALTER TABLE `garr_follower` MODIFY `GarrTypeID` tinyint NOT NULL DEFAULT 0 AFTER `TitleName`;
+
+ALTER TABLE `garr_mission` MODIFY `GarrTypeID` tinyint NOT NULL DEFAULT 0 AFTER `WorldPosY`;
+
+ALTER TABLE `garr_talent_tree` MODIFY `GarrTypeID` tinyint NOT NULL DEFAULT 0 AFTER `Name`;
+
+ALTER TABLE `languages` MODIFY `ID` int unsigned NOT NULL DEFAULT 0 AFTER `Name`;
+ALTER TABLE `languages` ADD `LearningCurveID` int NOT NULL DEFAULT 0 AFTER `UiTextureKitElementCount`;
+
+ALTER TABLE `quest_info` MODIFY `Profession` smallint unsigned NOT NULL DEFAULT 0 AFTER `Modifiers`;
+
+ALTER TABLE `trait_node_x_trait_cost` MODIFY `TraitNodeID` int NOT NULL DEFAULT 0 AFTER `ID`;