diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2024_11_12_00_auth.sql | 5 |
2 files changed, 10 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index f4b69295116..85917812ed4 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2683,6 +2683,8 @@ CREATE TABLE `realmlist` ( `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', `localAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `address3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `address4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `localSubnetMask` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '255.255.255.0', `port` smallint unsigned NOT NULL DEFAULT '8085', `icon` tinyint unsigned NOT NULL DEFAULT '0', @@ -2705,7 +2707,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,57359,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,57359,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3148,7 +3150,8 @@ INSERT INTO `updates` VALUES ('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), ('2024_11_06_00_auth.sql','0C8D79745E070CEEE55D9546EC78FE89C5CCB040','RELEASED','2024-11-06 17:27:41',0), -('2024_11_11_00_auth.sql','F47CDFB857DB4105306739AF4FBBB3C92CA43363','RELEASED','2024-11-11 13:34:09',0); +('2024_11_11_00_auth.sql','F47CDFB857DB4105306739AF4FBBB3C92CA43363','RELEASED','2024-11-11 13:34:09',0), +('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','RELEASED','2024-11-12 11:42:13',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/cata_classic/2024_11_12_00_auth.sql b/sql/updates/auth/cata_classic/2024_11_12_00_auth.sql new file mode 100644 index 00000000000..3eb0af6c898 --- /dev/null +++ b/sql/updates/auth/cata_classic/2024_11_12_00_auth.sql @@ -0,0 +1,5 @@ +ALTER TABLE `realmlist` + MODIFY `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '127.0.0.1' AFTER `name`, + MODIFY `localAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '127.0.0.1' AFTER `address`, + ADD `address3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `localAddress`, + ADD `address4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `address3`; |