Manuel:table filearchive

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


Version de MediaWiki : 1.7

La table filearchive contient les informations sur tous les média supprimés, similaire aux tâches de la table archive et concernant les révisions supprimées. Ces fichiers sont situés à l'emplacement des fichiers supprimés; en cas de stockage local, il s'agit en général du répertoire images/deleted/. C'est la table qui permet de restituer les images après suppression. Avant MediaWiki 1.11, ceci était désactivé par défaut, et Manuel:$wgSaveDeletedFiles devait être positionné à true pour l'activer. Depuis la version 1.11, le comportement est contrôlé par $wgFileStore , et les fichiers supprimés vont par défaut dans $wgUploadDirectory /deleted. Voir aussi : Manuel:table oldimage

Champs

fa_id

ID unique de la ligne.

fa_name

Nom de fichier original de la base; clé pour image.img_name , page.page_title , etc.

fa_archive_name

Nom de fichier du fichier archivé, s'il s'agit d'une version ancienne, préfixé avec l'horodatage. Par exemple : 20090311210905!Constant_and_setup.png

fa_storage_group

Quel moyen d'enregistrement (répertoire ou objet de stockage) utiliser pour ranger les données de fichiers. Doit être deleted pour les fichiers supprimés; tout autre valeur n'est pas encore utilisée.

fa_storage_key

SHA-1 du contenu de fichier plus l'extension, utilisé comme clé pour l'enregistrement. Par exemple : 8f8a562add37052a1848ff7771a2c515db94baa9.jpg

fa_deleted_user

Utilisateur qui a supprimé le fichier

fa_deleted_timestamp

Horodatage de la suppression (si ce fichier est supprimé)

fa_deleted_reason

Commentaire de suppression (si ce fichier est supprimé)

(obsolète) Utilisez les tables fa_deleted_reason_id et comment à la place.

fa_deleted_reason_id

Version de MediaWiki : 1.30

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

fa_size

Taille du fichier en octets. Doublon avec img_size .

fa_width

Largeur de l'image, en pixels. Doublon avec img_width .

fa_height

Hauteur de l'image, en pixels. Doublon avec img_height .

fa_metadata

Tableau PHP sérialisé avec les propriétés de fichier. Doublon avec img_metadata .

fa_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 valent 0 par défaut. Doublon avec img_bits .

fa_media_type

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

Doublon avec img_media_type .

fa_major_mime

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

Doublon avec img_major_mime .

fa_minor_mime

Par exemple : jpeg, gif, png, etc.

Doublon avec img_minor_mime .

fa_description

Version de MediaWiki : 1.32

Champ de description fourni au moment du 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. Doublon avec img_description .

(obsolète) Utilisez les tables fa_description_id et comment à la place.

fa_description_id

Version de MediaWiki : 1.30

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

fa_user

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

fa_user_text

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

(obsolète depuis v. 1.31); remplacé par fa_actor.

fa_actor

Version de MediaWiki : 1.31
Gerrit change 380669

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

fa_timestamp

Horodatage du téléversement. Doublon avec img_timestamp .

fa_deleted

Version de MediaWiki : 1.10

Visibilité des révisions supprimées, champ de bits.

fa_sha1

Version de MediaWiki : 1.21

sha1 de hachage du contenu du fichier, encodé en base 36

Résumé du schéma

