Manuel:table image

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Image table and the translation is 100% complete.
Other languages:
English • ‎español • ‎français • ‎polski • ‎日本語
Manuel:Contenu Schéma de base de données MédiaWiki image table


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

Largeur de l'image, en pixels.

img_height

Hauteur de l'image, en pixels.

img_metadata

Version de MediaWiki :
1.5

Tableau PHP sérialisé avec les propriétés de fichier. 0 si l'extracteur a échoué. T155741

img_bits

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

Valeurs possibles : UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D

img_major_mime

Valeurs possibles : unknown, application, audio, chemical, image, message, model, multipart, text, video

img_minor_mime

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

Version de MediaWiki :
1.32

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.

(obsolète); utilisez imgcomment_description_id de la table image_comment_temp ainsi que la table comment à la place !

img_description_id

This is a foreign key to comment_id in the comment table.

img_user

ID utilisateur de l'utilisateur qui a téléversé le fichier.

(obsolète depuis v. 1.31) 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

Nom utilisateur de l'utilisateur qui a téléversé le fichier.

(obsolète depuis v. 1.31) 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

Ceci est une clé externe vers actor_id dans la table actor .

img_timestamp

Horodatage du téléversement. Pas nécessairement la même heure que logging.log_timestamp.

img_sha1

Version de MediaWiki :
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

Version de MediaWiki :
1.4

Résumé du schéma

Version de MediaWiki :
1.34

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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 |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Version de MediaWiki :
1.33

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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 |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.31 – 1.32

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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 |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Version de MediaWiki :
1.30

DESCRIBE image;

+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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 |         |       |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.25 – 1.29

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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 |         |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Version de MediaWiki :
1.24

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.16 – 1.23

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.11 – 1.15

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Version de MediaWiki :
1.10

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.5 – 1.9

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| 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    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.1 – 1.4

DESCRIBE image;

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