diff options
Diffstat (limited to 'AbuseFilter/abusefilter.tables.sqlite.sql')
| -rw-r--r-- | AbuseFilter/abusefilter.tables.sqlite.sql | 70 |
1 files changed, 0 insertions, 70 deletions
diff --git a/AbuseFilter/abusefilter.tables.sqlite.sql b/AbuseFilter/abusefilter.tables.sqlite.sql deleted file mode 100644 index 6c82370f..00000000 --- a/AbuseFilter/abusefilter.tables.sqlite.sql +++ /dev/null @@ -1,70 +0,0 @@ --- 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); |