diff options
Diffstat (limited to 'AbuseFilter/db_patches/patch-abuse_filter_history.sql')
-rw-r--r-- | AbuseFilter/db_patches/patch-abuse_filter_history.sql | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/AbuseFilter/db_patches/patch-abuse_filter_history.sql b/AbuseFilter/db_patches/patch-abuse_filter_history.sql index 0cd7f07a..c1d26508 100644 --- a/AbuseFilter/db_patches/patch-abuse_filter_history.sql +++ b/AbuseFilter/db_patches/patch-abuse_filter_history.sql @@ -10,11 +10,9 @@ CREATE TABLE /*$wgDBprefix*/abuse_filter_history ( afh_comments BLOB NOT NULL, afh_flags TINYBLOB NOT NULL, afh_public_comments TINYBLOB, - afh_actions BLOB, - - PRIMARY KEY (afh_id), - KEY (afh_filter), - KEY (afh_user), - KEY (afh_user_text), - KEY (afh_timestamp) + 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); |