Core: Update to 10.1.7

2 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2023_09_07_00_auth.sql b/sql/updates/auth/master/2023_09_07_00_auth.sql
new file mode 100644
index 00000000000..508be5a7ec7
--- /dev/null
+++ b/sql/updates/auth/master/2023_09_07_00_auth.sql
@@ -0,0 +1,8 @@
+DELETE FROM `build_info` WHERE `build` IN (51187,51237);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL),
+(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=51237 WHERE `gamebuild`=51130;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51237';
diff --git a/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql
new file mode 100644
index 00000000000..61dbd08eb22
--- /dev/null
+++ b/sql/updates/hotfixes/master/2023_09_07_00_hotfixes.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `chr_classes` MODIFY `RolesMask` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `ClassColorB`;
+
+ALTER TABLE `chr_customization_element` ADD `ParticleColorID` int NOT NULL DEFAULT 0 AFTER `AnimKitID`;
+
+ALTER TABLE `creature_model_data` ADD `WalkSpeed` float NOT NULL DEFAULT 0 AFTER `FileDataID`;
+ALTER TABLE `creature_model_data` ADD `RunSpeed` float NOT NULL DEFAULT 0 AFTER `WalkSpeed`;
+
+ALTER TABLE `taxi_nodes` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `CharacterBitNumber`;
+
+ALTER TABLE `taxi_path_node` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `ContinentID`;