Příručka:Databázová tabulka revision_actor_temp
| ↑ 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 | | | +---------------------+------------+----------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+