From 070cd23b6cf2e985713b90455cb7f7c53535cbcf Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 21 Nov 2023 12:25:22 +0100 Subject: Core/Calendar: Implement different timezone support for ingame calendar Closes #8390 Closes #29427 (cherry picked from commit b888b1b09f71a8b8b4a9d45c804a1f164fb65ac3) --- sql/base/auth_database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 32724d2ef56..8a82e84f05c 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -46,6 +46,7 @@ CREATE TABLE `account` ( `muteby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `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', `recruiter` int unsigned NOT NULL DEFAULT '0', `battlenet_account` int unsigned DEFAULT NULL, `battlenet_index` tinyint unsigned DEFAULT NULL, @@ -2759,6 +2760,7 @@ INSERT INTO `updates` VALUES ('2023_11_09_01_auth.sql','BC9BC28D41608A78166B5A38F3A7F598FBDB879D','RELEASED','2023-11-09 18:21:59',0), ('2023_11_14_00_auth.sql','192D729737C5E3332D7B5B9B7F9DBDD9626D7B98','RELEASED','2023-11-14 11:36:05',0), ('2023_11_15_00_auth.sql','DC89EA5C9D799C213B3E6A606F081697ADEF8250','RELEASED','2023-11-15 10:47:53',0), +('2023_11_21_00_auth.sql','146E5E6EF94C5DB78343372A8FDB32B062B80040','RELEASED','2023-11-21 11:24:11',0), ('2023_11_23_00_auth.sql','EC3D1289A07E387BF4D2AC94EEBE3A29483EAD3A','RELEASED','2023-11-23 02:39:18',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3