Manual:actor table

From Linux Web Expert


Manual:Contents <translate> MediaWiki database layout</translate> <translate> <tvar name=1>actor</tvar> table</translate>
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.31
<translate> MediaWiki version:</translate>

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

Fields

actor_id

The primary key, used to uniquely identify an actor.

actor_user

A key to user.user_id of the user who made the action, or NULL for logged-out (IP) edits and for some mass imports.

actor_name

The text of the username or the IP address of the actor.

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.

Schema summary

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.31
Gerrit change 380669
<translate> MediaWiki version:</translate>

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

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.31
<translate> MediaWiki version:</translate>

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

See also