Extension:CheckUser/cu log event table/de

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

In 1.40 wird diese Tabelle nicht verwendet, jedoch wird sie zur Datenbank hinzugefügt. Zukünftige Versionen werden die Verwendung dieser Tabelle einführen.

cule_id
Primary key, used to uniquely identify a cu_log_event row.

cule_log_id
The associated with this cu_log_event row.

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

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

Schema
mysql> 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    |                |