Extension:AbuseFilter/abuse filter history table/zh

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
該版本的過濾器是否被刪除. 如果是則為 ，否則為.

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
該版本的過濾器群組，定義在.

架構
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      |         |               |