Primary key
ID of the filter.
User ID of the modifier.
User name of the modifier.
Typical MediaWikitimestamp of the filter edit.
The rules of this version of the filter.
The notes of this version of the filter.
A comma-imploded list of flags of this version of the filter.Example:
enabled,hidden
The public name of this version of the filter.
A serialized array with the actions and their parameters relative to this action of the filter.
Whether this version of the filter is deleted.1 if it is,0 otherwise.
A comma-imploded list of fields changed in this version.Each one can be either "actions" or one of the following columns from theabuse_filter table:
af_public_comments, af_pattern, af_comments, af_deleted, af_enabled, af_hidden, af_global, af_group
The group this version of the filter belongs to, as defined in$wgAbuseFilterValidGroups.
mysql> describe abuse_filter_history;+---------------------+---------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+---------------------+---------------------+------+-----+---------+----------------+| afh_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment || afh_filter | bigint(20) unsigned | NO | MUL | NULL | || afh_user | bigint(20) unsigned | NO | MUL | NULL | || afh_user_text | varbinary(255) | NO | MUL | NULL | || afh_timestamp | binary(14) | NO | MUL | NULL | || afh_pattern | blob | NO | | NULL | || afh_comments | blob | NO | | NULL | || afh_flags | tinyblob | NO | | NULL | || afh_public_comments | tinyblob | YES | | NULL | || afh_actions | blob | YES | | NULL | || afh_deleted | tinyint(1) | NO | | 0 | || afh_changed_fields | varbinary(255) | NO | | | || afh_group | varbinary(64) | YES | | NULL | |+---------------------+---------------------+------+-----+---------+----------------+
+----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| abuse_filter_history | 0 | PRIMARY | 1 | afh_id | A | 0 | NULL | NULL | | BTREE | | || abuse_filter_history | 1 | afh_filter | 1 | afh_filter | A | 0 | NULL | NULL | | BTREE | | || abuse_filter_history | 1 | afh_user | 1 | afh_user | A | 0 | NULL | NULL | | BTREE | | || abuse_filter_history | 1 | afh_user_text | 1 | afh_user_text | A | 0 | NULL | NULL | | BTREE | | || abuse_filter_history | 1 | afh_timestamp | 1 | afh_timestamp | A | 0 | NULL | NULL | | BTREE | | |+----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
