Jump to content

手册:actor表

From mediawiki.org
This page is a translated version of the page Manual:Actor table and the translation is 91% complete.
手册:索引 MediaWiki数据库布局 actor表
MediaWiki版本:
1.31

actor表是MediaWiki存储有关actors(创作者、操作者)信息的地方,于T167246拆分自如下表:revision, archive, image, oldimage, filearchive, recentchanges, logging

欄位

actor_id

主鍵,用來唯一性辨識操作者。

actor_user

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

actor_name

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

UseModWiki导入的匿名修订版本或者Phase II软件的早期实现下,该字段可能包含一个最后一组被遮盖的IP地址(即\d{1,3}\.\d{1,3}\.\d{1,3}\.xxx呈现为24.150.61.xxx;另见bug 3631)。 使用UseModWiki导入的部分编辑可能含有一个反向DNS查询主机名,如ppfree165-153-bz.aknet.it或者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    |                |
+------------+---------------------+------+-----+---------+----------------+

Indexes

MediaWiki版本:
1.31

SHOW INDEX IN actor;

+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| actor |          0 | PRIMARY    |            1 | actor_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| actor |          0 | actor_name |            1 | actor_name  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| actor |          0 | actor_user |            1 | actor_user  | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

参见