Core: Update allowed build to 10.1.5.50622

2 files changed, 12 insertions, 3 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 0c0e80fede7..31ab26ef836 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -724,7 +724,8 @@ INSERT INTO `build_info` VALUES
 (50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL),
 (50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL),
 (50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL),
-(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL);
+(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL),
+(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2332,7 +2333,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 '50585',
+  `gamebuild` int unsigned NOT NULL DEFAULT '50622',
   `Region` tinyint unsigned NOT NULL DEFAULT '1',
   `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
@@ -2719,7 +2720,8 @@ INSERT INTO `updates` VALUES
 ('2023_07_14_01_auth.sql','8037C5101A08824DA6FE6B16E0004704DFC5B8FA','RELEASED','2023-07-14 19:35:41',0),
 ('2023_07_15_00_auth.sql','89D51F3E0EAAA957A7C0E4A4A7812505F61F12E6','RELEASED','2023-07-15 00:15:31',0),
 ('2023_07_19_00_auth.sql','8FE0EAB6C8DA5B060E95A9715F3D374340E361DD','RELEASED','2023-07-19 19:31:35',0),
-('2023_07_22_00_auth.sql','38BDC8DE5697366E26588552830E34E420861008','RELEASED','2023-07-22 13:57:13',0);
+('2023_07_22_00_auth.sql','38BDC8DE5697366E26588552830E34E420861008','RELEASED','2023-07-22 13:57:13',0),
+('2023_07_28_00_auth.sql','1CC6C4E639ED9FD2EABFD0713C4D809C707E5E3F','RELEASED','2023-07-28 20:03:06',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/master/2023_07_28_00_auth.sql b/sql/updates/auth/master/2023_07_28_00_auth.sql
new file mode 100644
index 00000000000..42680483bbf
--- /dev/null
+++ b/sql/updates/auth/master/2023_07_28_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=50622;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=50622 WHERE `gamebuild`=50585;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50622';