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