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