From c4b710446d62c95eb8124175203fa5f394912594 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Sun, 18 Aug 2024 18:59:58 +0200
Subject: Core/Realms: Realmlist refactors

* Removed global realm variable from World and use RealmList everywhere
* Match auth build key with client version
* Restored allowedSecurityLevel checks for realmlist packet building
* Restored updating population field, mysteriously removed 15 years ago in f20b25d1c90f608deab28c9957b3b376ab2a0d50
---
 sql/base/auth_database.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'sql/base/auth_database.sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index a179f2f47eb..0e397fbf2b3 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -44,6 +44,7 @@ CREATE TABLE `account` (
   `mutetime` bigint NOT NULL DEFAULT '0',
   `mutereason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `muteby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `client_build` int unsigned NOT NULL DEFAULT '0',
   `locale` tinyint unsigned NOT NULL DEFAULT '0',
   `os` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `timezone_offset` smallint NOT NULL DEFAULT '0',
@@ -2869,7 +2870,8 @@ INSERT INTO `updates` VALUES
 ('2024_08_07_00_auth.sql','88070C3A95DE7242B3E3662D7B5B9648128DC187','RELEASED','2024-08-07 01:06:23',0),
 ('2024_08_09_00_auth.sql','854C24AAF0B3F673DAD8C0F3059DB266B0F34488','RELEASED','2024-08-09 15:40:42',0),
 ('2024_08_15_00_auth.sql','06E9AD907DC2B2CC0CF78414AB516BBA3ED0CE65','RELEASED','2024-08-15 19:40:50',0),
-('2024_08_17_00_auth.sql','3584B5A910334447D6E948DBAA0EEC43C42FE631','RELEASED','2024-08-17 15:17:22',0);
+('2024_08_17_00_auth.sql','3584B5A910334447D6E948DBAA0EEC43C42FE631','RELEASED','2024-08-17 15:17:22',0),
+('2024_08_18_00_auth.sql','5C1D0A3FE0245F4030FE446288AE533556EC6C9E','RELEASED','2024-08-17 23:01:21',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
-- 
cgit v1.2.3

