Manual:Revision actor temp table

The revision_actor_temp table is a temporary table used for the , 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 is being created to avoid such an alter, and will be merged back into the revision table in the future.

revactor_rev
Key to .

revactor_actor
Key to . Replaces <tvar|1></> and <tvar|2></>, will eventually be replaced by <tvar|3></>.

revactor_timestamp
Duplicates <tvar|1></>, for indexing.

revactor_page
Duplicates <tvar|1></>, for indexing.

Schema summary
++-+--+-+-+---+ ++-+--+-+-+---+ ++-+--+-+-+---+
 * 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    |       |

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

Indexes
<pre style="overflow-x: scroll; white-space: pre;"> +-++--+--++---+-+--++--++-+---+ +-++--+--++---+-+--++--++-+---+ +-++--+--++---+-+--++--++-+---+
 * 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      |         |               |