Extension:AbuseFilter/abuse filter log table

afl_id
Primary key

afl_filter
Number of the filter triggered.

afl_user
User ID of the author of the action.

afl_user_text
?

afl_ip
?

afl_action
The action which triggered the filter.

afl_actions
What the filter made about the action. Example: disallow,tag

afl_var_dump
Example: stored-text:66019837

afl_timestamp
Typical MediaWiki timestamp of the action filtered and hence of the abuse log entry about it.

afl_namespace
Namespace of the filtered action.

afl_title
Target of the filter action.

afl_wiki
?

afl_deleted
?

afl_patrolled_by
?

afl_rev_id
?

afl_log_id
?

Schema
MariaDB [itwiki_p]> describe abuse_filter_log; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+ 16 rows in set (0.00 sec)
 * Field           | Type                | Null | Key | Default | Extra |
 * afl_id          | bigint(20) unsigned | NO   |     | 0       |       |
 * afl_filter      | varbinary(64)       | NO   |     |         |       |
 * afl_user        | bigint(20) unsigned | NO   |     | 0       |       |
 * afl_user_text   | varbinary(255)      | NO   |     |         |       |
 * afl_ip          | binary(0)           | YES  |     | NULL    |       |
 * afl_action      | varbinary(255)      | NO   |     |         |       |
 * afl_actions     | varbinary(255)      | NO   |     |         |       |
 * afl_var_dump    | blob                | NO   |     | NULL    |       |
 * afl_timestamp   | varbinary(14)       | NO   |     |         |       |
 * afl_namespace   | int(11)             | NO   |     | NULL    |       |
 * afl_title       | varbinary(255)      | NO   |     |         |       |
 * afl_wiki        | varbinary(64)       | YES  |     | NULL    |       |
 * afl_deleted     | tinyint(1)          | NO   |     | 0       |       |
 * afl_patrolled_by | int(10) unsigned   | NO   |     | 0       |       |
 * afl_rev_id      | int(10) unsigned    | YES  |     | NULL    |       |
 * afl_log_id      | int(10) unsigned    | YES  |     | NULL    |       |

Example
MariaDB> 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, afl_log_id FROM abuse_filter_log ORDER BY afl_id DESC LIMIT 1; +++--++++-+--++---+---+--+-+--+++ +++--++++-+--++---+---+--+-+--+++ +++--++++-+--++---+---+--+-+--+++ 1 row in set (0.01 sec)
 * 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 | afl_log_id |
 * 358580 | 9         |        0 | 151.54.106.177 |   NULL | edit       | tag         | stored-text:66020782 | 20140601174723 |             0 | 24:61     | NULL     |           0 |                0 |       NULL |       NULL |