Extension:AbuseFilter/abuse filter log table/ja

afl_id
主キー

afl_filter
発動したフィルターの件数です.

afl_user
操作の作者の利用者 ID です.

afl_user_text
User name of the author of the action.

afl_ip
The IP address user was using when the filter was triggered.

afl_action
フィルターを発動させた操作です. Values can include the following values: ,,  ,  ,  ,  ,

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

afl_var_dump
例: 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
?

スキーマ
mysql> describe abuse_filter_log; +--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++ 16 rows in set (0.00 sec)
 * Field           | Type                | Null | Key | Default | Extra          |
 * afl_id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
 * afl_filter      | varbinary(64)       | NO   | MUL | 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   | tinyint(4)          | 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   | YES  |     | NULL    |                |
 * afl_rev_id      | int(10) unsigned    | YES  | MUL | NULL    |                |
 * afl_log_id      | int(10) unsigned    | YES  | MUL | NULL    |                |

例
 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 |