Handbuch:revision_actor_temp-Tabelle

This page is a translated version of the page Manual:Revision actor temp table and the translation is 46% complete.
Handbuch:Inhaltsübersicht MediaWiki-Datenbank-Layout revision_actor_temp-Tabelle
MediaWiki Versions:
1.31 – 1.38

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.

Felder

revactor_rev

Schlüssel zu revision.rev_id.

revactor_actor

Schlüssel zu actor.actor_id. Replaces revision.rev_user and revision.rev_user_text, will eventually be replaced by revision.rev_actor.

revactor_timestamp

Duplicates revision.rev_timestamp, for indexing.

revactor_page

Duplicates revision.rev_page, for indexing.

Schematische Übersicht

MediaWiki Versions:
1.36 – 1.38

DESCRIBE revision_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           |       |
+--------------------+---------------------+------+-----+----------------+-------+
MediaWiki Versions:
1.31 – 1.35

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

Indexe

MediaWiki Versions:
1.31 – 1.38

SHOW INDEX IN revision_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      |         |               |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+