扩展:防滥用过滤器/防滥用过滤器動作表

字段

afa_filter

過濾器ID。

afa_consequence

動作的名稱。 例如：

blockautopromote

afa_parameters

動作的參數，以"\n"為分隔。

架構

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)

索引

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