Manual:actor table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎dansk • ‎español • ‎日本語
Manual:Contents MediaWiki database layout actor table


MediaWiki version: 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.

Fields[edit]

actor_id[edit]

The primary key, used to uniquely identify an actor.

actor_user[edit]

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[edit]

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

Schema summary[edit]

MediaWiki version: 1.31

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


See also[edit]