Extension:CheckUser/cu changes table

A table for the extension. See also.

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_actiontext
(Document me)

cuc_minor
See .

cuc_page_id
Key to  (was  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
 of the given revision. See also .

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

cuc_type
Edit/new/log. See .

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           |                |