Manual:Image comment temp table

↑ Manual:Contents

MediaWiki database layout

image_comment_temp table

MediaWiki version:

≥ 1.30

Temporary table creating a relation between each row of the image 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.

It is merged into the image table in MediaWiki 1.32 with T188132. After that, the image comment temp table is and stays empty. It is scheduled for removal in one of the following MediaWiki versions.

Fields

imgcomment_name

Key to image.img_name

imgcomment_description_id

Key to comment.comment_id

Schema summary

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