summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'AbuseFilter/abusefilter.tables.sql')
-rw-r--r--AbuseFilter/abusefilter.tables.sql83
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*/;