Manual:Image comment temp table

The image_comment_temp table is a 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  table in the future.

This table was introduced in .

See also the </> table.

In MediaWiki 1.32, the <tvar|1>image_comment_temp</> table is merged into the <tvar|2>image</> table with <tvar|3></>.

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