diff options
| author | zartech22 <kevin.plestan@outlook.fr> | 2020-04-18 14:26:05 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-01 19:38:40 +0100 |
| commit | c57c26d7fbead1ae342aba2e1e082db27c944c8d (patch) | |
| tree | a2a2e163a1d94a14cbf3e07e8ae116e44ef921df /sql | |
| parent | e67e0ff9fbbb26d2b9b8b8d2ec0233cee24d46ba (diff) | |
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>
(cherry picked from commit 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/master/2020_04_18_00_auth.sql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 59ab9e5ce56..e92027d02aa 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -688,6 +688,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` bigint(20) 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', @@ -2466,6 +2467,7 @@ INSERT INTO `updates` VALUES ('2020_03_31_00_auth.sql','BA82A58E95730A397922B6723DA027986E6CD535','ARCHIVED','2020-03-31 17:00:16',0), ('2020_04_04_00_auth.sql','5F118989A9F8AFA3B2065AB9C2C0BB7D9A0EB97A','ARCHIVED','2020-04-04 13:23:53',0), ('2020_04_07_00_auth.sql','6D73A4E1EC5382F10C39F20E2E6E764510A8A5E6','ARCHIVED','2020-04-07 22:23:35',0), +('2020_04_18_00_auth.sql','BD962B50760771B60F2785027D6957EEF2009240','ARCHIVED','2020-04-18 14:09:28',0), ('2020_04_30_00_auth.sql','2FD304B8EF82D529D69287BF22EF061A267F827E','ARCHIVED','2020-04-30 00:39:29',0), ('2020_05_19_00_auth.sql','12D9F26538F63546B74793499E8A71BD885E8E5F','ARCHIVED','2020-05-19 12:00:00',0), ('2020_06_04_00_auth.sql','BA797B558196B1A07F8FF66E5288AD04659CF6AC','ARCHIVED','2020-06-04 09:57:07',0), diff --git a/sql/updates/auth/master/2020_04_18_00_auth.sql b/sql/updates/auth/master/2020_04_18_00_auth.sql new file mode 100644 index 00000000000..afa498a0342 --- /dev/null +++ b/sql/updates/auth/master/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`; |