diff options
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2024_11_02_00_auth.sql | 3 |
2 files changed, 7 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 5cf01db2608..0e23a50231a 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2685,7 +2685,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint unsigned NOT NULL DEFAULT '0', `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0', `population` float NOT NULL DEFAULT '0', - `gamebuild` int unsigned NOT NULL DEFAULT '57244', + `gamebuild` int unsigned NOT NULL DEFAULT '57294', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2700,7 +2700,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,57244,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,57294,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3140,7 +3140,8 @@ INSERT INTO `updates` VALUES ('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_31_00_auth.sql','FCBF83D6981B26DE2807BDF338A3754972535906','RELEASED','2024-10-31 19:29:16',0); +('2024_10_31_00_auth.sql','FCBF83D6981B26DE2807BDF338A3754972535906','RELEASED','2024-10-31 19:29:16',0), +('2024_11_02_00_auth.sql','93A7F7A3C3BA586C139B4060180F7E032C535669','RELEASED','2024-11-02 12:35:24',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/cata_classic/2024_11_02_00_auth.sql b/sql/updates/auth/cata_classic/2024_11_02_00_auth.sql new file mode 100644 index 00000000000..8db0ef73f8c --- /dev/null +++ b/sql/updates/auth/cata_classic/2024_11_02_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=57294 WHERE `gamebuild`=57244; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '57294'; |