Manual:filearchive table

From Linux Web Expert


Manual:Contents <translate> MediaWiki database layout</translate> <translate> <tvar name=1>filearchive</tvar> table</translate>

The filearchive table stores information on all the media that has been deleted, similar to the archive table's job for deleted text revisions. These files are located in the storage for deleted files; in the local storage this most likely is the folder images/deleted/. This is the table that makes image undeletion possible. Deleted files are stored in the place defined by $wgDeletedDirectory , which defaults to $wgUploadDirectory /deleted. See also: Manual:Oldimage table

Fields

fa_id

Unique row id.

fa_name

Original base filename; key to image.img_name , page.page_title , etc.

fa_archive_name

Filename of archived file, if an old revision, with prepended timestamp. E.g. 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

SHA-1 of the file contents plus extension, used as a key for storage. E.g. 8f8a562add37052a1848ff7771a2c515db94baa9.jpg

fa_deleted_user

User who deleted the file

fa_deleted_timestamp

Time of deletion, if this file is deleted

fa_deleted_reason

Deletion comment, if this file is deleted

<translate> (deprecated)</translate> fa_deleted_reason_id and the comment table should be used instead!

fa_deleted_reason_id

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.30
<translate> MediaWiki version:</translate>

This is a foreign key to comment_id in the comment table.

fa_size

File size in bytes. Duplicate of img_size .

fa_width

Image width, in pixels. Duplicate of img_width .

fa_height

Image height, in pixels. Duplicate of img_height .

fa_metadata

Serialized PHP array of the file's properties. Duplicate of img_metadata .

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. All other files default to 0. Duplicate of img_bits .

fa_media_type

Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE

Duplicate of img_media_type .

fa_major_mime

Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video

Duplicate of img_major_mime .

fa_minor_mime

E.g. jpeg, gif, png, etc.

Duplicate of img_minor_mime .

fa_description

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">
<translate> ≤</translate> 1.32
<translate> MediaWiki version:</translate>

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. Duplicate of img_description .

<translate> (deprecated)</translate> fa_description_id and the comment table should be used instead!

fa_description_id

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.30
<translate> MediaWiki version:</translate>

This is a foreign key to comment_id in the comment table.

fa_user

User ID of the user who uploaded the file. Duplicate of img_user .

fa_user_text

User name of the user who uploaded the file. Duplicate of img_user_text .

<translate> (deprecated in <tvar name=2>1.31</tvar>)</translate>; Deprecated in favor of fa_actor.

fa_actor

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.31
Gerrit change 380669
<translate> MediaWiki version:</translate>

This is a foreign key to actor_id in the actor table.

fa_timestamp

Timestamp of when upload took place. Duplicate of img_timestamp .

fa_deleted

MediaWiki version:
<translate> ≥</translate> 1.10

Visibility of deleted revisions, bitfield.

fa_sha1

MediaWiki version:
<translate> ≥</translate> 1.21

sha1 hash of file content, encoded in base 36

Schema summary

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.41
<translate> MediaWiki version:</translate>

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id                | int(10) unsigned                                                                                            | 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 | NULL    |                |
| fa_deleted_reason_id | bigint(20) unsigned                                                                                         | NO   |     | NULL    |                |
| fa_size              | bigint(20) 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  |     | NULL    |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0       |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |         |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.40</tvar> is legacy version</translate>">
1.38 – 1.40
<translate> MediaWiki versions:</translate>

DESCRIBE filearchive;

+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                | Type                                                                                                        | Null | Key | Default | Extra          |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id                | int(10) unsigned                                                                                            | 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 | NULL    |                |
| 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  |     | NULL    |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0       |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |         |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.37</tvar> is unsupported version</translate>">
1.36 – 1.37
<translate> MediaWiki versions:</translate>

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 | NULL    |                |
| 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  |     | NULL    |                |
| fa_deleted           | tinyint(3) unsigned                                                                                         | NO   |     | 0       |                |
| fa_sha1              | varbinary(32)                                                                                               | NO   | MUL |         |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.34 – 1.35
<translate> MediaWiki versions:</translate>

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 |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>">
1.33
<translate> MediaWiki version:</translate>

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 |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">
1.31 – 1.32
<translate> MediaWiki versions:</translate>

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 |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.30</tvar> is unsupported version</translate>">
1.30
<translate> MediaWiki version:</translate>

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 |                |                |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">
1.25 – 1.29
<translate> MediaWiki versions:</translate>

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 |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.24</tvar> is unsupported version</translate>">
1.24
MediaWiki version:

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 |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.23</tvar> is unsupported version</translate>">
1.21 – 1.23
<translate> MediaWiki versions:</translate>

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 |                |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.20</tvar> is unsupported version</translate>">
1.16 – 1.20
<translate> MediaWiki versions:</translate>

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              |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.15</tvar> is unsupported version</translate>">
1.10 – 1.15
<translate> MediaWiki versions:</translate>

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              |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">
1.9
MediaWiki version:

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    |                |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>">
1.7 – 1.8
<translate> MediaWiki versions:</translate>

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

Indexes

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">
<translate> ≥</translate> 1.33
<translate> MediaWiki version:</translate>

SHOW INDEX IN filearchive;

+-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name             | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| filearchive |          0 | PRIMARY              |            1 | fa_id                | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| filearchive |          1 | fa_name              |            1 | fa_name              | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| filearchive |          1 | fa_name              |            2 | fa_timestamp         | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| filearchive |          1 | fa_storage_group     |            1 | fa_storage_group     | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| filearchive |          1 | fa_storage_group     |            2 | fa_storage_key       | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| filearchive |          1 | fa_deleted_timestamp |            1 | fa_deleted_timestamp | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| filearchive |          1 | fa_actor_timestamp   |            1 | fa_actor             | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| filearchive |          1 | fa_actor_timestamp   |            2 | fa_timestamp         | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| filearchive |          1 | fa_sha1              |            1 | fa_sha1              | A         |           0 |       10 | NULL   |      | BTREE      |         |               |
+-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+