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>Special:MyLanguage/Manual:Page table#page_id|page_id (was cur_id>Special:MyLanguage/Manual:cur table#cur_id|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>Special:MyLanguage/Manual:Revision table#rev_id|rev_id of the given revision. See also rc_this_oldid>Special:MyLanguage/Manual:Recentchanges_table#rc_this_oldid|rc_this_oldid.

cuc_last_oldid
rev_id>Special:MyLanguage/Manual:Revision table#rev_id|rev_id of the prior revision, for generating diff links. See also rc_last_oldid>Special:MyLanguage/Manual:Recentchanges_table#rc_last_oldid|rc_last_oldid.

cuc_type
Edit/new/log. See rc_type>Special:MyLanguage/Manual:Recentchanges_table#rc_type|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     | 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           |                |