扩展:防滥用过滤器/防滥用过滤器歷史表
Outdated translations are marked like this.
字段
afh_id
主关键字
afh_filter
過濾器ID。
afh_user
修改者的用戶ID。
afh_user_text
修改者的用戶名。
afh_timestamp
過濾器修改的典型MediaWiki時間戳 。
afh_pattern
該版本的過濾器規則。
afh_comments
該版本的過濾器說明。
afh_flags
該版本過濾器標誌的逗號分隔列表。 例如:
enabled,hidden
afh_public_comments
該版本的過濾器公開名稱。
afh_actions
一個序列化陣列,其中包含過濾器的動作及與其相關的參數。
afh_deleted
該版本的過濾器是否被刪除。
如果是則為1
,否則為0
。
afh_changed_fields
該版本的欄位修改的逗號分隔列表。 每個都可以是「actions」或abuse_filter表中下列欄位之一:
af_public_comments, af_pattern, af_comments, af_deleted, af_enabled, af_hidden, af_global, af_group
afh_group
該版本的過濾器群組,定義在$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 | | +---------------------+---------------------+------+-----+---------+----------------+
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 | | | +----------------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+