Extension:CheckUser/cu_log table
- Deutsch
- English
- Tiếng Việt
- Zazaki
- 日本語
The cu_log table records each time someone uses the CheckUser tool.
Fields
[edit ]cul_id
[edit ]The primary key, used to uniquely identify a checkuser log entry
cul_timestamp
[edit ]The time the check was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss. Comparable to rc_timestamp .
cul_user
[edit ]The id of the checkuser who performed the check. This is a reference into the user table. Comparable to rc_user .
cul_user_text
[edit ]user_name of the user who performed the check. Comparable to rc_user_text .
cul_actor
[edit ]This is a foreign key to actor_id in the actor table, corresponding to the checkuser who performed the check.
cul_reason
[edit ]The reason given for the check. Comparable to rc_comment and rev_comment .
cul_reason_id
[edit ]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
[edit ]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
[edit ]| cul_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
[edit ]The 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
[edit ]user_name of the user who was checked. Comparable to rc_user_text .
cul_target_hex
[edit ]If the target was an IP address, this contains the hexadecimal form of the IP.
cul_range_start
[edit ]If the target was an IP range, this field contain the start, in hexadecimal form.
cul_range_end
[edit ]If the target was an IP range, this field contain the end, in hexadecimal form.
Schema summary
[edit ]DESCRIBEcu_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 | | | | +-------------------------+---------------------+------+-----+---------+----------------+