Extension:CheckUser/cu changes table/fr

Table pour l'extension. Voir aussi.

cuc_id
Clé primaire

cuc_namespace
Similar to. Lorsque les pages sont renommées, leur entrées RC ne changent pas.

cuc_title
Similar to. Lorsque les pages sont renommées, leur entrées RC ne changent pas.

cuc_user
References a in the user table. Similar to.

cuc_user_text
References either a username with the ID stored in cuc_user in the table or the text representation of the IP address when cuc_user is 0. Similar to.

cuc_actor
Stores the for the user who performed the action that created this row. Similar to.

cuc_actiontext
Stores the output of the text generated by using the database columns or  in language specified in the server configuation. Once set this does not change and is not translated for user-by-user.

cuc_comment
Similar to and.

cuc_comment_id
References a row in the with the  as the value stored in this column. Similar to and.

cuc_minor
Voir.

cuc_page_id
Clé de (s'appelait $2 avant la version 1.5). Ceci permet de garder les liens actifs après avoir renommé en gardant l'ancien nom dans la liste des modifications. If not applicable (and also by default), the value of this column is 0.

cuc_this_oldid
de la révision donnée. Voir aussi.

cuc_last_oldid
de la révision précédente, pour générer les liens des diff. Voir aussi.

cuc_type
One of RC_EDIT (0), RC_NEW (1) or RC_LOG (3). Voir.

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
Adresse IP, visible.

cuc_ip_hex
Adresse IP en format hexadecimal.

cuc_xff
Entête XFF, visible, toutes les données 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
Agent utilisateur

cuc_private
Données privées. Must have a public key defined in the server configuration using. Otherwise is left empty.

Schéma
mysql> 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_user      | int(11)             | NO   | MUL | 0       |                |
 * cuc_user_text | varbinary(255)      | NO   |     |         |                |
 * cuc_actor     | bigint(20) unsigned | NO   | MUL | 0       |                |
 * cuc_actiontext | varbinary(255)     | NO   |     |         |                |
 * cuc_comment   | 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    |                |