Manual:Filearchive table/fr

La table filearchive contient les informations sur tous les média supprimés, similaire aux tâches de la table 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 devait être positionné à   pour l'activer. Depuis la version 1.11, le comportement est contrôlé par, et les fichiers supprimés vont par défaut dans /deleted. Voir aussi :

fa_id
ID unique de la ligne.

fa_name
Original base filename; key to, , etc.

fa_archive_name
Filename of archived file, if an old revision, with prepended timestamp. Par exemple : 20090311210905!Constant_and_setup.png

fa_storage_group
Which storage bin (directory tree or object store) the file data is stored in. Should be 'deleted' for files that have been deleted; any other bin is not yet in use.

fa_storage_key
of the file contents plus extension, used as a key for storage. 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é)

fa_deleted_reason_id et la table  doivent être utilisiés à la place.

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

fa_size
Taille du fichier en octets. Doublon avec.

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

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

fa_metadata
Serialized PHP array of the file's properties. Doublon avec.

fa_bits
Bit-depth of GIF/PNG palette-based images (up to 16-bit). Non-palette images (JPEG/PNG/TIFF/SVG) are 0 or 8. Tous les autres fichiers valent 0 par défaut. Doublon avec.

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

Doublon avec.

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

Doublon avec.

fa_minor_mime
Par exemple : jpeg, gif, png, etc.

Doublon avec.

fa_description
Description field given during upload. It's not the description page (associated File: wiki page), but the "summary" provided by the user in case of reupload. Doublon avec.

fa_description_id and the comment table should be used instead!

fa_description_id
This is a foreign key to in the  table.

fa_user
 of the user who uploaded the file. Doublon avec.

fa_user_text
of the user who uploaded the file. Doublon avec.

Deprecated in favor of fa_actor.

fa_actor
This is a foreign key to in the  table.

fa_timestamp
Timestamp of when upload took place. Doublon avec.

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

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

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

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

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

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

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

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

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

DESCRIBE filearchive;</tt> +--++--+-+++ +--++--+-+++ +--++--+-+++
 * 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              |                |

DESCRIBE filearchive;</tt> +--++--+-+++ +--++--+-+++ +--++--+-+++
 * 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              |                |

DESCRIBE filearchive;</tt> +--++--+-+-++ +--++--+-+-++ +--++--+-+-++
 * 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    |                |

DESCRIBE filearchive;</tt> +--++--+-+-++ +--++--+-+-++ +--++--+-+-++
 * 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  |     |         |                |