diff options
| author | zartech22 <kevin.plestan@outlook.fr> | 2020-04-18 14:26:05 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-18 14:26:05 +0200 |
| commit | 56f20d69a6ab23a9818f77fd4e2df541a7c30f0e (patch) | |
| tree | dd367c4500a1b2fad77cbb983fa3ac234815a0c6 /sql/updates | |
| parent | 6c7c2c6cd279813333e0b1cc1f60b22a04f368dd (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>
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/3.3.5/2020_04_18_00_auth.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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`; |