diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_21_00_auth.sql | 1 |
2 files changed, 3 insertions, 0 deletions
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; diff --git a/sql/updates/auth/master/2023_11_21_00_auth.sql b/sql/updates/auth/master/2023_11_21_00_auth.sql new file mode 100644 index 00000000000..1dc190782d7 --- /dev/null +++ b/sql/updates/auth/master/2023_11_21_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` ADD `timezone_offset` smallint NOT NULL DEFAULT '0' AFTER `os`; |