From 4bec7233badf9d3ab71dbdde8b24f66f7c4eedfb Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 28 Jan 2023 01:53:26 +0100 Subject: Core: Updated to 10.0.5 --- sql/updates/auth/master/2023_01_28_00_auth.sql | 10 ++++++++++ sql/updates/characters/master/2023_01_28_00_characters.sql | 2 ++ 2 files changed, 12 insertions(+) create mode 100644 sql/updates/auth/master/2023_01_28_00_auth.sql create mode 100644 sql/updates/characters/master/2023_01_28_00_characters.sql (limited to 'sql/updates') 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'; -- cgit v1.2.3