-- 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*/;