diff options
| -rw-r--r-- | sql/base/auth_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_07_22_00_auth.sql | 7 |
2 files changed, 12 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index dcd1fbe7ba1..0c0e80fede7 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -723,7 +723,8 @@ INSERT INTO `build_info` VALUES (50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL), (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); +(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL), +(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2331,7 +2332,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 '50504', + `gamebuild` int unsigned NOT NULL DEFAULT '50585', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2717,7 +2718,8 @@ INSERT INTO `updates` VALUES ('2023_07_14_00_auth.sql','B66CDB7EE7E554992BB2A9DAB3C16122411C81DF','ARCHIVED','2023-07-14 08:24:44',0), ('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_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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2023_07_22_00_auth.sql b/sql/updates/auth/master/2023_07_22_00_auth.sql new file mode 100644 index 00000000000..cd88b6e3f2a --- /dev/null +++ b/sql/updates/auth/master/2023_07_22_00_auth.sql @@ -0,0 +1,7 @@ +DELETE FROM `build_info` WHERE `build`=50585; +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES +(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL); + +UPDATE `realmlist` SET `gamebuild`=50585 WHERE `gamebuild`=50504; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50585'; |