Core: Update to 10.2.7

3 files changed, 23 insertions, 4 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ff6e8a36411..9365db44649 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -774,7 +774,10 @@ INSERT INTO `build_info` VALUES
 (54070,10,2,6,NULL,NULL,'FDA08264B7587250CF78F9B960218169',NULL,NULL,NULL),
 (54205,10,2,6,NULL,NULL,'589D59EB3F0D6D77C2175D9302F78FDD',NULL,NULL,NULL),
 (54358,10,2,6,NULL,NULL,'89C733D366E845FB9264404CD48CCA89',NULL,NULL,NULL),
-(54499,10,2,6,NULL,NULL,'6AC1F6180FC4C390F782DB933BD83326',NULL,NULL,NULL);
+(54499,10,2,6,NULL,NULL,'6AC1F6180FC4C390F782DB933BD83326',NULL,NULL,NULL),
+(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);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2384,7 +2387,7 @@ CREATE TABLE `realmlist` (
   `timezone` tinyint unsigned NOT NULL DEFAULT '0',
   `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `population` float unsigned NOT NULL DEFAULT '0',
-  `gamebuild` int unsigned NOT NULL DEFAULT '54499',
+  `gamebuild` int unsigned NOT NULL DEFAULT '54604',
   `Region` tinyint unsigned NOT NULL DEFAULT '1',
   `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
@@ -2399,7 +2402,7 @@ CREATE TABLE `realmlist` (
 LOCK TABLES `realmlist` WRITE;
 /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
 INSERT INTO `realmlist` VALUES
-(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,54499,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,54604,1,1);
 /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2820,7 +2823,8 @@ INSERT INTO `updates` VALUES
 ('2024_04_08_00_auth.sql','B05516DB306A06982206180A2A18407D9E0012DE','RELEASED','2024-04-08 21:56:33',0),
 ('2024_04_12_00_auth.sql','3D2DCEA21AE5104EF192CACAAFBB5131AD355791','RELEASED','2024-04-12 12:07:49',0),
 ('2024_04_22_00_auth.sql','83566EA54235D588697D747D8130CD6D37445CC5','RELEASED','2024-04-22 23:05:46',0),
-('2024_05_01_00_auth.sql','2A1C2B4E54706BDD1FDD57AFB943058BEE8D8852','RELEASED','2024-05-01 21:32:43',0);
+('2024_05_01_00_auth.sql','2A1C2B4E54706BDD1FDD57AFB943058BEE8D8852','RELEASED','2024-05-01 21:32:43',0),
+('2024_05_08_00_auth.sql','F2EEE0D225CB82DBB3A478E0BF6A0116C9265355','RELEASED','2024-05-08 20:35:53',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
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`;