From 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e Mon Sep 17 00:00:00 2001 From: zartech22 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 --- sql/updates/auth/3.3.5/2020_04_18_00_auth.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/auth/3.3.5/2020_04_18_00_auth.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/3.3.5/2020_04_18_00_auth.sql b/sql/updates/auth/3.3.5/2020_04_18_00_auth.sql new file mode 100644 index 00000000000..afa498a0342 --- /dev/null +++ b/sql/updates/auth/3.3.5/2020_04_18_00_auth.sql @@ -0,0 +1,2 @@ +-- +ALTER TABLE `logs_ip_actions` ADD COLUMN `realm_id` INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Realm ID' AFTER `character_guid`; -- cgit v1.2.3