Manual:revision_actor_temp table

The revision_actor_temp table was a temporary table used for the Actor migration (alongside with revision_comment_temp ), creating a relation between each row of the revision table and a row of the actor table. On large wikis like English Wikipedia, altering the revision table is a months-long process. This table was created so that other data migrations could be done while the alter was running. Once adding the rev_actor field to the revision table was done, the data from revision_actor_temp was merged back into the revision table and the table was deleted.

Key to revision.rev_id.

Key to actor.actor_id. Replaces revision.rev_user and revision.rev_user_text, will eventually be replaced by revision.rev_actor.

Duplicates revision.rev_timestamp, for indexing.

Duplicates revision.rev_page, for indexing.

DESCRIBErevision_actor_temp;

+--------------------+---------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------+------+-----+----------------+-------+
| revactor_rev | int(10) unsigned | NO | PRI | NULL | |
| revactor_actor | bigint(20) unsigned | NO | PRI | NULL | |
| revactor_timestamp | binary(14) | NO | | NULL | |
| revactor_page | int(10) unsigned | NO | MUL | NULL | |
+--------------------+---------------------+------+-----+----------------+-------+

DESCRIBErevision_actor_temp;

+--------------------+---------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------------+------+-----+----------------+-------+
| revactor_rev | int(10) unsigned | NO | PRI | NULL | |
| revactor_actor | bigint(20) unsigned | NO | PRI | NULL | |
| revactor_timestamp | binary(14) | NO | | | |
| revactor_page | int(10) unsigned | NO | MUL | NULL | |
+--------------------+---------------------+------+-----+----------------+-------+

SHOWINDEXINrevision_actor_temp;

+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| revision_actor_temp | 0 | PRIMARY | 1 | revactor_rev | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 0 | PRIMARY | 2 | revactor_actor | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 0 | revactor_rev | 1 | revactor_rev | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 1 | actor_timestamp | 1 | revactor_actor | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 1 | actor_timestamp | 2 | revactor_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 1 | page_actor_timestamp | 1 | revactor_page | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 1 | page_actor_timestamp | 2 | revactor_actor | A | 0 | NULL | NULL | | BTREE | | |
| revision_actor_temp | 1 | page_actor_timestamp | 3 | revactor_timestamp | A | 0 | NULL | NULL | | BTREE | | |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables