Open main menu

Extension:AbuseFilter/abuse_filter table


FieldsEdit

af_idEdit

Primary key

af_patternEdit

The rules of the filter.

af_userEdit

User ID of the last modifier.

af_user_textEdit

User name of the last modifier.

af_timestampEdit

Typical MediaWiki timestamp of the last filter edit.

af_enabledEdit

Whether the filter is enabled. 1 if it is, 0 otherwise.

af_commentsEdit

Comments about the filter (the ones shown below the rules editor).

af_public_commentsEdit

The public name of the filter.

af_hiddenEdit

Whether the filter is hidden. 1 if it is, 0 otherwise.

af_hit_countEdit

The amount of hits registered by this filter.

af_throttledEdit

Whether the filter is throttled. 1 if it is, 0 otherwise.

af_deletedEdit

Whether the filter is deleted. 1 if it is, 0 otherwise.

af_actionsEdit

Comma-imploded list of actions enabled for this filter. For instance:

disallow,tag

af_globalEdit

Whether the filter is global. 1 if it is, 0 otherwise.

af_groupEdit

The group this filter belongs to, as defined in $wgAbuseFilterValidGroups.

SchemaEdit

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 |                |
+--------------------+---------------------+------+-----+---------+----------------+