Erweiterung:CheckUser/cu_changes-Tabelle
Eine Tabelle für die CheckUser-Erweiterung. The IP and UA string used to make the action is also stored. Siehe auch cu_log_event.
Felder
cuc_id
Primärschlüssel
cuc_namespace
Similar to rc_namespace. When pages are renamed, this namespace does not change.
cuc_title
Similar to rc_title. When pages are renamed, this title does not change.
cuc_user
| MediaWiki Version: | ≤ 1.39 |
References a user_id in the user table.
Similar to rc_user.
cuc_user_text
| MediaWiki Version: | ≤ 1.39 |
References either a username with the ID stored in cuc_user in the user table or the text representation of the IP address when cuc_user is 0.
Similar to rc_user_text.
cuc_actor
| MediaWiki Version: | ≥ 1.38 |
Stores the actor_id for the user who performed the action that created this row. Similar to rc_actor.
cuc_actiontext
Stores the output of the text generated by using the database columns rc_params or log_params in language specified in the server configuation. Once set this does not change and is not translated for user-by-user.
cuc_comment
| MediaWiki Version: | ≤ 1.39 |
Similar to rc_comment.
cuc_comment_id
| MediaWiki Version: | ≥ 1.38 |
References a row in the comment table with the comment_id as the value stored in this column. Similar to rc_comment_id.
cuc_minor
Siehe rc_minor.
cuc_page_id
Schlüssel zu page_id (war $2 vor 1.5). Used to keep links working after moves while keeping the title and namespace of this change the same in the changes list. If not applicable (and also by default), the value of this column is 0.
cuc_this_oldid
rev_id of the given revision. Siehe auch rc_this_oldid.
cuc_last_oldid
rev_id of the prior revision, for generating diff links. Siehe auch rc_last_oldid.
cuc_type
An integer specifying the type of the event. Usually one of RC_EDIT (0) or RC_NEW (1). Before MediaWiki 1.43, RC_LOG (3) was also a common value. Siehe rc_type.
cuc_timestamp
Timestamp for the event that is stored in the cu_changes table, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss.
cuc_ip
IP-Adresse, sichtbar.
cuc_ip_hex
IP-Adresse als Hexadezimalzahl.
cuc_xff
The entire XFF header. If not provided or if all XFF IPs are varnish servers, this will be the empty string.
cuc_xff_hex
If all XFF IPs are not varnish servers, then this contains the best guess of the XFF IP in the XFF header as hexadecimal.
cuc_agent
User-Agent
cuc_agent_id
| MediaWiki Version: | ≥ 1.42 |
References a row in the cu_useragent table by the cuua_id column. The row in the table stores the user agent header provided in the request.
cuc_private
Private Daten
Must have a public key defined in the server configuration using $wgCUPublicKey.
Otherwise is left empty.
cuc_only_for_read_old
| MediaWiki Version: | ≥ 1.40 |
Temporary column used for migration of log entries to cu_log_event table and cu_private_event table.
Schema
| MediaWiki Version: | ≥ 1.42 |
DESCRIBE cu_changes;
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | cuc_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | cuc_namespace | int(11) | NO | | 0 | | | cuc_title | varbinary(255) | NO | | | | | cuc_actor | bigint(20) unsigned | NO | MUL | NULL | | | cuc_actiontext | varbinary(255) | NO | | | | | cuc_comment_id | bigint(20) unsigned | NO | | NULL | | | 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 | NULL | | | 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_agent_id | bigint(20) unsigned | NO | | 0 | | | cuc_private | mediumblob | YES | | NULL | | | cuc_only_for_read_old | tinyint(1) | NO | | 0 | | +-----------------------+---------------------+------+-----+---------+----------------+
| MediaWiki Versions: | 1.40 – 1.41 |
DESCRIBE cu_changes;
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | cuc_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | cuc_namespace | int(11) | NO | | 0 | | | cuc_title | varbinary(255) | NO | | | | | cuc_actor | bigint(20) unsigned | NO | MUL | 0 | | | cuc_actiontext | varbinary(255) | NO | | | | | cuc_comment_id | bigint(20) unsigned | NO | | 0 | | | 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 | NULL | | | 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 | | | cuc_only_for_read_old | tinyint(1) | NO | | 0 | | +-----------------------+---------------------+------+-----+---------+----------------+
