diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_08_18_00_auth.sql | 1 |
2 files changed, 4 insertions, 1 deletions
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; diff --git a/sql/updates/auth/master/2024_08_18_00_auth.sql b/sql/updates/auth/master/2024_08_18_00_auth.sql new file mode 100644 index 00000000000..641e0d3d181 --- /dev/null +++ b/sql/updates/auth/master/2024_08_18_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` ADD `client_build` int unsigned NOT NULL DEFAULT '0' AFTER `muteby`; |