Extension:CheckUser/cu changes table

A table for the CheckUser extension. See also Extension:CheckUser/cu_log table.

cuc_id
Primary key

cuc_namespace
When pages are renamed, their RC entries do _not_ change.

cuc_title
When pages are renamed, their RC entries do _not_ change.

cuc_user
user_id

cuc_user_text
user_text

cuc_actiontext
(Document me)

cuc_comment
rc_comment.

cuc_minor
See rc_minor.

cuc_page_id
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_oldid
rev_id of the given revision. See also rc_this_oldid.

cuc_last_oldid
rev_id of the prior revision, for generating diff links. See also rc_last_oldid.

cuc_type
Edit/new/log. See rc_type.

cuc_timestamp
Event timestamp.

cuc_ip
IP address, visible.

cuc_ip_hex
IP address as hexadecimal.

cuc_xff
XFF header, visible, all data

cuc_xff_hex
XFF header, last IP, as hexadecimal

cuc_agent
User agent

cuc_private
Private data

Schema
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     | varchar(255)        | NO   |     |         |                |
 * cuc_user      | int(11)             | NO   | MUL | 0       |                |
 * cuc_user_text | varchar(255)        | NO   |     |         |                |
 * cuc_actiontext | varchar(255)       | NO   |     |         |                |
 * cuc_comment   | varchar(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 | char(14)            | NO   | MUL |         |                |
 * cuc_ip        | varchar(255)        | YES  |     |         |                |
 * cuc_ip_hex    | varchar(255)        | YES  | MUL | NULL    |                |
 * cuc_xff       | varchar(255)        | YES  |     |         |                |
 * cuc_xff_hex   | varchar(255)        | YES  | MUL | NULL    |                |
 * cuc_agent     | varchar(255)        | YES  |     | NULL    |                |