Version de MediaWiki : 1.34

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default        | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                     | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                              | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                              | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                               | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                               | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                     | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                                  | YES  | MUL |                |                |
| fa_deleted_reason_id | bigint(20) unsigned                                                                                         | NO   |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                                  | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                              | YES  |     | unknown        |                |
| fa_description_id    | bigint(20) unsigned                                                                                         | NO   |     | NULL           |                |
| fa_actor             | bigint(20) unsigned                                                                                         | NO   | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                                  | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Version de MediaWiki : 1.33

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default        | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                     | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                              | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                              | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                               | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                               | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                     | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                                  | YES  | MUL |                |                |
| fa_deleted_reason_id | bigint(20) unsigned                                                                                         | NO   |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                                  | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                              | YES  |     | unknown        |                |
| fa_description_id    | bigint(20) unsigned                                                                                         | NO   |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                              | YES  | MUL |                |                |
| fa_actor             | bigint(20) unsigned                                                                                         | NO   | MUL | 0              |                |
| fa_timestamp         | binary(14)                                                                                                  | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Versions de MediaWiki : 1.31 – 1.32

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default        | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                     | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                              | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                              | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                               | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                               | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                     | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                                  | YES  | MUL |                |                |
| fa_deleted_reason    | varbinary(767)                                                                                              | YES  |     |                |                |
| fa_deleted_reason_id | bigint(20) unsigned                                                                                         | NO   |     | 0              |                |
| fa_size              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                                  | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                              | YES  |     | unknown        |                |
| fa_description       | varbinary(767)                                                                                              | YES  |     |                |                |
| fa_description_id    | bigint(20) unsigned                                                                                         | NO   |     | 0              |                |
| fa_user              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                              | YES  | MUL |                |                |
| fa_actor             | bigint(20) unsigned                                                                                         | NO   | MUL | 0              |                |
| fa_timestamp         | binary(14)                                                                                                  | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Version de MediaWiki : 1.30

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default        | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                     | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                              | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                              | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                               | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                               | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                     | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                                  | YES  | MUL |                |                |
| fa_deleted_reason    | varbinary(767)                                                                                              | YES  |     |                |                |
| fa_deleted_reason_id | bigint(20) unsigned                                                                                         | NO   |     | 0              |                |
| fa_size              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                                  | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                     | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                              | YES  |     | unknown        |                |
| fa_description       | varbinary(767)                                                                                              | YES  |     |                |                |
| fa_description_id    | bigint(20) unsigned                                                                                         | NO   |     | 0              |                |
| fa_user              | int(10) unsigned                                                                                            | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                              | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                                  | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Versions de MediaWiki : 1.25 – 1.29

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default        | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                         | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                         | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                          | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                          | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                             | YES  | MUL |                |                |
| fa_deleted_reason    | varbinary(767)                                                                                         | YES  |     |                |                |
| fa_size              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')  | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                         | YES  |     | unknown        |                |
| fa_description       | varbinary(767)                                                                                         | YES  |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                         | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                             | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                    | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                          | NO   | MUL |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Version de MediaWiki : 1.24

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default        | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                         | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                         | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                          | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                          | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                             | YES  | MUL |                |                |
| fa_deleted_reason    | blob                                                                                                   | YES  |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')  | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                         | YES  |     | unknown        |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                         | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                             | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                    | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                          | NO   | MUL |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Versions de MediaWiki : 1.21 – 1.23

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default        | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                         | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                         | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                          | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                          | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                             | YES  | MUL |                |                |
| fa_deleted_reason    | blob                                                                                                   | YES  |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart')             | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                         | YES  |     | unknown        |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                         | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                             | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                    | NO   |     | 0              |                |
| fa_sha1              | varbinary(32)                                                                                          | NO   | MUL |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Versions de MediaWiki : 1.16 – 1.20

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default        | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                         | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                         | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                          | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                          | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                             | YES  | MUL |                |                |
| fa_deleted_reason    | blob                                                                                                   | YES  |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart')             | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(100)                                                                                         | YES  |     | unknown        |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                         | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                             | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                    | NO   |     | 0              |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Versions de MediaWiki : 1.10 – 1.15

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default        | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL           | auto_increment |
| fa_name              | varbinary(255)                                                                                         | NO   | MUL |                |                |
| fa_archive_name      | varbinary(255)                                                                                         | YES  |     |                |                |
| fa_storage_group     | varbinary(16)                                                                                          | YES  | MUL | NULL           |                |
| fa_storage_key       | varbinary(64)                                                                                          | YES  |     |                |                |
| fa_deleted_user      | int(11)                                                                                                | YES  |     | NULL           |                |
| fa_deleted_timestamp | binary(14)                                                                                             | YES  | MUL |                |                |
| fa_deleted_reason    | blob                                                                                                   | YES  |     | NULL           |                |
| fa_size              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_width             | int(11)                                                                                                | YES  |     | 0              |                |
| fa_height            | int(11)                                                                                                | YES  |     | 0              |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL           |                |
| fa_bits              | int(11)                                                                                                | YES  |     | 0              |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL           |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart')             | YES  |     | unknown        |                |
| fa_minor_mime        | varbinary(32)                                                                                          | YES  |     | unknown        |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL           |                |
| fa_user              | int(10) unsigned                                                                                       | YES  |     | 0              |                |
| fa_user_text         | varbinary(255)                                                                                         | YES  | MUL | NULL           |                |
| fa_timestamp         | binary(14)                                                                                             | YES  |     |                |                |
| fa_deleted           | tinyint(3) unsigned                                                                                    | NO   |     | 0              |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Version de MediaWiki : 1.9

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL    | auto_increment |
| fa_name              | varchar(255)                                                                                           | NO   | MUL |         |                |
| fa_archive_name      | varchar(255)                                                                                           | YES  |     |         |                |
| fa_storage_group     | varchar(16)                                                                                            | YES  | MUL | NULL    |                |
| fa_storage_key       | varchar(64)                                                                                            | YES  |     |         |                |
| fa_deleted_user      | int(11)                                                                                                | YES  | MUL | NULL    |                |
| fa_deleted_timestamp | char(14)                                                                                               | YES  | MUL |         |                |
| fa_deleted_reason    | text                                                                                                   | YES  |     | NULL    |                |
| fa_size              | int(8) unsigned                                                                                        | YES  |     | 0       |                |
| fa_width             | int(5)                                                                                                 | YES  |     | 0       |                |
| fa_height            | int(5)                                                                                                 | YES  |     | 0       |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL    |                |
| fa_bits              | int(3)                                                                                                 | YES  |     | 0       |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart')             | YES  |     | unknown |                |
| fa_minor_mime        | varchar(32)                                                                                            | YES  |     | unknown |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL    |                |
| fa_user              | int(5) unsigned                                                                                        | YES  |     | 0       |                |
| fa_user_text         | varchar(255)                                                                                           | YES  |     | NULL    |                |
| fa_timestamp         | char(14)                                                                                               | YES  |     | NULL    |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Versions de MediaWiki : 1.7 – 1.8

