Manual:Oldimage table/fr

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 ; au lieu de cela, l'information est déplacée vers  au moment de la suppression.

Voir aussi :

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

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 à.

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

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

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 à.

oi_description
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 à.

Remplacé par les tables  et.

oi_description_id
Ceci est une clé externe vers dans la table.

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

Alors que s'exécute, et selon le paramètre de configuration, 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 à.

Alors que s'exécute, et selon le paramètre de configuration, 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
This is a foreign key to in the  table. Comparable to.

Replaces oi_user and oi_user_text when the is done (and enabled with the configuration setting  in versions 1.31–1.33).

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

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

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

Comparable à.

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

Comparable à.

oi_minor_mime
Ex.: jpeg, gif, png, etc.

Comparable à.

oi_deleted
Set when the image revision was deleted.

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

Résumé du schéma
 +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * 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 |         |       |

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

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

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

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

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

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

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

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

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

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

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

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