Erweiterung:AbuseFilter/abuse_filter-Tabelle
Felder
af_id
Primärschlüssel
af_pattern
Die Regeln des Filters.
af_user
Benutzer-ID des letzten Bearbeiters.
af_user_text
Benutzername des letzten Bearbeiters.
af_timestamp
Typischer MediaWiki-Zeitstempel der letzten Filterbearbeitung.
af_enabled
Ob der Filter aktiviert ist.
1
wenn ja, 0
andernfalls.
af_comments
Kommentare zum Filter (die unterhalb des Regel-Editors angezeigt werden).
af_public_comments
Der öffentliche Name des Filter.
af_hidden
Ob der Filter versteckt ist.
1
wenn ja, 0
andernfalls.
af_hit_count
Die Anzahl der durch diesen Filter registrierten Treffer.
af_throttled
Ob der Filter gedrosselt ist.
1
wenn ja, 0
andernfalls.
af_deleted
Ob der Filter gelöscht ist.
1
wenn ja, 0
andernfalls.
af_actions
Kommagetrennte Liste der für diesen Filter aktivierten Aktionen. Zum Beispiel:
disallow,tag
af_global
Ob der Filter global ist.
1
wenn ja, 0
andernfalls.
af_group
Die Gruppe, zu der der Filters gehört, wie in $wgAbuseFilterValidGroups
definiert.
Schema
mysql> describe abuse_filter; +--------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+----------------+ | af_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | af_pattern | blob | NO | | NULL | | | af_user | bigint(20) unsigned | NO | MUL | NULL | | | af_user_text | varbinary(255) | NO | | NULL | | | af_timestamp | binary(14) | NO | | NULL | | | af_enabled | tinyint(1) | NO | | 1 | | | af_comments | blob | YES | | NULL | | | af_public_comments | tinyblob | YES | | NULL | | | af_hidden | tinyint(1) | NO | | 0 | | | af_hit_count | bigint(20) | NO | | 0 | | | af_throttled | tinyint(1) | NO | | 0 | | | af_deleted | tinyint(1) | NO | | 0 | | | af_actions | varbinary(255) | NO | | | | | af_global | tinyint(1) | NO | | 0 | | | af_group | varbinary(64) | NO | MUL | default | | +--------------------+---------------------+------+-----+---------+----------------+
Indexe
+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | abuse_filter | 0 | PRIMARY | 1 | af_id | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter | 1 | af_user | 1 | af_user | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter | 1 | af_group_enabled | 1 | af_group | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter | 1 | af_group_enabled | 2 | af_enabled | A | 0 | NULL | NULL | | BTREE | | | | abuse_filter | 1 | af_group_enabled | 3 | af_id | A | 0 | NULL | NULL | | BTREE | | | +--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+