Manual:image/fr table
From Linux Web Expert
| ↑ Manuel:Contenu | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>image/fr</tvar> table</translate> |
La table image décrit les images et les autres fichiers téléversés.
Néanmoins, les pages de description des images sont enregistrées comme les autres pages.
Voir aussi : l'administration des images.
Beaucoup de champs de cette table sont analogues à ceux de la table oldimage.
Une partie de ces informations a été adaptée de schema.doc dans le répertoire docs/ de MediaWiki.
Le chemin vers l'image actuelle n'est pas enregistré dans cette table : voir $wgHashedUploadDirectory.
Champs
img_name
Nom du fichier avec des caractères souligné '_'
img_size
Taille du fichier en octets.
img_width
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Largeur de l'image, en pixels.
img_height
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Hauteur de l'image, en pixels.
img_metadata
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Propriétés du fichier sérialisé, en tant que tableau PHP sérialisé ou en JSON.
Le tableau json peut contenir une adresse dans la table de texte ou le stockage externe.
0, -1 ou vide si l'extracteur a échoué.
T155741
img_bits
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Profondeur de bit pour les images GIF/PNG basées sur une palette (jusque 8 bits). Les images qui n'utilisent pas de palette, telles que les (JPEG/PNG/TIFF/SVG) ont 0, 8, ou 16. Tous les autres fichiers ont la valeur par défaut 0.
img_media_type
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Valeurs possibles : UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
img_major_mime
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Valeurs possibles : unknown, application, audio, chemical, image, message, model, multipart, text, video
img_minor_mime
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
Par exemple : jpeg, gif, png, svg+xml, tiff, ogg, pdf vnd.djvu, webm, wav, mpeg, x-flac, midi, x-xcf, sla, webp, etc.
img_description
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.32
| <translate> MediaWiki version:</translate> |
Champ description fourni au téléversement. Il ne s'agit pas de la page de description (page wiki File: associée), mais du résumé fourni par l'utilisateur en cas de rechargement.
<translate> (deprecated)</translate>; utilisez imgcomment_description_id de la table image_comment_temp ainsi que la table comment à la place !
img_description_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
This is a foreign key to comment_id in the comment table.
img_user
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.33
| <translate> MediaWiki version:</translate> |
ID utilisateur de l'utilisateur qui a téléversé le fichier.
<translate> (deprecated in <tvar name=2>1.31</tvar>)</translate>
Alors que Migration d'acteur s'exécute, et selon le paramètre de configuration $wgActorTableSchemaMigrationStage, ce champ peut être vide et l'acteur qui réalise la modification peut être enregistré dans le champ img_actor à la place.
img_user_text
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.33
| <translate> MediaWiki version:</translate> |
Nom utilisateur de l'utilisateur qui a téléversé le fichier.
<translate> (deprecated in <tvar name=2>1.31</tvar>)</translate>
Alors que Migration d'acteur s'exécute, et selon le paramètre de configuration $wgActorTableSchemaMigrationStage, ce champ peut être vide et l'acteur qui réalise la modification peut être enregistré dans le champ img_actor à la place.
img_actor
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.31
| <translate> MediaWiki version:</translate> |
Ceci est une clé externe vers actor_id dans la table actor et spécifie l'acteur qui a publié la version la plus récente de l'image
img_timestamp
Horodatage du téléversement. Pas nécessairement la même heure que logging.log_timestamp.
À part pour les révisions d'images importées d'un autre wiki, l'horodatage est unique à chaque révision de fichier et permet de l'identifier. Si deux modifications d'un même fichier arrivent dans la même seconde, la dernière est différées jusqu'à qu'elle aie un horodatage différent.
img_sha1
| Version de MediaWiki : | <translate> ≥</translate> 1.11 |
Valeur de hachage SHA-1 du contenu de fichier en format base 36. Wikimedia\base_convert() est utilisé pour convertir le format base 16 (hexadécimal) en format base 36 puis pour étendre le résultat à 31 caractères.
img_type
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.4</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.4
| Version de MediaWiki : |
Résumé du schéma
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.41
| <translate> MediaWiki version:</translate> |
DESCRIBE image/fr;
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | bigint(20) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description_id | bigint(20) unsigned | NO | | NULL | |
| img_actor | bigint(20) unsigned | NO | MUL | NULL | |
| img_timestamp | binary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.40</tvar> is legacy version</translate>"> 1.36 – 1.40
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description_id | bigint(20) unsigned | NO | | NULL | |
| img_actor | bigint(20) unsigned | NO | MUL | NULL | |
| img_timestamp | binary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>"> 1.34 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description_id | bigint(20) unsigned | NO | | NULL | |
| img_actor | bigint(20) unsigned | NO | MUL | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>"> 1.33
| <translate> MediaWiki version:</translate> |
DESCRIBE image/fr;
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description_id | bigint(20) unsigned | NO | | NULL | |
| img_user | int(10) unsigned | NO | MUL | 0 | |
| img_user_text | varbinary(255) | NO | MUL | | |
| img_actor | bigint(20) unsigned | NO | MUL | 0 | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>"> 1.31 – 1.32
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description | varbinary(767) | NO | | | |
| img_description_id | bigint(20) unsigned | NO | | 0 | |
| img_user | int(10) unsigned | NO | MUL | 0 | |
| img_user_text | varbinary(255) | NO | MUL | | |
| img_actor | bigint(20) unsigned | NO | MUL | 0 | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.30</tvar> is unsupported version</translate>"> 1.30
| <translate> MediaWiki version:</translate> |
DESCRIBE image/fr;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description | varbinary(767) | NO | | | |
| img_user | int(10) unsigned | NO | MUL | 0 | |
| img_user_text | varbinary(255) | NO | MUL | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>"> 1.25 – 1.29
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | MUL | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description | varbinary(767) | NO | | NULL | |
| img_user | int(10) unsigned | NO | MUL | 0 | |
| img_user_text | varbinary(255) | NO | MUL | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.24</tvar> is unsupported version</translate>"> 1.24
| Version de MediaWiki : |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) binary | NO | | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.23</tvar> is unsupported version</translate>"> 1.16 – 1.23
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| img_minor_mime | varbinary(100) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) binary | NO | | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.15</tvar> is unsupported version</translate>"> 1.11 – 1.15
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| img_minor_mime | varbinary(32) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) binary | NO | | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.10</tvar> is unsupported version</translate>"> 1.10
| Version de MediaWiki : |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varbinary(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| img_minor_mime | varbinary(32) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) binary | NO | | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>"> 1.5 – 1.9
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) binary | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| img_minor_mime | varchar(32) binary | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) binary | NO | | NULL | |
| img_timestamp | char(14) binary | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.4</tvar> is unsupported version</translate>"> 1.1 – 1.4
| <translate> MediaWiki versions:</translate> |
DESCRIBE image/fr;
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | img_name | varchar(255) binary | NO | MUL | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | char(14) binary | NO | MUL | NULL | | +-----------------+---------------------+------+-----+---------+-------+
Les index
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.34
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN image/fr;
+-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | image | 0 | PRIMARY | 1 | img_name | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_actor_timestamp | 1 | img_actor | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_actor_timestamp | 2 | img_timestamp | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_size | 1 | img_size | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_timestamp | 1 | img_timestamp | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_sha1 | 1 | img_sha1 | A | 0 | 10 | NULL | | BTREE | | | | image | 1 | img_media_mime | 1 | img_media_type | A | 0 | NULL | NULL | YES | BTREE | | | | image | 1 | img_media_mime | 2 | img_major_mime | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_media_mime | 3 | img_minor_mime | A | 0 | NULL | NULL | | BTREE | | | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
