Manual:image_comment_temp table

From MediaWiki.org
Jump to navigation Jump to search

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


MediaWiki versions: 1.30 – 1.31

Temporary table creating a relation between each row of the comment table and a row of the comment table. It has been created to avoid blocking on an alter of the image table. On large wikis like Wikimedia Commons, altering the image table is a months-long process. This table is being created to avoid such an alter, and will be merged back into the image in the future.

This table was introduced in Gerrit change 357892.

In MediaWiki 1.32, the image_comment_temp table is merged into the image table with task T188132. After that, the image_comment_temp table is removed.

Fields[edit]

imgcomment_name[edit]

Key to image.img_name

imgcomment_description_id[edit]

Key to comment.comment_id

Schema summary[edit]

MediaWiki versions: 1.30 – 1.31

DESCRIBE image_comment_temp;

+---------------------------+---------------------+------+-----+---------+-------+
| Field                     | Type                | Null | Key | Default | Extra |
+---------------------------+---------------------+------+-----+---------+-------+
| imgcomment_name           | varbinary(255)      | NO   | PRI | NULL    |       |
| imgcomment_description_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
+---------------------------+---------------------+------+-----+---------+-------+