Extension:CheckUser/cu_log table
The cu_log
table records each time someone uses the CheckUser tool.
Fields
editcul_id
editThe primary key, used to uniquely identify a checkuser log entry
cul_timestamp
editThe time the check was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss. Comparable to rc_timestamp .
cul_user
editMediaWiki version: | ≤ 1.39 |
The id of the checkuser who performed the check. This is a reference into the user table. Comparable to rc_user .
cul_user_text
editMediaWiki version: | ≤ 1.39 |
user_name of the user who performed the check. Comparable to rc_user_text .
cul_actor
editMediaWiki 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
editMediaWiki version: | ≤ 1.39 |
The reason given for the check. Comparable to rc_comment and rev_comment .
cul_reason_id
editMediaWiki 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
editMediaWiki 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
editcul_type | message |
---|---|
ipedits | $3, user got actions performed by target |
ipedits-xff | $3, user got actions performed by XFF target |
ipusers | $3, user got users for target |
ipusers-xff | $3, user got users for XFF target |
useredits | $3, user got actions performed by target |
userips | $3, user got IP addresses for target |
cul_target_id
editThe id of the user who was checked. 0 for checks on IP addresses or ranges. This is a reference into the user table. Comparable to rc_user .
cul_target_text
edituser_name of the user who was checked. Comparable to rc_user_text .
cul_target_hex
editIf the target was an IP address, this contains the hexadecimal form of the IP.
cul_range_start
editIf the target was an IP range, this field contain the start, in hexadecimal form.
cul_range_end
editIf the target was an IP range, this field contain the end, in hexadecimal form.
Schema summary
editDESCRIBE 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 | | | | +-------------------------+---------------------+------+-----+---------+----------------+