Jump to content

Erweiterung:CheckUser/cu_log-Tabelle

From mediawiki.org
This page is a translated version of the page Extension:CheckUser/cu log table and the translation is 49% complete.


The cu_log table records each time someone uses the CheckUser tool.

Felder

cul_id

The primary key, used to uniquely identify a checkuser log entry

cul_timestamp

The time the check was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss. Vergleichbar zu rc_timestamp .

cul_user

MediaWiki Version:
1.39

The id of the checkuser who performed the check. This is a reference into the user table. Vergleichbar zu rc_user .

cul_user_text

MediaWiki Version:
1.39

user_name of the user who performed the check. Vergleichbar zu rc_user_text .

cul_actor

MediaWiki Version:
1.39

This is a foreign key to actor_id in the actor table, corresponding to the checkuser who performed the check.

cul_reason

MediaWiki Version:
1.39

The reason given for the check. Vergleichbar zu rc_comment und rev_comment .

cul_reason_id

MediaWiki Version:
1.39

In future versions will store the ID to a comment table row that has the reason for the check. This is a foreign key to comment_id in the comment table.

cul_reason_plaintext_id

MediaWiki Version:
1.39

In future versions will store the ID to a comment table row that has the reason for the check but converted to plaintext. This is a foreign key to comment_id in the comment table.

cul_type

cul_type message
ipedits $3, Benutzer rief von Ziel ausgeführte Aktionen ab
ipedits-xff $3, Benutzer rief von XFF Ziel ausgeführte Aktionen ab
ipusers Benutzer rief am $3 die Benutzer für Ziel ab
ipusers-xff Benutzer rief am $3 die Benutzer für XFF Ziel ab
useredits $3, Benutzer rief von Ziel ausgeführte Aktionen ab
userips Benutzer rief am $3 die IP-Adressen für Ziel ab

cul_target_id

The id of the user who was checked. 0 for checks on IP addresses or ranges. This is a reference into the user table. Vergleichbar zu rc_user .

cul_target_text

user_name of the user who was checked. Vergleichbar zu rc_user_text .

cul_target_hex

If the target was an IP address, this contains the hexadecimal form of the IP.

cul_range_start

If the target was an IP range, this field contain the start, in hexadecimal form.

cul_range_end

If the target was an IP range, this field contain the end, in hexadecimal form.

Schema summary

DESCRIBE cu_log;

+-------------------------+---------------------+------+-----+---------+----------------+
| Field                   | Type                | Null | Key | Default | Extra          |
+-------------------------+---------------------+------+-----+---------+----------------+
| cul_id                  | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| cul_timestamp           | binary(14)          | NO   | MUL | NULL    |                |
| cul_user                | int(10) unsigned    | NO   | MUL | NULL    |                |
| cul_user_text           | varbinary(255)      | NO   |     | NULL    |                |
| cul_actor               | bigint(20) unsigned | NO   | MUL | 0       |                |
| cul_reason              | varbinary(255)      | NO   |     | NULL    |                |
| cul_reason_id           | bigint(20) unsigned | NO   |     | 0       |                |
| cul_reason_plaintext_id | bigint(20) unsigned | NO   |     | 0       |                |
| cul_type                | varbinary(30)       | NO   | MUL | NULL    |                |
| cul_target_id           | int(10) unsigned    | NO   |     | 0       |                |
| cul_target_text         | blob                | NO   |     | NULL    |                |
| cul_target_hex          | varbinary(255)      | NO   | MUL |         |                |
| cul_range_start         | varbinary(255)      | NO   | MUL |         |                |
| cul_range_end           | varbinary(255)      | NO   |     |         |                |
+-------------------------+---------------------+------+-----+---------+----------------+