summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql')
-rw-r--r--www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql
new file mode 100644
index 00000000..40e3ada4
--- /dev/null
+++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-af_group.sql
@@ -0,0 +1,5 @@
+-- Add af_group field to abuse_filter table
+ALTER TABLE /*_*/abuse_filter add column af_group varchar(64) binary NOT NULL DEFAULT 'default';
+ALTER TABLE /*_*/abuse_filter_history add column afh_group varchar(64) binary NULL;
+
+CREATE INDEX /*i*/af_group ON /*_*/abuse_filter (af_group,af_enabled,af_id); \ No newline at end of file