diff options
Diffstat (limited to 'www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql')
-rw-r--r-- | www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql new file mode 100644 index 00000000..c1d26508 --- /dev/null +++ b/www/wiki/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sqlite.sql @@ -0,0 +1,18 @@ +-- Patch to add abuse_filter_history table + +CREATE TABLE /*$wgDBprefix*/abuse_filter_history ( + afh_id BIGINT unsigned NOT NULL AUTO_INCREMENT, + afh_filter BIGINT unsigned NOT NULL, + afh_user BIGINT unsigned NOT NULL, + afh_user_text varchar(255) binary NOT NULL, + afh_timestamp binary(14) NOT NULL, + afh_pattern BLOB NOT NULL, + afh_comments BLOB NOT NULL, + afh_flags TINYBLOB NOT NULL, + afh_public_comments TINYBLOB, + afh_actions BLOB +) /*$wgDBTableOptions*/; +CREATE INDEX afh_filter ON /*$wgDBprefix*/abuse_filter_history (afh_filter); +CREATE INDEX afh_user ON /*$wgDBprefix*/abuse_filter_history (afh_user); +CREATE INDEX afh_user_text ON /*$wgDBprefix*/abuse_filter_history (afh_user_text); +CREATE INDEX afh_timestamp ON /*$wgDBprefix*/abuse_filter_history (afh_timestamp); |