手册:actor表

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Actor table and the translation is 70% complete.
Other languages:
English • ‎español • ‎français • ‎中文 • ‎日本語
手冊:索引 MediaWiki数据库布局 actor table


MediaWiki版本: 1.31

The actor table is where MediaWiki stores information about actors, factored out from the revision, archive, image, oldimage, filearchive, recentchanges, logging tables in T167246.

欄位

actor_id

主鍵,用來辨識不同的操作者。

actor_user

做出操作用戶的user.user_id的鍵,或NULL為未登入用戶(IP)的編輯或一些大量匯入。

actor_name

操作者的用戶名或IP位址的文字。

In anonymous revisions imported from UseModWiki or early incarnations of the Phase II software, this field may contain an IP address with the final octet obscured (i.e. \d{1,3}\.\d{1,3}\.\d{1,3}\.xxx such as 24.150.61.xxx; see bug 3631). Some edits imported from UseModWiki may contain a Reverse DNS lookup hostname like ppfree165-153-bz.aknet.it or office.bomis.com.

架构摘要

MediaWiki版本: 1.31
Gerrit change 380669

DESCRIBE actor;

+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| actor_id   | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| actor_user | int(10) unsigned    | YES  | UNI | NULL    |                |
| actor_name | varbinary(255)      | NO   | UNI | NULL    |                |
+------------+---------------------+------+-----+---------+----------------+

参见