aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2024-11-02 12:41:05 +0100
committerOvahlord <dreadkiller@gmx.de>2024-11-02 12:41:05 +0100
commit7f05b1d35d2514a795366d3ddd277d07c4c73aee (patch)
treeaec24900fdc85bb3013ba930db1f3892b1509211 /sql
parent6de12ffcfa30355687f293a051dfae58ceac5cc7 (diff)
Core: updated allowed build to 4.4.1.57294
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql7
-rw-r--r--sql/updates/auth/cata_classic/2024_11_02_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 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';