Extension:AbuseFilter/abuse_filter_action table

From mediawiki.org

Fields[edit]

afa_filter[edit]

ID of the filter.

afa_consequence[edit]

The name of the action. For instance:

blockautopromote

afa_parameters[edit]

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

Schema[edit]

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[edit]

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