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