Open main menu

Manual:revision_comment_temp table

Other languages:
English • ‎dansk • ‎日本語
Manual:Contents MediaWiki database layout revision_comment_temp table


MediaWiki version: 1.30

The revision_comment_temp table is a temporary table creating a relation between each row of the revision table and a row of the comment table. It has been created to avoid blocking on an alter of the revision table. On large wikis like the 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 revision in the future.

This table was introduced in Gerrit change 357892. See also the image_comment_temp table.

FieldsEdit

revcomment_revEdit

Key to revision.rev_id

revcomment_comment_idEdit

Key to comment.comment_id

Schema summaryEdit

DESCRIBE revision_comment_temp;

+-----------------------+---------------------+------+-----+---------+-------+
| Field                 | Type                | Null | Key | Default | Extra |
+-----------------------+---------------------+------+-----+---------+-------+
| revcomment_rev        | int(10) unsigned    | NO   | PRI | NULL    |       |
| revcomment_comment_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
+-----------------------+---------------------+------+-----+---------+-------+