Extension:CheckUser/cu changes table
CheckUser uzantısı için bir tablo. The IP and UA string used to make the action is also stored. Ayrıca bakınız cu_log_event .
Alanlar
cuc_id
Birincil anahtar
cuc_namespace
Similar to rc_namespace . Sayfalar yeniden adlandırıldığında, RC girişleri DEĞİŞMEZ.
cuc_title
Similar to rc_title . Sayfalar yeniden adlandırıldığında, RC girişleri DEĞİŞMEZ.
cuc_user
MediaWiki sürümü: | ≤ 1.39 |
References a user_id in the user
table.
Similar to rc_user .
cuc_user_text
MediaWiki sürümü: | ≤ 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 sürümü: | ≥ 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 sürümü: | ≤ 1.39 |
Similar to rc_comment .
cuc_comment_id
MediaWiki sürümü: | ≥ 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
rc_minor sayfasına bakın.
cuc_page_id
page_id anahtarı (1.5'ten önce $2 idi). Bu, değişiklik listesinde o anki adı korurken bağlantıların hareketlerden sonra çalışmaya devam etmesini sağlayacaktır. If not applicable (and also by default), the value of this column is 0.
cuc_this_oldid
Verilen revizyonun rev_id . Ayrıca bakınız rc_this_oldid .
cuc_last_oldid
Farklı bağlantılar oluşturmak için önceki revizyonun rev_id . Ayrıca bakınız 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. rc_type sayfasına bakın.
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 adresi, görülebilir.
cuc_ip_hex
Onaltılık olarak IP adresi.
cuc_xff
XFF başlığı, görünür, tüm veriler 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
Kullanıcı aracısı
cuc_agent_id
MediaWiki sürümü: | ≥ 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
Özel veri
Must have a public key defined in the server configuration using $wgCUPublicKey
.
Otherwise is left empty.
cuc_only_for_read_old
MediaWiki sürümü: | ≥ 1.40 |
Temporary column used for migration of log entries to cu_log_event table and cu_private_event table.
Şema
MediaWiki sürümü: | ≥ 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 sürümleri: | 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 | | +-----------------------+---------------------+------+-----+---------+----------------+