Extension:AbuseFilter/abuse filter history table/da
Felter
afh_id
Primary key
afh_filter
ID of the filter.
afh_user
User ID of the modifier.
afh_user_text
User name of the modifier.
afh_timestamp
Typical MediaWiki timestamp of the filter edit.
afh_pattern
The rules of this version of the filter.
afh_comments
The notes of this version of the filter.
afh_flags
A comma-imploded list of flags of this version of the filter. Eksempel:
enabled,hidden
afh_public_comments
The public name of this version of the filter.
afh_actions
A serialized array with the actions and their parameters relative to this action of the filter.
afh_deleted
Whether this version of the filter is deleted.
1 if it is, 0 otherwise.
afh_changed_fields
A comma-imploded list of fields changed in this version.
Each one can be either "actions" or one of the following columns from the abuse_filter table:
af_public_comments, af_pattern, af_comments, af_deleted, af_enabled, af_hidden, af_global, af_group
afh_group
The group this version of the filter belongs to, as defined in $wgAbuseFilterValidGroups.
Schema
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 | | +---------------------+---------------------+------+-----+---------+----------------+
Indexes
+----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+