Core: Updated to 10.2.6.53840

2 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2024_03_21_00_auth.sql b/sql/updates/auth/master/2024_03_21_00_auth.sql
new file mode 100644
index 00000000000..f26e8f4d9d8
--- /dev/null
+++ b/sql/updates/auth/master/2024_03_21_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=53840;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(53840,10,2,6,NULL,NULL,'AC97D745C60DD3DC5F973E55C0E3649E',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=53840 WHERE `gamebuild`=53584;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53840';
diff --git a/sql/updates/hotfixes/master/2024_03_21_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_03_21_00_hotfixes.sql
new file mode 100644
index 00000000000..5902b6936d9
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_03_21_00_hotfixes.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `achievement` ADD `HiddenBeforeDisplaySeason` int NOT NULL DEFAULT 0 AFTER `CovenantID`;
+ALTER TABLE `achievement` ADD `LegacyAfterTimeEvent` int NOT NULL DEFAULT 0 AFTER `HiddenBeforeDisplaySeason`;
+
+ALTER TABLE `adventure_journal` DROP `ItemID`;
+ALTER TABLE `adventure_journal` DROP `ItemQuantity`;