From 468a06baf046b716305ee665e3cfd93c80e99457 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 8 May 2024 20:55:51 +0200 Subject: Core: Update to 10.2.7 --- sql/updates/auth/master/2024_05_08_00_auth.sql | 9 +++++++++ sql/updates/hotfixes/master/2024_05_08_00_hotfixes.sql | 6 ++++++ 2 files changed, 15 insertions(+) create mode 100644 sql/updates/auth/master/2024_05_08_00_auth.sql create mode 100644 sql/updates/hotfixes/master/2024_05_08_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2024_05_08_00_auth.sql b/sql/updates/auth/master/2024_05_08_00_auth.sql new file mode 100644 index 00000000000..53c8b7adb56 --- /dev/null +++ b/sql/updates/auth/master/2024_05_08_00_auth.sql @@ -0,0 +1,9 @@ +DELETE FROM `build_info` WHERE `build` IN (54577,54601,54604); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES +(54577,10,2,7,NULL,NULL,'CBBBBBFFB2C652F0F4A7848D86E1B063',NULL,NULL,NULL), +(54601,10,2,7,NULL,NULL,'F8B866CF7DB9A12273F35B3929627375',NULL,NULL,NULL), +(54604,10,2,7,NULL,NULL,'A5FF4CE535F69D4D7F638CB2C11F2243',NULL,NULL,NULL); + +UPDATE `realmlist` SET `gamebuild`=54604 WHERE `gamebuild`=54499; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54604'; diff --git a/sql/updates/hotfixes/master/2024_05_08_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_05_08_00_hotfixes.sql new file mode 100644 index 00000000000..b66ca1cf8c7 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_05_08_00_hotfixes.sql @@ -0,0 +1,6 @@ +ALTER TABLE `achievement` MODIFY COLUMN `Supercedes` int NOT NULL DEFAULT 0 AFTER `Faction`; + +ALTER TABLE `content_tuning` ADD COLUMN `HealthItemLevelCurveID` int NOT NULL DEFAULT 0 AFTER `ExpansionID`; +ALTER TABLE `content_tuning` ADD COLUMN `DamageItemLevelCurveID` int NOT NULL DEFAULT 0 AFTER `HealthItemLevelCurveID`; + +ALTER TABLE `item_modified_appearance` ADD COLUMN `Flags` int NOT NULL DEFAULT 0 AFTER `TransmogSourceTypeEnum`; -- cgit v1.2.3