3 files changed, 41 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2023_07_12_00_auth.sql b/sql/updates/auth/master/2023_07_12_00_auth.sql
new file mode 100644
index 00000000000..a962847b081
--- /dev/null
+++ b/sql/updates/auth/master/2023_07_12_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=50401;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(50401,10,1,5,NULL,NULL,'3EEF52D902CCE81D16D0E255F0AA4938',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=50401 WHERE `gamebuild`=50000;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50401';
diff --git a/sql/updates/hotfixes/master/2023_07_12_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_07_12_00_hotfixes.sql
new file mode 100644
index 00000000000..d2ee5d6663a
--- /dev/null
+++ b/sql/updates/hotfixes/master/2023_07_12_00_hotfixes.sql
@@ -0,0 +1,33 @@
+--
+-- Table structure for table `conditional_chr_model`
+--
+DROP TABLE IF EXISTS `conditional_chr_model`;
+CREATE TABLE `conditional_chr_model` (
+  `ID` int(11) NOT NULL DEFAULT '0',
+  `ChrModelID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ChrCustomizationReqID` int(11) NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(11) NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
+  `ChrCustomizationCategoryID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+
+ALTER TABLE `area_table` MODIFY `MountFlags` int NOT NULL DEFAULT 0 AFTER `AmbientMultiplier`;
+
+ALTER TABLE `chr_customization_req` ADD `RaceMask` bigint NOT NULL DEFAULT 0 AFTER `ID`;
+
+ALTER TABLE `criteria` MODIFY `StartEvent` int NOT NULL DEFAULT 0 AFTER `ModifierTreeId`;
+ALTER TABLE `criteria` MODIFY `FailEvent` int NOT NULL DEFAULT 0 AFTER `StartTimer`;
+ALTER TABLE `criteria` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `FailAsset`;
+
+ALTER TABLE `criteria_tree` MODIFY `Operator` int NOT NULL DEFAULT 0 AFTER `Amount`;
+
+ALTER TABLE `gameobject_display_info` ADD `AlternateDisplayType` int NOT NULL DEFAULT 0 AFTER `OverrideNameScale`;
+ALTER TABLE `gameobject_display_info` ADD `ClientCreatureDisplayInfoID` int NOT NULL DEFAULT 0 AFTER `AlternateDisplayType`;
+ALTER TABLE `gameobject_display_info` ADD `ClientItemID` int NOT NULL DEFAULT 0 AFTER `ClientCreatureDisplayInfoID`;
+
+ALTER TABLE `spell_category` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Name`;
+
+ALTER TABLE `ui_map` ADD `VisibilityPlayerConditionID2` int NOT NULL DEFAULT 0 AFTER `BountyDisplayLocation`;
diff --git a/sql/updates/world/master/2023_07_12_00_world.sql b/sql/updates/world/master/2023_07_12_00_world.sql
new file mode 100644
index 00000000000..48fbe1b6dd5
--- /dev/null
+++ b/sql/updates/world/master/2023_07_12_00_world.sql
@@ -0,0 +1 @@
+ALTER TABLE `quest_template` MODIFY `TimeAllowed` bigint NOT NULL DEFAULT 0 AFTER `AreaGroupID`;