Extension:AbuseFilter/abuse filter table

af_id
Primary key

af_pattern
The rules of the filter.

af_user
User ID of the last modifier.

af_user_text
User name of the last modifier.

af_timestamp
Typical MediaWiki of the last filter edit.

af_enabled
Whether the filter is enabled.

  if it is,   otherwise.

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

af_public_comments
The public name of the filter.

af_hidden
Whether the filter is hidden.

  if it is,   otherwise.

af_hit_count
The amount of hits registered by this filter.

af_throttled
Whether the filter is throttled.

  if it is,   otherwise.

af_deleted
Whether the filter is deleted.

  if it is,   otherwise.

af_actions
Comma-imploded list of actions enabled for this filter.

For instance: disallow,tag

af_global
Whether the filter is global.

<tvar|1> </> if it is, <tvar|0> </> otherwise.

af_group
The group this filter belongs to, as defined in <tvar|1> </>.

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