From 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e Mon Sep 17 00:00:00 2001
From: zartech22 <kevin.plestan@outlook.fr>
Date: Sat, 18 Apr 2020 14:26:05 +0200
Subject: Add realm ID for actions based ip logging (#24453)

* Update SQL queries to insert realm id

* Insert the realm id when logging actions based on IP

* Adding the SQL update file

* Update 9999_99_99_99_auth.sql

* Update auth structure

Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
---
 sql/base/auth_database.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'sql/base/auth_database.sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 77ecd7951c0..b9c7059bef4 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -341,6 +341,7 @@ CREATE TABLE `logs_ip_actions` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
   `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
   `character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
+  `realm_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Realm ID',
   `type` tinyint(3) unsigned NOT NULL,
   `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
   `systemnote` text COMMENT 'Notes inserted by system',
@@ -1959,7 +1960,8 @@ INSERT INTO `updates` VALUES
 ('2020_02_15_00_auth.sql','9CDBEBC722BEBB7C93091CF16EEB9C922C4116BD','ARCHIVED','2020-02-15 17:36:05',0),
 ('2020_03_16_00_auth.sql','B27E4CE14C713C73216930A7F3F770786D902A3F','ARCHIVED','2020-03-16 08:47:49',0),
 ('2020_04_07_00_auth.sql','6D73A4E1EC5382F10C39F20E2E6E764510A8A5E6','ARCHIVED','2020-04-07 22:23:35',0),
-('2020_04_15_00_auth.sql','031E61B50B03E40406F07C196826DB9016A7203F','ARCHIVED','2020-04-15 11:03:56',0);
+('2020_04_15_00_auth.sql','031E61B50B03E40406F07C196826DB9016A7203F','ARCHIVED','2020-04-15 11:03:56',0),
+('2020_04_18_00_auth.sql','BD962B50760771B60F2785027D6957EEF2009240','ARCHIVED','2020-04-18 14:09:28',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
-- 
cgit v1.2.3

