diff options
author | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
---|---|---|
committer | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
commit | fc7369835258467bf97eb64f184b93691f9a9fd5 (patch) | |
tree | daabd60089d2dd76d9f5fb416b005fbe159c799d /www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql |
first commit
Diffstat (limited to 'www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql')
-rw-r--r-- | www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql new file mode 100644 index 00000000..85eab834 --- /dev/null +++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-afl_action_id.sql @@ -0,0 +1,8 @@ +-- Store the ID of successful actions in the abuse_filter_log table. +ALTER TABLE /*_*/abuse_filter_log + ADD COLUMN afl_rev_id int unsigned; +CREATE INDEX /*i*/afl_rev_id ON /*_*/abuse_filter_log (afl_rev_id); + +ALTER TABLE /*_*/abuse_filter_log + ADD COLUMN afl_log_id int unsigned; +CREATE INDEX /*i*/afl_log_id ON /*_*/abuse_filter_log (afl_log_id);
\ No newline at end of file |