diff options
Diffstat (limited to 'AbuseFilter/abusefilter.tables.sqlite.sql')
-rw-r--r-- | AbuseFilter/abusefilter.tables.sqlite.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/AbuseFilter/abusefilter.tables.sqlite.sql b/AbuseFilter/abusefilter.tables.sqlite.sql new file mode 100644 index 00000000..6c82370f --- /dev/null +++ b/AbuseFilter/abusefilter.tables.sqlite.sql @@ -0,0 +1,70 @@ +-- SQL tables for AbuseFilter extension + +CREATE TABLE /*$wgDBprefix*/abuse_filter ( + af_id BIGINT unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, + af_pattern BLOB NOT NULL, + af_user BIGINT unsigned NOT NULL, + af_user_text varchar(255) binary NOT NULL, + af_timestamp binary(14) NOT NULL, + af_enabled tinyint(1) not null default 1, + af_comments BLOB, + af_public_comments TINYBLOB, + af_hidden tinyint(1) not null default 0, + af_hit_count bigint not null default 0, + af_throttled tinyint(1) NOT NULL default 0, + af_deleted tinyint(1) NOT NULL DEFAULT 0, + af_actions varchar(255) NOT NULL DEFAULT '', + af_global tinyint(1) NOT NULL DEFAULT 0 +) /*$wgDBTableOptions*/; +CREATE INDEX af_user ON /*$wgDBprefix*/abuse_filter (af_user); + +CREATE TABLE /*$wgDBprefix*/abuse_filter_action ( + afa_filter BIGINT unsigned NOT NULL, + afa_consequence varchar(255) NOT NULL, + afa_parameters TINYBLOB NOT NULL, + + PRIMARY KEY (afa_filter,afa_consequence) +) /*$wgDBTableOptions*/; +CREATE INDEX afa_consequence ON /*$wgDBprefix*/abuse_filter_action (afa_consequence); + +CREATE TABLE /*$wgDBprefix*/abuse_filter_log ( + afl_id BIGINT unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, + afl_filter varchar(64) binary NOT NULL, + afl_user BIGINT unsigned NOT NULL, + afl_user_text varchar(255) binary NOT NULL, + afl_ip varchar(255) not null, + afl_action varbinary(255) not null, + afl_actions varbinary(255) not null, + afl_var_dump BLOB NOT NULL, + afl_timestamp binary(14) NOT NULL, + afl_namespace int NOT NULL, + afl_title varchar(255) binary NOT NULL, + afl_wiki varchar(64) binary NULL, + afl_deleted tinyint(1) NOT NULL DEFAULT 0, + afl_patrolled_by int unsigned NULL +) /*$wgDBTableOptions*/; +CREATE INDEX afl_filter_timestamp ON /*$wgDBprefix*/abuse_filter_log (afl_filter,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 TABLE /*$wgDBprefix*/abuse_filter_history ( + afh_id BIGINT unsigned NOT NULL PRIMARY KEY 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, + afh_deleted tinyint(1) NOT NULL DEFAULT 0, + afh_changed_fields varchar(255) NOT NULL DEFAULT '' +) /*$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); |