aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/base/auth_database.sql7
-rw-r--r--sql/updates/auth/cata_classic/2025_04_06_00_auth.sql3
2 files changed, 7 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 3c3cc6e424e..50098aa9b8e 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2759,7 +2759,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 '59069',
+ `gamebuild` int unsigned NOT NULL DEFAULT '60142',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -2774,7 +2774,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',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,59069,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,60142,1,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3227,7 +3227,8 @@ INSERT INTO `updates` VALUES
('2025_02_13_00_auth.sql','85B38293CCFFC74094F56A6A1ACAB87E7DC5BB7E','ARCHIVED','2025-02-13 16:45:59',0),
('2025_02_19_01_auth.sql','9435D6201F67CB303DA4C66F76061056BD744792','RELEASED','2025-02-19 14:30:51',0),
('2025_02_20_00_auth.sql','AB6B8CAF5D4B7BDADE896EF9E54FE9384D0BFF61','RELEASED','2025-02-20 10:49:50',0),
-('2025_04_05_00_auth.sql','2523EEC30D3456441CF4EA8ED5E529506CED238B','RELEASED','2025-04-05 15:16:45',0);
+('2025_04_05_00_auth.sql','2523EEC30D3456441CF4EA8ED5E529506CED238B','RELEASED','2025-04-05 15:16:45',0),
+('2025_04_06_00_auth.sql','D65E53E402A789FC413131E1720830B43FEAD967','RELEASED','2025-04-06 19:08:23',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql b/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql
new file mode 100644
index 00000000000..a317fba72b4
--- /dev/null
+++ b/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql
@@ -0,0 +1,3 @@
+UPDATE `realmlist` SET `gamebuild`=60142 WHERE `gamebuild`=59069;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60142';