Extension:防滥用过滤器/防滥用过滤器日誌表
字段
afl_id
主关键字
afl_filter_global
觸發的過濾器是否為全域過濾器。
如果是全局過濾器，則為1，否則為0。
afl_filter_id
觸發過濾器的編號。
afl_user
做出此動作的用戶ID。
afl_user_text
做出此動作的用戶名。
afl_ip
| MediaWiki版本： | ≤ 1.45 |
觸發過濾器時用戶所使用的IP位址。
afl_ip_hex
| MediaWiki版本： | ≥ 1.45 |
The IP address user was using when the filter was triggered in hexadecimal form.
afl_action
觸發過濾器時所做的動作。
可以是下列的這些值：
edit, delete, createaccount, move, upload, autocreateaccount, stashupload
afl_actions
過濾器對動作進行了什麼操作，逗號分隔。例如：
disallow,tag
afl_var_dump
與編輯匹配的過濾器的變數值，以前用序列化PHP陣列儲存。
如果內容是後面有一個數字的stored-text:，那麼內容不會儲存在此，而是儲存在text表中，且該數字是該表的old_id標識符。
這是自MediaWiki 1.19起的預設設定。
如果外部儲存啟用，則內容在預設外部儲存中。
在MediaWiki 1.21之前，不是原生PHP陣列被序列化，而是一個AbuseFilterVariableHolder類別的實例。為了區分這一點，在新條目的text 表中添加nativeDataArray旗標。
Since 1.44, this may be a JSON array containing the values of protected variables which will expire.
例如：
stored-text:66019837
afl_timestamp
過濾後的MediaWiki行動時間戳記，因此也是關於該行動的濫用日誌條目時間戳。
afl_namespace
觸發動作的目標命名空間。
afl_title
觸發動作的目標標題。
afl_wiki
如果正在使用全域防濫用過濾器，則會在中央資料庫上填寫此欄位，並保留過濾器被觸發的Wiki ID。
跟wfWikiID同樣格式。
afl_deleted
濫用日誌項目是否被監督。
如果被监督削除則為1，否則為0。
afl_patrolled_by
| MediaWiki版本： | ≤ 1.43 |
未使用。
afl_rev_id
revision.rev_id的外鍵，僅為已保存的編輯填寫以顯示差異連結。
架構
| MediaWiki版本： | ≥ 1.45 |
mysql> describe abuse_filter_log; +---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | afl_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | afl_global | tinyint(1) | NO | MUL | NULL | | | afl_filter_id | bigint(20) unsigned | NO | | NULL | | | afl_user | bigint(20) unsigned | NO | MUL | NULL | | | afl_user_text | varbinary(255) | NO | | NULL | | | afl_ip_hex | varbinary(255) | NO | MUL | NULL | | | afl_action | varbinary(255) | NO | | NULL | | | afl_actions | varbinary(255) | NO | | NULL | | | afl_var_dump | blob | NO | MUL | NULL | | | afl_timestamp | binary(14) | NO | MUL | NULL | | | afl_namespace | int(11) | NO | MUL | NULL | | | afl_title | varbinary(255) | NO | | NULL | | | afl_wiki | varbinary(64) | YES | MUL | NULL | | | afl_deleted | tinyint(1) | NO | | 0 | | | afl_rev_id | int(10) unsigned | YES | MUL | NULL | | +---------------+---------------------+------+-----+---------+----------------+
| MediaWiki版本： | 1.44 |
mysql> describe abuse_filter_log; +---------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+----------------+ | afl_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | afl_global | tinyint(1) | NO | MUL | NULL | | | afl_filter_id | bigint(20) unsigned | NO | | NULL | | | afl_user | bigint(20) unsigned | NO | MUL | NULL | | | afl_user_text | varbinary(255) | NO | | NULL | | | afl_ip | varbinary(255) | NO | MUL | | | | afl_action | varbinary(255) | NO | | NULL | | | afl_actions | varbinary(255) | NO | | NULL | | | afl_var_dump | blob | NO | MUL | NULL | | | afl_timestamp | binary(14) | NO | MUL | NULL | | | afl_namespace | int(11) | NO | MUL | NULL | | | afl_title | varbinary(255) | NO | | NULL | | | afl_wiki | varbinary(64) | YES | MUL | NULL | | | afl_deleted | tinyint(1) | NO | | 0 | | | afl_rev_id | int(10) unsigned | YES | MUL | NULL | | +---------------+---------------------+------+-----+---------+----------------+
| MediaWiki版本： | ≤ 1.43 |
mysql> describe abuse_filter_log; +------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------+------+-----+---------+----------------+ | afl_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | afl_global | tinyint(1) | NO | MUL | NULL | | | afl_filter_id | bigint(20) unsigned | NO | | NULL | | | afl_user | bigint(20) unsigned | NO | MUL | NULL | | | afl_user_text | varbinary(255) | NO | | NULL | | | afl_ip | varbinary(255) | NO | MUL | NULL | | | afl_action | varbinary(255) | NO | | NULL | | | afl_actions | varbinary(255) | NO | | NULL | | | afl_var_dump | blob | NO | | NULL | | | afl_timestamp | binary(14) | NO | MUL | NULL | | | afl_namespace | int(11) | NO | MUL | NULL | | | afl_title | varbinary(255) | NO | | NULL | | | afl_wiki | varbinary(64) | YES | MUL | NULL | | | afl_deleted | tinyint(1) | NO | | 0 | | | afl_patrolled_by | int(10) unsigned | NO | | 0 | | | afl_rev_id | int(10) unsigned | YES | MUL | NULL | | +------------------+---------------------+------+-----+---------+----------------+
Indexes
| MediaWiki版本： | ≥ 1.45 |
show indexes from abuse_filter_log; +------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | abuse_filter_log | 0 | PRIMARY | 1 | afl_id | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_filter_timestamp_full | 1 | afl_global | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_filter_timestamp_full | 2 | afl_filter_id | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_filter_timestamp_full | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_user_timestamp | 1 | afl_user | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_user_timestamp | 2 | afl_user_text | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_user_timestamp | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_timestamp | 1 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_page_timestamp | 1 | afl_namespace | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_page_timestamp | 2 | afl_title | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_page_timestamp | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_rev_id | 1 | afl_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | NO | | abuse_filter_log | 1 | afl_wiki_timestamp | 1 | afl_wiki | A | 0 | NULL | NULL | YES | BTREE | | | NO | | abuse_filter_log | 1 | afl_wiki_timestamp | 2 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_var_dump_timestamp | 1 | afl_var_dump | A | 0 | 4 | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_var_dump_timestamp | 2 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_ip_hex_timestamp | 1 | afl_ip_hex | A | 0 | NULL | NULL | | BTREE | | | NO | | abuse_filter_log | 1 | afl_ip_hex_timestamp | 2 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO | +------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
