From f4c6e87267a9bdd20fc9ce32ad6afdc438a01353 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
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

