diff options
Diffstat (limited to 'AbuseFilter/abusefilter.tables.sql')
-rw-r--r-- | AbuseFilter/abusefilter.tables.sql | 83 |
1 files changed, 0 insertions, 83 deletions
diff --git a/AbuseFilter/abusefilter.tables.sql b/AbuseFilter/abusefilter.tables.sql deleted file mode 100644 index ff9bdb3d..00000000 --- a/AbuseFilter/abusefilter.tables.sql +++ /dev/null @@ -1,83 +0,0 @@ --- SQL tables for AbuseFilter extension - -CREATE TABLE /*$wgDBprefix*/abuse_filter ( - af_id BIGINT unsigned NOT NULL 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, - af_group varchar(64) binary NOT NULL DEFAULT 'default', - - PRIMARY KEY (af_id), - KEY (af_user), - KEY (af_group,af_enabled,af_id) -) /*$wgDBTableOptions*/; - -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), - KEY (afa_consequence) -) /*$wgDBTableOptions*/; - -CREATE TABLE /*$wgDBprefix*/abuse_filter_log ( - afl_id BIGINT unsigned NOT NULL 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, - afl_rev_id int unsigned, - afl_log_id int unsigned, - - PRIMARY KEY (afl_id), - KEY filter_timestamp (afl_filter,afl_timestamp), - KEY user_timestamp (afl_user,afl_user_text,afl_timestamp), - KEY (afl_timestamp), - KEY page_timestamp (afl_namespace, afl_title, afl_timestamp), - KEY ip_timestamp (afl_ip, afl_timestamp), - KEY (afl_rev_id), - KEY (afl_log_id), - KEY wiki_timestamp (afl_wiki, afl_timestamp) -) /*$wgDBTableOptions*/; - -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, - afh_deleted tinyint(1) NOT NULL DEFAULT 0, - afh_changed_fields varchar(255) NOT NULL DEFAULT '', - afh_group varchar(64) binary NULL, - - PRIMARY KEY (afh_id), - KEY (afh_filter), - KEY (afh_user), - KEY (afh_user_text), - KEY (afh_timestamp) -) /*$wgDBTableOptions*/; |