Core: Update to 10.2.7

2 files changed, 15 insertions, 0 deletions

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`;