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

This page is a translated version of the page Manual:Revision actor temp table and the translation is 100% complete.

Languages:

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

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

Verze MediaWiki:

1.31 – 1.35

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

Indexy

Verze MediaWiki:

1.31 – 1.38

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