Jump to content

Erweiterung:AbuseFilter/abuse_filter_log-Tabelle

From mediawiki.org
This page is a translated version of the page Extension:AbuseFilter/abuse filter log table and the translation is 97% complete.
Languages:

Felder

afl_id

Primärschlüssel

afl_filter_global

Ob der ausgelöste Filter ein globaler Filter ist. 1, wenn es ein globales Filter ist, sonst 0.

afl_filter_id

Nummer des ausgelösten Filters.

afl_user

Benutzer-ID des Autors der Aktion.

afl_user_text

Benutzername des Autors der Aktion.

afl_ip

MediaWiki Version:
≤ 1.45

Die IP-Adresse, die der Benutzer verwendet hat, als der Filter ausgelöst wurde.

afl_ip_hex

MediaWiki Version:
≥ 1.45

The IP address user was using when the filter was triggered in hexadecimal form.

afl_action

Die Aktion, die den Filter ausgelöst hat. Folgende Werte sind möglich: edit, delete, createaccount, move, upload, autocreateaccount, stashupload

afl_actions

Was der Filter mit der Aktion gemacht hat, kommagetrennt. Beispiel: 

disallow,tag

afl_var_dump

Wert der Variablen des Filters, die mit der Bearbeitung übereingestimmt haben, zuvor als serialisiertes PHP-Array gespeichert. Wenn der Inhalt stored-text: gefolgt von einer Zahl ist, dann wird der Inhalt nicht hier, sondern in der Tabelle text gespeichert und die Zahl ist die Kennung old_id dieser Tabelle. Dies ist der Standard seit MediaWiki 1.19. Wenn externe Speicherung aktiviert ist, befindet sich der Inhalt im externen Standardspeicher. Vor MediaWiki 1.21 wurde anstelle eines nativen PHP-Arrays eine Instanz der Klasse AbuseFilterVariableHolder serialisiert. Um dies zu unterscheiden, wird bei neuen Einträgen die Markierung nativeDataArray zur Tabelle text hinzugefügt. Since 1.44, this may be a JSON array containing the values of protected variables which will expire.

Beispiel: 

stored-text:66019837

afl_timestamp

Typischer MediaWiki-Zeitstempel der gefilterten Aktion und damit des zugehörigen Eintrags im Missbrauchsfilter-Logbuch.

afl_namespace

Ziel-Namensraum der gefilterten Aktion.

afl_title

Zieltitel der gefilterten Aktion.

afl_wiki

Wenn globale Missbrauchsfilter verwendet werden, wird dieses Feld in der zentralen Datenbank ausgefüllt und enthält die ID des Wikis, in dem der Filter ausgelöst wurde. Gleiches Format wie wfWikiID.

afl_deleted

Ob der Eintrag im Missbrauchsfilter-Logbuch unterdrückt wurde. 1 wenn unterdrückt, sonst 0.

afl_patrolled_by

MediaWiki Version:
≤ 1.43

Nicht genutzt.

afl_rev_id

Fremdschlüssel zu revision.rev_id, wird nur für gespeicherte Bearbeitungen ausgefüllt, um einen Diff-Link anzuzeigen.

Schema

MediaWiki Version:
≥ 1.45
 
mysql> describe abuse_filter_log;
+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| afl_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| afl_global    | tinyint(1)          | NO   | MUL | NULL    |                |
| afl_filter_id | bigint(20) unsigned | NO   |     | NULL    |                |
| afl_user      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| afl_user_text | varbinary(255)      | NO   |     | NULL    |                |
| afl_ip_hex    | varbinary(255)      | NO   | MUL | NULL    |                |
| afl_action    | varbinary(255)      | NO   |     | NULL    |                |
| afl_actions   | varbinary(255)      | NO   |     | NULL    |                |
| afl_var_dump  | blob                | NO   | MUL | NULL    |                |
| afl_timestamp | binary(14)          | NO   | MUL | NULL    |                |
| afl_namespace | int(11)             | NO   | MUL | NULL    |                |
| afl_title     | varbinary(255)      | NO   |     | NULL    |                |
| afl_wiki      | varbinary(64)       | YES  | MUL | NULL    |                |
| afl_deleted   | tinyint(1)          | NO   |     | 0       |                |
| afl_rev_id    | int(10) unsigned    | YES  | MUL | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
MediaWiki Version:
1.44
 
mysql> describe abuse_filter_log;
+---------------+---------------------+------+-----+---------+----------------+
| Field         | Type                | Null | Key | Default | Extra          |
+---------------+---------------------+------+-----+---------+----------------+
| afl_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| afl_global    | tinyint(1)          | NO   | MUL | NULL    |                |
| afl_filter_id | bigint(20) unsigned | NO   |     | NULL    |                |
| afl_user      | bigint(20) unsigned | NO   | MUL | NULL    |                |
| afl_user_text | varbinary(255)      | NO   |     | NULL    |                |
| afl_ip        | varbinary(255)      | NO   | MUL |         |                |
| afl_action    | varbinary(255)      | NO   |     | NULL    |                |
| afl_actions   | varbinary(255)      | NO   |     | NULL    |                |
| afl_var_dump  | blob                | NO   | MUL | NULL    |                |
| afl_timestamp | binary(14)          | NO   | MUL | NULL    |                |
| afl_namespace | int(11)             | NO   | MUL | NULL    |                |
| afl_title     | varbinary(255)      | NO   |     | NULL    |                |
| afl_wiki      | varbinary(64)       | YES  | MUL | NULL    |                |
| afl_deleted   | tinyint(1)          | NO   |     | 0       |                |
| afl_rev_id    | int(10) unsigned    | YES  | MUL | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+


MediaWiki Version:
≤ 1.43
 
mysql> describe abuse_filter_log;
+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| afl_id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| afl_global       | tinyint(1)          | NO   | MUL | NULL    |                |
| afl_filter_id    | bigint(20) unsigned | NO   |     | 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    | int(11)             | 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    | NO   |     | 0       |                |
| afl_rev_id       | int(10) unsigned    | YES  | MUL | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+

Indexe

MediaWiki Version:
≥ 1.45
 
show indexes from abuse_filter_log;
+------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table            | Non_unique | Key_name                  | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| abuse_filter_log |          0 | PRIMARY                   |            1 | afl_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_filter_timestamp_full |            1 | afl_global    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_filter_timestamp_full |            2 | afl_filter_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_filter_timestamp_full |            3 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_user_timestamp        |            1 | afl_user      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_user_timestamp        |            2 | afl_user_text | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_user_timestamp        |            3 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_timestamp             |            1 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_page_timestamp        |            1 | afl_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_page_timestamp        |            2 | afl_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_page_timestamp        |            3 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_rev_id                |            1 | afl_rev_id    | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_wiki_timestamp        |            1 | afl_wiki      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_wiki_timestamp        |            2 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_var_dump_timestamp    |            1 | afl_var_dump  | A         |           0 |        4 | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_var_dump_timestamp    |            2 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_ip_hex_timestamp      |            1 | afl_ip_hex    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| abuse_filter_log |          1 | afl_ip_hex_timestamp      |            2 | afl_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+------------------+------------+---------------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
Retrieved from "https://www.mediawiki.org/w/index.php?title=Extension:AbuseFilter/abuse_filter_log_table/de&oldid=7958898"