Extension:AbuseFilter/abuse_filter table
Jump to navigation
Jump to search
Fields[edit]
af_id[edit]
Primary key
af_pattern[edit]
The rules of the filter.
af_user[edit]
User ID of the last modifier.
af_user_text[edit]
User name of the last modifier.
af_timestamp[edit]
Typical MediaWiki timestamp of the last filter edit.
af_enabled[edit]
Whether the filter is enabled.
1
if it is, 0
otherwise.
af_comments[edit]
Comments about the filter (the ones shown below the rules editor).
af_public_comments[edit]
The public name of the filter.
[edit]
Whether the filter is hidden.
1
if it is, 0
otherwise.
af_hit_count[edit]
The amount of hits registered by this filter.
af_throttled[edit]
Whether the filter is throttled.
1
if it is, 0
otherwise.
af_deleted[edit]
Whether the filter is deleted.
1
if it is, 0
otherwise.
af_actions[edit]
Comma-imploded list of actions enabled for this filter. For instance:
disallow,tag
af_global[edit]
Whether the filter is global.
1
if it is, 0
otherwise.
af_group[edit]
The group this filter belongs to, as defined in $wgAbuseFilterValidGroups
.
Schema[edit]
mysql> describe abuse_filter; +--------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+----------------+ | af_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | af_pattern | blob | NO | | NULL | | | af_user | bigint(20) unsigned | NO | MUL | NULL | | | af_user_text | varbinary(255) | NO | | NULL | | | af_timestamp | binary(14) | NO | | NULL | | | af_enabled | tinyint(1) | NO | | 1 | | | af_comments | blob | YES | | NULL | | | af_public_comments | tinyblob | YES | | NULL | | | af_hidden | tinyint(1) | NO | | 0 | | | af_hit_count | bigint(20) | NO | | 0 | | | af_throttled | tinyint(1) | NO | | 0 | | | af_deleted | tinyint(1) | NO | | 0 | | | af_actions | varbinary(255) | NO | | | | | af_global | tinyint(1) | NO | | 0 | | | af_group | varbinary(64) | NO | MUL | default | | +--------------------+---------------------+------+-----+---------+----------------+