Manual:Image comment temp table/de

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

Diese Tabelle wurde in eingeführt. Siehe auch die -Tabelle.

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

imgcomment_name
Schlüssel zu

imgcomment_description_id
Schlüssel zu

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

Indexe
 +++-+--+---+---+-+--++--++-+---+ +++-+--+---+---+-+--++--++-+---+ +++-+--+---+---+-+--++--++-+---+
 * Table             | Non_unique | Key_name        | Seq_in_index | Column_name               | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * image_comment_temp |         0 | PRIMARY         |            1 | imgcomment_name           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * image_comment_temp |         0 | PRIMARY         |            2 | imgcomment_description_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * image_comment_temp |         0 | imgcomment_name |            1 | imgcomment_name           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |