Jump to content

Příručka:Databázová tabulka revision_actor_temp

From mediawiki.org
This page is a translated version of the page Manual:Revision actor temp table and the translation is 100% complete.
Manuál:Obsah MediaWiki schéma databáze Tabulka revision_actor_temp
Verze MediaWiki:
1.31 – 1.38

Tabulka revision_actor_temp byla dočasná tabulka používaná pro Migrace zúčastněných (spolu s revision_comment_temp , čímž se vytvořil vztah mezi každým řádkem tabulky revision a řádkem tabulky actor. Na velkých wikinách, jako je anglická Wikipedie, je změna tabulky revision procesem dlouhým měsíce. Tato tabulka byla vytvořena, aby bylo možné provádět jiné migrace dat za běhu změny. Po přidání pole rev_actor do tabulky revision byla data z revision_actor_temp sloučena zpět do tabulky revision a tabulka byla odstraněna.

Pole

revactor_rev

Klíčováno na revision.rev_id.

revactor_actor

Klíčováno na actor.actor_id. Nahrazuje revision.rev_user a revision.rev_user_text, nakonec bude nahrazen revision.rev_actor.

revactor_timestamp

Duplikáty revision.rev_timestamp, pro indexování.

revactor_page

Duplikáty revision.rev_page, pro indexování.

Přehled změn ve schématu tabulky

Verze MediaWiki:
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           |       |
+--------------------+---------------------+------+-----+----------------+-------+
Verze MediaWiki:
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           |       |
+--------------------+---------------------+------+-----+----------------+-------+

Indexy

Verze MediaWiki:
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      |         |               |
+---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+