Extension:CheckUser/cu changes table
A table for the CheckUser extension. See also Extension:CheckUser/cu_log table.
FieldsEdit
cuc_idEdit
Primary key
cuc_namespaceEdit
When pages are renamed, their RC entries do NOT change.
cuc_titleEdit
When pages are renamed, their RC entries do NOT change.
cuc_userEdit
cuc_user_textEdit
cuc_actiontextEdit
(Document me)
cuc_commentEdit
cuc_minorEdit
See rc_minor .
cuc_page_idEdit
Key to page_id (was cur_id prior to 1.5). This will keep links working after moves while retaining the at-the-time name in the changes list.
cuc_this_oldidEdit
rev_id of the given revision. See also rc_this_oldid .
cuc_last_oldidEdit
rev_id of the prior revision, for generating diff links. See also rc_last_oldid .
cuc_typeEdit
Edit/new/log. See rc_type .
cuc_timestampEdit
Event timestamp.
cuc_ipEdit
IP address, visible.
cuc_ip_hexEdit
IP address as hexadecimal.
cuc_xffEdit
XFF header, visible, all data
cuc_xff_hexEdit
XFF header, last IP, as hexadecimal
cuc_agentEdit
User agent
cuc_privateEdit
Private data
SchemaEdit
mysql> describe cu_changes; +----------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+----------------+----------------+ | cuc_id | int(11) | NO | PRI | NULL | auto_increment | | cuc_namespace | int(11) | NO | | 0 | | | cuc_title | varbinary(255) | NO | | | | | cuc_user | int(11) | NO | MUL | 0 | | | cuc_user_text | varbinary(255) | NO | | | | | cuc_actiontext | varbinary(255) | NO | | | | | cuc_comment | varbinary(255) | NO | | | | | cuc_minor | tinyint(1) | NO | | 0 | | | cuc_page_id | int(10) unsigned | NO | | 0 | | | cuc_this_oldid | int(10) unsigned | NO | | 0 | | | cuc_last_oldid | int(10) unsigned | NO | | 0 | | | cuc_type | tinyint(3) unsigned | NO | | 0 | | | cuc_timestamp | binary(14) | NO | MUL | | | | cuc_ip | varbinary(255) | YES | | | | | cuc_ip_hex | varbinary(255) | YES | MUL | NULL | | | cuc_xff | varbinary(255) | YES | | | | | cuc_xff_hex | varbinary(255) | YES | MUL | NULL | | | cuc_agent | varbinary(255) | YES | | NULL | | | cuc_private | mediumblob | YES | | NULL | | +----------------+---------------------+------+-----+----------------+----------------+