Handbuch:image_comment_temp-Tabelle

↑ Handbuch:Inhaltsübersicht

MediaWiki-Datenbank-Layout

image_comment_temp-Tabelle

MediaWiki Versions:

1.30 – 1.31

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 was created to avoid such an alter, and was merged back into the image table once the image.img_description_id field was created.

Diese Tabelle wurde in Gerrit change 357892 eingeführt. Siehe auch die revision_comment_temp -Tabelle.

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.

Felder

imgcomment_name

Schlüssel zu image.img_name

imgcomment_description_id

Schlüssel zu comment.comment_id

Schematische Übersicht

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

Indexe

MediaWiki Versions:

1.30 – 1.31

SHOW INDEX IN image_comment_temp;

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