DESCRIBE filearchive;

+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                | Type                                                                                                   | Null | Key | Default | Extra          |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id                | int(11)                                                                                                | NO   | PRI | NULL    | AUTO_INCREMENT |
| fa_name              | varchar(255)                                                                                           | NO   | MUL |         |                |
| fa_archive_name      | varchar(255)                                                                                           | YES  |     |         |                |
| fa_storage_group     | varchar(16)                                                                                            | YES  | MUL | NULL    |                |
| fa_storage_key       | varchar(64)                                                                                            | YES  |     |         |                |
| fa_deleted_user      | int(11)                                                                                                | YES  | MUL | NULL    |                |
| fa_deleted_timestamp | char(14)                                                                                               | YES  | MUL |         |                |
| fa_deleted_reason    | text                                                                                                   | YES  |     | NULL    |                |
| fa_size              | int(8) unsigned                                                                                        | YES  |     | 0       |                |
| fa_width             | int(5)                                                                                                 | YES  |     | 0       |                |
| fa_height            | int(5)                                                                                                 | YES  |     | 0       |                |
| fa_metadata          | mediumblob                                                                                             | YES  |     | NULL    |                |
| fa_bits              | int(3)                                                                                                 | YES  |     | 0       |                |
| fa_media_type        | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |                |
| fa_major_mime        | enum('unknown','application','audio','image','text','video','message','model','multipart')             | YES  |     | unknown |                |
| fa_minor_mime        | varchar(32)                                                                                            | YES  |     | unknown |                |
| fa_description       | tinyblob                                                                                               | YES  |     | NULL    |                |
| fa_user              | int(5) unsigned                                                                                        | YES  |     | 0       |                |
| fa_user_text         | varchar(255)                                                                                           | YES  |     |         |                |
| fa_timestamp         | char(14)                                                                                               | YES  |     |         |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+