DB: Added build keys for 4.4.1.57294 for future use

2 files changed, 22 insertions, 3 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 998efc3c4dc..5cf01db2608 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -751,7 +751,11 @@ INSERT INTO `build_auth_key` VALUES
 (57244,'Mac','A64','WoW',0x4DC6904ECDDB8D45209C9A1A1EAFDF34),
 (57244,'Mac','x64','WoW',0x0D662EAB1F2F0EC74F6D11F167F378B6),
 (57244,'Win','A64','WoW',0x9A849BAEEC89BDBF3ADE5FEDDBB27A74),
-(57244,'Win','x64','WoW',0xF972E54BD89E8AD83420C6E3DEFA267F);
+(57244,'Win','x64','WoW',0xF972E54BD89E8AD83420C6E3DEFA267F),
+(57294,'Mac','A64','WoW',0x8122F4637E54772F141A221CF838023F),
+(57294,'Mac','x64','WoW',0x20593AF7916DE92889DFAD00E56EC3E2),
+(57294,'Win','A64','WoW',0xE082A35A1F6AC2C86FB3D9AE2564E0A7),
+(57294,'Win','x64','WoW',0xCEAD7331A86E61C4119261FD2DA1BB43);
 /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1070,7 +1074,8 @@ INSERT INTO `build_info` VALUES
 (56420,4,4,0,NULL),
 (56489,4,4,0,NULL),
 (56713,4,4,0,NULL),
-(57244,4,4,0,NULL);
+(57244,4,4,0,NULL),
+(57294,4,4,1,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3134,7 +3139,8 @@ INSERT INTO `updates` VALUES
 ('2024_09_24_00_auth.sql','E20C474C16DACB9A10180F58D824B91378DABC32','ARCHIVED','2024-09-24 12:19:13',0),
 ('2024_09_26_00_auth.sql','E37C3997FD7851EA360774AC568912846C448272','ARCHIVED','2024-09-26 18:27:26',0),
 ('2024_10_24_00_auth.sql','B6DEDDEA09595E6E9520D076F02FFDF7ED615517','ARCHIVED','2024-10-24 16:16:03',0),
-('2024_10_27_00_auth.sql','D0D457EB1827ACC5908B3AC11239D0DC281BEB0F','ARCHIVED','2024-10-27 19:22:40',0);
+('2024_10_27_00_auth.sql','D0D457EB1827ACC5908B3AC11239D0DC281BEB0F','ARCHIVED','2024-10-27 19:22:40',0),
+('2024_10_31_00_auth.sql','FCBF83D6981B26DE2807BDF338A3754972535906','RELEASED','2024-10-31 19:29:16',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/cata_classic/2024_10_31_00_auth.sql b/sql/updates/auth/cata_classic/2024_10_31_00_auth.sql
new file mode 100644
index 00000000000..f857a3f9ead
--- /dev/null
+++ b/sql/updates/auth/cata_classic/2024_10_31_00_auth.sql
@@ -0,0 +1,13 @@
+DELETE FROM `build_info` WHERE `build` IN (57294);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(57294,4,4,1,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=57294 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57294 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57294 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57294 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(57294,'Mac','A64','WoW',0x8122F4637E54772F141A221CF838023F),
+(57294,'Mac','x64','WoW',0x20593AF7916DE92889DFAD00E56EC3E2),
+(57294,'Win','A64','WoW',0xE082A35A1F6AC2C86FB3D9AE2564E0A7),
+(57294,'Win','x64','WoW',0xCEAD7331A86E61C4119261FD2DA1BB43);