From f4c6e87267a9bdd20fc9ce32ad6afdc438a01353 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 1 Jan 2022 19:36:46 +0100 Subject: DB: Sync structure of a shared auth table between branches --- sql/base/auth_database.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/base/auth_database.sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 0b7a5e69f96..0c3e4cd9993 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -341,7 +341,7 @@ DROP TABLE IF EXISTS `logs_ip_actions`; CREATE TABLE `logs_ip_actions` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', `account_id` int unsigned NOT NULL COMMENT 'Account ID', - `character_guid` int unsigned NOT NULL COMMENT 'Character Guid', + `character_guid` bigint unsigned NOT NULL COMMENT 'Character Guid', `realm_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Realm ID', `type` tinyint unsigned NOT NULL, `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', @@ -1996,7 +1996,8 @@ INSERT INTO `updates` VALUES ('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0), ('2021_10_15_00_auth.sql','4FFD29A3ED1DB13874E755A84BFD7ABA2DF5C2DB','ARCHIVED','2021-10-15 08:43:41',0), ('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0), -('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0); +('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0), +('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','RELEASED','2022-01-01 19:35:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3