diff options
Diffstat (limited to 'AbuseFilter/abusefilter.tables.sqlite.sql')
-rw-r--r-- | AbuseFilter/abusefilter.tables.sqlite.sql | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/AbuseFilter/abusefilter.tables.sqlite.sql b/AbuseFilter/abusefilter.tables.sqlite.sql index d36c35ce..812e318b 100644 --- a/AbuseFilter/abusefilter.tables.sqlite.sql +++ b/AbuseFilter/abusefilter.tables.sqlite.sql @@ -31,7 +31,9 @@ CREATE INDEX afa_consequence ON /*$wgDBprefix*/abuse_filter_action (afa_conseque CREATE TABLE /*$wgDBprefix*/abuse_filter_log ( afl_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - afl_filter varbinary(64) NOT NULL, + afl_filter varbinary(64) NOT NULL DEFAULT '', + afl_global tinyint(1) NOT NULL DEFAULT 0, + afl_filter_id INTEGER NOT NULL DEFAULT 0, afl_user BIGINT unsigned NOT NULL, afl_user_text varbinary(255) NOT NULL, afl_ip varbinary(255) not null, @@ -44,17 +46,16 @@ CREATE TABLE /*$wgDBprefix*/abuse_filter_log ( afl_wiki varbinary(64) NULL, afl_deleted tinyint(1) NOT NULL DEFAULT 0, afl_patrolled_by int unsigned NULL, - afl_rev_id int unsigned, - afl_log_id int unsigned + afl_rev_id int unsigned ) /*$wgDBTableOptions*/; CREATE INDEX afl_filter_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_filter,afl_timestamp); +CREATE INDEX afl_filter_timestamp_full ON /*$wgDBprefix*/abuse_filter_log (afl_global,afl_filter_id,afl_timestamp); CREATE INDEX afl_user_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_user,afl_user_text,afl_timestamp); CREATE INDEX afl_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_timestamp); CREATE INDEX afl_page_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_namespace, afl_title, afl_timestamp); CREATE INDEX afl_ip_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_ip, afl_timestamp); CREATE INDEX afl_wiki_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_wiki, afl_timestamp); CREATE INDEX afl_rev_id ON /*$wgDBprefix*/abuse_filter_log (afl_rev_id); -CREATE INDEX afl_log_id ON /*$wgDBprefix*/abuse_filter_log (afl_log_id); CREATE TABLE /*$wgDBprefix*/abuse_filter_history ( afh_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |