Extension:AbuseFilter/abuse_filter_log table
Fields
editafl_id
editPrimary key
afl_filter_global
editWhether the filter triggered is a global filter.
1
if it's a global filter, 0
otherwise.
afl_filter_id
editNumber of the filter triggered.
afl_user
editUser ID of the author of the action.
afl_user_text
editUser name of the author of the action.
afl_ip
editThe IP address user was using when the filter was triggered.
afl_action
editThe action which triggered the filter.
Values can include the following values:
edit
, delete
, createaccount
, move
, upload
, autocreateaccount
, stashupload
afl_actions
editWhat the filter made about the action, comma-imploded. Example:
disallow,tag
afl_var_dump
editValue of the variables of the filter that matched the edit, previously stored as a serialized PHP array.
If the content is stored-text:
followed by a number, then the content is not stored here but in the text
table, and the number is the old_id
identifier of that table.
This is the default since MediaWiki 1.19.
If external storage is enabled, content will be in the default external store.
Prior to MediaWiki 1.21, instead of a native PHP array, an instance of AbuseFilterVariableHolder class was being serialized. To differentiate this, the nativeDataArray
flag is added to the text
table on new entries.
Example:
stored-text:66019837
afl_timestamp
editTypical MediaWiki timestamp of the action filtered and hence of the abuse log entry about it.
afl_namespace
editTarget Namespace of the filtered action.
afl_title
editTarget title of the filter action.
afl_wiki
editIf global abuse filters are in use, this field is populated on the central DB and holds the ID of the wiki where the filter was triggered.
Same format as wfWikiID
.
afl_deleted
editWhether the AbuseLog entry was suppressed.
1
if suppressed, 0
otherwise.
afl_patrolled_by
editUnused.
afl_rev_id
editForeign key to revision.rev_id
, only populated for saved edits in order to show a diff link.
Schema
editmysql> 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 | | +------------------+---------------------+------+-----+---------+----------------+
Example
editMariaDB> SELECT afl_id, afl_filter, afl_user, afl_user_text, afl_ip, afl_action, afl_actions, afl_var_dump, afl_timestamp, afl_namespace, afl_title, afl_wiki, afl_deleted, afl_patrolled_by, afl_rev_id FROM abuse_filter_log ORDER BY afl_id DESC LIMIT 1; +--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+ | afl_id | afl_filter | afl_user | afl_user_text | afl_ip | afl_action | afl_actions | afl_var_dump | afl_timestamp | afl_namespace | afl_title | afl_wiki | afl_deleted | afl_patrolled_by | afl_rev_id | +--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+ | 358580 | 9 | 0 | 151.54.106.177 | NULL | edit | tag | stored-text:66020782 | 20140601174723 | 0 | 24:61 | NULL | 0 | 0 | NULL | +--------+------------+----------+----------------+--------+------------+-------------+----------------------+----------------+---------------+-----------+----------+-------------+------------------+------------+ 1 row in set (0.01 sec)
Indexes
edit+------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | abuse_filter_log | 0 | PRIMARY | 1 | afl_id | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_filter_timestamp_full | 1 | afl_global | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_filter_timestamp_full | 2 | afl_filter_id | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_filter_timestamp_full | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_user_timestamp | 1 | afl_user | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_user_timestamp | 2 | afl_user_text | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_user_timestamp | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_timestamp | 1 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_page_timestamp | 1 | afl_namespace | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_page_timestamp | 2 | afl_title | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_page_timestamp | 3 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_ip_timestamp | 1 | afl_ip | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_ip_timestamp | 2 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter_log | 1 | afl_rev_id | 1 | afl_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | | abuse_filter_log | 1 | afl_wiki_timestamp | 1 | afl_wiki | A | 0 | NULL | NULL | YES | BTREE | | | | abuse_filter_log | 1 | afl_wiki_timestamp | 2 | afl_timestamp | A | 0 | NULL | NULL | | BTREE | | | +------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+