Erweiterung:CheckUser/cu_log-Ereignistabelle

MediaWiki Version:

≥ 1.40

A table for the CheckUser extension used to store log entries with log ID from the recentchanges table and other selected events with the IP and UA string used to make the action. Siehe auch cu_changes und cu_private_event .

In 1.40 wird diese Tabelle nicht verwendet, jedoch wird sie zur Datenbank hinzugefügt. Since 1.41, this table is used.

Felder

cule_id

Primary key, used to uniquely identify a cu_log_event row.

cule_log_id

The logging.log_id associated with this cu_log_event row.

cule_actor

Stores the actor_id for the user who performed the action that created this row. Ähnlich wie rc_user .

cule_timestamp

Timestamp for the event that is stored in the cu_log_event table, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss.

cule_ip

The IP address used to make the edit.

cule_ip_hex

The IP address in cuc_ip as hexadecimal.

cule_xff

Der Ganze XFF-Header. If not provided or if all XFF IPs are varnish servers, this will be the empty string.

cule_xff_hex

If all XFF IPs are not varnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.

cule_agent

The User agent header provided in the request that made the action being stored in this row.

cule_agent_id

MediaWiki Version:

≥ 1.42

References a row in the cu_useragent table by the cuua_id column. The row in the table stores the user agent header provided in the request.

Schema

MediaWiki Version:

≥ 1.42

DESCRIBE cu_log_event;

+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| cule_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| cule_log_id    | int(10) unsigned    | NO   |     | 0       |                |
| cule_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| cule_timestamp | binary(14)          | NO   | MUL | NULL    |                |
| cule_ip        | varbinary(255)      | YES  |     |         |                |
| cule_ip_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_xff       | varbinary(255)      | YES  |     |         |                |
| cule_xff_hex   | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_agent     | varbinary(255)      | YES  |     | NULL    |                |
| cule_agent_id  | bigint(20) unsigned | NO   |     | 0       |                |
+----------------+---------------------+------+-----+---------+----------------+

MediaWiki Versions:

1.40 – 1.41

DESCRIBE cu_log_event;

+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| cule_id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| cule_log_id    | int(10) unsigned    | NO   |     | 0       |                |
| cule_actor     | bigint(20) unsigned | NO   | MUL | NULL    |                |
| cule_timestamp | binary(14)          | NO   | MUL | NULL    |                |
| cule_ip        | varbinary(255)      | YES  |     |         |                |
| cule_ip_hex    | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_xff       | varbinary(255)      | YES  |     |         |                |
| cule_xff_hex   | varbinary(255)      | YES  | MUL | NULL    |                |
| cule_agent     | varbinary(255)      | YES  |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+