Core: Updated to 10.0.5

2 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2023_01_28_00_auth.sql b/sql/updates/auth/master/2023_01_28_00_auth.sql
new file mode 100644
index 00000000000..ac8e0126865
--- /dev/null
+++ b/sql/updates/auth/master/2023_01_28_00_auth.sql
@@ -0,0 +1,10 @@
+DELETE FROM `build_info` WHERE `build` IN (47777,47799,47825,47849);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(47777,10,0,5,NULL,NULL,'A88C04915AB9E035A104E55C4DCF5F9F',NULL,NULL,NULL),
+(47799,10,0,5,NULL,NULL,'7364EB093C23DB2CDC9513D5A7B4933E',NULL,NULL,NULL),
+(47825,10,0,5,NULL,NULL,'82A3B94E5E727AF3A208B471FF2054C0',NULL,NULL,NULL),
+(47849,10,0,5,NULL,NULL,'DD8BBE2087A28C0AF4984CBE23A1C707',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=47849 WHERE `gamebuild`=47631;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47849';
diff --git a/sql/updates/characters/master/2023_01_28_00_characters.sql b/sql/updates/characters/master/2023_01_28_00_characters.sql
new file mode 100644
index 00000000000..6a744624ecd
--- /dev/null
+++ b/sql/updates/characters/master/2023_01_28_00_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `mail` MODIFY `id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
+ALTER TABLE `mail_items` MODIFY `mail_id` bigint unsigned NOT NULL DEFAULT '0';