Manual:Actor table

The actor table is where MediaWiki stores information about actors, factored out from the, , , , , , tables in T167246.

actor_id
The primary key, used to uniquely identify an actor.

actor_user
A key to of the user who made the action, or  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. such as 24.150.61.xxx ; see bug 3631 ). Some edits imported from UseModWiki may contain a Reverse DNS lookup hostname like or.

Schema summary
++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * 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
 +---+++--+-+---+-+--++--++-+---+ +---+++--+-+---+-+--++--++-+---+ +---+++--+-+---+-+--++--++-+---+
 * 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      |         |               |