Manuel:table oldimage
↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table oldimage |
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
Version de MediaWiki : | ≥ 1.5 |
Largeur de l'image, en pixels. Comparable à img_width .
oi_height
Version de MediaWiki : | ≥ 1.5 |
Hauteur de l'image, en pixels. Comparable à img_height .
oi_bits
Version de MediaWiki : | ≥ 1.5 |
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 à 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 depuis v. 1.30)
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
Version de MediaWiki : | ≤ 1.33 |
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
Version de MediaWiki : | ≤ 1.33 |
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_actor
Version de MediaWiki : | ≥ 1.31 |
C'est une clé externe pour actor_id dans la table actor . Comparable à img_actor .
Remplace oi_user et oi_user_text lorsque le Migration d'acteur est fait (et activé avec le paramètre de configuration $wgActorTableSchemaMigrationStage
dans les versions 1.31–1.33).
oi_timestamp
Horodatage du téléversement initial. Comparable à img_timestamp .
oi_metadata
Version de MediaWiki : | ≥ 1.11 |
Tableau PHP sérialisé des propriétés du fichier. Comparable à img_metadata .
oi_media_type
Version de MediaWiki : | ≥ 1.11 |
Valeurs possibles : UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE
Comparable à img_media_type .
oi_major_mime
Version de MediaWiki : | ≥ 1.11 |
Valeurs possibles : unknown, application, audio, chemical, image, message, model, multipart, text, video
Comparable à img_major_mime .
oi_minor_mime
Version de MediaWiki : | ≥ 1.11 |
Ex.: jpeg, gif, png, etc.
Comparable à img_minor_mime .
oi_deleted
Version de MediaWiki : | ≥ 1.11 |
Positionné lorsque la révision de l'image a été supprimée.
oi_sha1
Version de MediaWiki : | ≥ 1.11 |
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.41 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | oi_name | varbinary(255) | NO | MUL | | | | oi_archive_name | varbinary(255) | NO | | | | | oi_size | bigint(20) 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 | MUL | NULL | | | 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.36 – 1.40 |
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 | | NULL | | | 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.34 – 1.35 |
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 | | +-----------------+---------------------+------+-----+---------+-------+
Index
Version de MediaWiki : | ≥ 1.34 |
SHOW INDEX IN oldimage;
+----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | oldimage | 1 | oi_actor_timestamp | 1 | oi_actor | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_actor_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_timestamp | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_archive_name | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_archive_name | 2 | oi_archive_name | A | 0 | 14 | NULL | | BTREE | | | | oldimage | 1 | oi_sha1 | 1 | oi_sha1 | A | 0 | 10 | NULL | | BTREE | | | | oldimage | 1 | oi_timestamp | 1 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | +----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+