Erweiterung:CheckUser/cu_changes-Tabelle

From mediawiki.org
This page is a translated version of the page Extension:CheckUser/cu changes table and the translation is 62% complete.

Eine Tabelle für die CheckUser -Erweiterung. Siehe auch Extension:CheckUser/cu_log table .

Felder

cuc_id

Primärschlüssel

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_actor

actor_id

cuc_actiontext

(Document me)

cuc_comment

rc_comment

cuc_comment_id

comment_id

cuc_minor

Siehe rc_minor .

cuc_page_id

Schlüssel zu page_id (war cur_id vor 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. 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

Edit/new/log. Siehe rc_type .

cuc_timestamp

Event timestamp.

cuc_ip

IP-Adresse, sichtbar.

cuc_ip_hex

IP-Adresse als Hexadezimalzahl.

cuc_xff

XFF header, visible, all data

cuc_xff_hex

XFF header, last IP, as hexadecimal

cuc_agent

User-Agent

cuc_private

Private Daten

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