Manual:Image comment temp table

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 2>commons:|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 table in the future.

This table was introduced in . See also the revision_comment_temp table.

In MediaWiki 1.32, the image_comment_temp table is merged into the image table with </>.

After that, the <tvar|1>image_comment_temp</> table is removed.

imgcomment_name
Key to <tvar|1></>

imgcomment_description_id
Key to <tvar|1></>

Schema summary
<tt>DESCRIBE image_comment_temp;</tt> +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field                    | Type                | Null | Key | Default | Extra |
 * imgcomment_name          | varbinary(255)      | NO   | PRI | NULL    |       |
 * imgcomment_description_id | bigint(20) unsigned | NO  | PRI | NULL    |       |