Jump to content

Extension:AbuseFilter/abuse filter action table

From mediawiki.org

Fields

afa_filter

ID of the filter.

afa_consequence

The name of the action. For instance:

blockautopromote

afa_parameters

Parameters of the action, imploded with "\n".

Schema

mysql> describe abuse_filter_action;
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| afa_filter      | bigint(20) unsigned | NO   | PRI | NULL    |       |
| afa_consequence | varbinary(255)      | NO   | PRI | NULL    |       |
| afa_parameters  | tinyblob            | NO   |     | NULL    |       |
+-----------------+---------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

Indexes

+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table               | Non_unique | Key_name        | Seq_in_index | Column_name     | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| abuse_filter_action |          0 | PRIMARY         |            1 | afa_filter      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| abuse_filter_action |          0 | PRIMARY         |            2 | afa_consequence | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| abuse_filter_action |          1 | afa_consequence |            1 | afa_consequence | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+