Extension:CheckUser/cu log event table

MediaWiki sürümü:

≥ 1.40

recentchanges tablosundan gelen günlük kimliği ve eylemi yapmak için kullanılan IP ve UA dizesiyle diğer seçili olaylarla günlük girişlerini depolamak için kullanılan CheckUser uzantısı için bir tablo. Ayrıca cu_changes ve cu_private_event 'ye bakın.

1.40, bu tablo kullanılmamıştır ama veritabanına eklenir. 1.41 sürümünden itibaren bu tablo kullanılmaktadır.

Alanlar

cule_id

cu_log_event satırını benzersiz şekilde tanımlamak için kullanılan birincil anahtar.

cule_log_id

Bu cu_log_event satırına ilişkin logging.log_id.

cule_actor

Stores the actor_id for the user who performed the action that created this row. Similar to 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

The entire 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 sürümü:

≥ 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 sürümü:

≥ 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 sürümleri:

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