Manuel:table oldimage

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


La table oldimage contient des informations sur les anciennes révisions des fichiers. Elle est mise à jour dès qu'une nouvelle version d'un fichier déjà existant sur le wiki, est téléversée. Ces fichiers sont déplacés vers le dossier /image/archive. Néanmoins, les informations concernant les images supprimées ne seront pas enregistrées dans la table oldimage; au lieu de cela, l'information est déplacée vers filearchive au moment de la suppression.

Voir aussi : Manuel:table filearchive

Champs

oi_name

Nom de l'image (fichier et article, semblent être la même chose). Comparable à img_name .

oi_archive_name

Nom de l'image, préfixée par l'horodatage du moment où elle est devenue une ancienne version

oi_size

Taille du fichier en octets. Comparable à img_size .

oi_width

Largeur de l'image, en pixels. Comparable à img_width .

oi_height

Hauteur de l'image, en pixels. Comparable à img_height .

oi_bits

Profondeur de bit des images GIF/PNG basées sur une palette (jusqu'à 16 bits). Les images qui ne sont pas défines par une palette (JPEG/PNG/TIFF/SVG) valent 0 ou 8. Tous les autres fichiers ont la valeur 0 par défaut. Comparable to img_bits .

oi_description

Version de MediaWiki : 1.32

Champ de 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 rechargemement. Comparable à img_description .

(obsolète) Remplacé par les tables oi_description_id et comment .

oi_description_id

Version de MediaWiki : 1.30

Ceci est une clé externe vers comment_id dans la table comment .

oi_user

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

(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 oi_actor à la place.

oi_user_text

Nom du premier utilisateur qui a fait le téléversement. Comparable à img_user_text .

(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 oi_actor à la place.

oi_timestamp

Horodatage du téléversement initial. Comparable à img_timestamp .

oi_metadata

Tableau PHP sérialisé des propriétés du fichier. Comparable à img_metadata .

oi_media_type

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

Comparable à img_media_type .

oi_major_mime

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

Comparable à img_major_mime .

oi_minor_mime

Ex.: jpeg, gif, png, etc.

Comparable à img_minor_mime .

oi_deleted

revdeleted

oi_sha1

La valeur de hachage du SHA-1 du contenu du fichier, en format base 36. On utilise wfBaseConvert de includes/GlobalFunctions.php pour convertir de la base 16 (hexadecimal) vers la base 36 puis compléter le résultat sur 31 charactères. Comparable à img_sha1 .

Résumé du schéma

Version de MediaWiki : 1.34

DESCRIBE oldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field             | Type                                                                                                        | Null | Key | Default        | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name           | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_archive_name   | varbinary(255)                                                                                              | NO   |     |                |       |
| oi_size           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_width          | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_height         | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_bits           | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL           |       |
| oi_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | NULL           |       |
| oi_timestamp      | binary(14)                                                                                                  | NO   |     |                |       |
| oi_metadata       | mediumblob                                                                                                  | NO   |     | NULL           |       |
| oi_media_type     | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |       |
| oi_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown        |       |
| oi_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown        |       |
| oi_deleted        | tinyint(3) unsigned                                                                                         | NO   |     | 0              |       |
| oi_sha1           | varbinary(32)                                                                                               | NO   | MUL |                |       |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
Version de MediaWiki : 1.33

DESCRIBE oldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field             | Type                                                                                                        | Null | Key | Default        | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name           | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_archive_name   | varbinary(255)                                                                                              | NO   |     |                |       |
| oi_size           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_width          | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_height         | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_bits           | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL           |       |
| oi_user           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_user_text      | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | 0              |       |
| oi_timestamp      | binary(14)                                                                                                  | NO   |     |                |       |
| oi_metadata       | mediumblob                                                                                                  | NO   |     | NULL           |       |
| oi_media_type     | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |       |
| oi_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown        |       |
| oi_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown        |       |
| oi_deleted        | tinyint(3) unsigned                                                                                         | NO   |     | 0              |       |
| oi_sha1           | varbinary(32)                                                                                               | NO   | MUL |                |       |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
Versions de MediaWiki : 1.31 – 1.32

DESCRIBE oldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field             | Type                                                                                                        | Null | Key | Default        | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name           | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_archive_name   | varbinary(255)                                                                                              | NO   |     |                |       |
| oi_size           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_width          | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_height         | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_bits           | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_description    | varbinary(767)                                                                                              | NO   |     |                |       |
| oi_description_id | bigint(20) unsigned                                                                                         | NO   |     | 0              |       |
| oi_user           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_user_text      | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | 0              |       |
| oi_timestamp      | binary(14)                                                                                                  | NO   |     |                |       |
| oi_metadata       | mediumblob                                                                                                  | NO   |     | NULL           |       |
| oi_media_type     | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |       |
| oi_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown        |       |
| oi_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown        |       |
| oi_deleted        | tinyint(3) unsigned                                                                                         | NO   |     | 0              |       |
| oi_sha1           | varbinary(32)                                                                                               | NO   | MUL |                |       |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
Version de MediaWiki : 1.30

DESCRIBE oldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field             | Type                                                                                                        | Null | Key | Default        | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name           | varbinary(255)                                                                                              | NO   | MUL |                |       |
| oi_archive_name   | varbinary(255)                                                                                              | NO   |     |                |       |
| oi_size           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_width          | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_height         | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_bits           | int(11)                                                                                                     | NO   |     | 0              |       |
| oi_description    | varbinary(767)                                                                                              | NO   |     |                |       |
| oi_description_id | bigint(20) unsigned                                                                                         | NO   |     | 0              |       |
| oi_user           | int(10) unsigned                                                                                            | NO   |     | 0              |       |
| oi_user_text      | varbinary(255)                                                                                              | NO   | MUL | NULL           |       |
| oi_timestamp      | binary(14)                                                                                                  | NO   |     |                |       |
| oi_metadata       | mediumblob                                                                                                  | NO   |     | NULL           |       |
| oi_media_type     | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |       |
| oi_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown        |       |
| oi_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown        |       |
| oi_deleted        | tinyint(3) unsigned                                                                                         | NO   |     | 0              |       |
| oi_sha1           | varbinary(32)                                                                                               | NO   | MUL |                |       |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
Versions de MediaWiki : 1.25 – 1.29

DESCRIBE oldimage;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field           | Type                                                                                                   | Null | Key | Default        | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name         | varbinary(255)                                                                                         | NO   | MUL |                |       |
| oi_archive_name | varbinary(255)                                                                                         | NO   |     |                |       |
| oi_size         | int(10) unsigned                                                                                       | NO   |     | 0              |       |
| oi_width        | int(11)                                                                                                | NO   |     | 0              |       |
| oi_height       | int(11)                                                                                                | NO   |     | 0              |       |
| oi_bits         | int(11)                                                                                                | NO   |     | 0              |       |
| oi_description  | varbinary(767)                                                                                         | NO   |     | NULL           |       |
| oi_user         | int(10) unsigned                                                                                       | NO   |     | 0              |       |
| oi_user_text    | varbinary(255)                                                                                         | NO   | MUL | NULL           |       |
| oi_timestamp    | binary(14)                                                                                             | NO   |     |                |       |
| oi_metadata     | mediumblob                                                                                             | NO   |     | NULL           |       |
| oi_media_type   | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |       |
| oi_major_mime   | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')  | NO   |     | unknown        |       |
| oi_minor_mime   | varbinary(100)                                                                                         | NO   |     | unknown        |       |
| oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0              |       |
| oi_sha1         | varbinary(32)                                                                                          | NO   | MUL |                |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
Version de MediaWiki : 1.24

DESCRIBE oldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field           | Type                                                                                                   | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_width        | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_height       | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_bits         | int(3)                                                                                                 | NO   |     | 0       |       |
 | oi_description  | tinyblob                                                                                               | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_timestamp    | binary(14)                                                                                             | NO   |     | NULL    |       |
 | oi_metadata     | mediumblob                                                                                             | NO   |     | NULL    |       |
 | oi_media_type   | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 | oi_major_mime   | ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical')  | NO   |     | unknown |       |
 | oi_minor_mime   | varbinary(100)                                                                                         | NO   |     | unknown |       |
 | oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0       |       |
 | oi_sha1         | varbinary(32)                                                                                          | NO   | MUL | NULL    |       |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki : 1.16 – 1.23

DESCRIBE oldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field           | Type                                                                                                   | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_width        | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_height       | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_bits         | int(3)                                                                                                 | NO   |     | 0       |       |
 | oi_description  | tinyblob                                                                                               | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_timestamp    | binary(14)                                                                                             | NO   |     | NULL    |       |
 | oi_metadata     | mediumblob                                                                                             | NO   |     | NULL    |       |
 | oi_media_type   | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 | oi_major_mime   | ENUM('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 | oi_minor_mime   | varbinary(100)                                                                                         | NO   |     | unknown |       |
 | oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0       |       |
 | oi_sha1         | varbinary(32)                                                                                          | NO   | MUL | NULL    |       |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Versions de MediaWiki : 1.11 – 1.15

DESCRIBE oldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field           | Type                                                                                                   | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_width        | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_height       | int(5)                                                                                                 | NO   |     | 0       |       |
 | oi_bits         | int(3)                                                                                                 | NO   |     | 0       |       |
 | oi_description  | tinyblob                                                                                               | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned                                                                                        | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary                                                                                    | NO   | MUL | NULL    |       |
 | oi_timestamp    | binary(14)                                                                                             | NO   |     | NULL    |       |
 | oi_metadata     | mediumblob                                                                                             | NO   |     | NULL    |       |
 | oi_media_type   | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 | oi_major_mime   | ENUM('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 | oi_minor_mime   | varbinary(32)                                                                                          | NO   |     | unknown |       |
 | oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0       |       |
 | oi_sha1         | varbinary(32)                                                                                          | NO   | MUL | NULL    |       |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
Version de MediaWiki : 1.10

DESCRIBE oldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field           | Type                | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned     | NO   |     | 0       |       |
 | oi_width        | int(5)              | NO   |     | 0       |       |
 | oi_height       | int(5)              | NO   |     | 0       |       |
 | oi_bits         | int(3)              | NO   |     | 0       |       |
 | oi_description  | tinyblob            | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned     | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary | NO   |     | NULL    |       |
 | oi_timestamp    | binary(14)          | NO   |     | NULL    |       |
 +-----------------+---------------------+------+-----+---------+-------+
Versions de MediaWiki : 1.5 – 1.9

DESCRIBE oldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field           | Type                | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned     | NO   |     | 0       |       |
 | oi_width        | int(5)              | NO   |     | 0       |       |
 | oi_height       | int(5)              | NO   |     | 0       |       |
 | oi_bits         | int(3)              | NO   |     | 0       |       |
 | oi_description  | tinyblob            | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned     | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary | NO   |     | NULL    |       |
 | oi_timestamp    | char(14) binary     | NO   |     | NULL    |       |
 +-----------------+---------------------+------+-----+---------+-------+
Versions de MediaWiki : 1.1 – 1.4

DESCRIBE oldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field           | Type                | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary | NO   | MUL | NULL    |       |
 | oi_archive_name | varchar(255) binary | NO   |     | NULL    |       |
 | oi_size         | int(8) unsigned     | NO   |     | 0       |       |
 | oi_description  | tinyblob            | NO   |     | NULL    |       |
 | oi_user         | int(5) unsigned     | NO   |     | 0       |       |
 | oi_user_text    | varchar(255) binary | NO   |     | NULL    |       |
 | oi_timestamp    | char(14) binary     | NO   |     | NULL    |       |
 +-----------------+---------------------+------+-----+---------+-------+