Manual:filearchive table
| ↑ Manual:Contents | MediaWiki database layout | filearchive table |
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
editfa_id
editUnique row ID.
fa_name
editOriginal base filename; key to image.img_name, page.page_title, etc.
fa_archive_name
editFilename of archived file, if an old revision, with prepended timestamp. E.g. 20090311210905!Constant_and_setup.png
fa_storage_group
editWhich 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
editSHA-1 of the file contents plus extension, used as a key for storage. E.g. 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
fa_deleted_user
editUser who deleted the file
fa_deleted_timestamp
editTime of deletion, if this file is deleted
fa_deleted_reason
editDeletion comment, if this file is deleted
(deprecated)
fa_deleted_reason_id and the comment table should be used instead!
fa_deleted_reason_id
edit| MediaWiki version: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_size
editFile size in bytes. Duplicate of img_size.
fa_width
editImage width, in pixels. Duplicate of img_width.
fa_height
editImage height, in pixels. Duplicate of img_height.
fa_metadata
editSerialized PHP array of the file's properties. Duplicate of img_metadata.
fa_bits
editBit-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
editPossibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
Duplicate of img_media_type.
fa_major_mime
editPossibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video
Duplicate of img_major_mime.
fa_minor_mime
editE.g. jpeg, gif, png, etc.
Duplicate of img_minor_mime.
fa_description
edit| MediaWiki version: | ≤ 1.32 |
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.
(deprecated)
fa_description_id and the comment table should be used instead!
fa_description_id
edit| MediaWiki version: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_user
editUser ID of the user who uploaded the file. Duplicate of img_user.
fa_user_text
editUser name of the user who uploaded the file. Duplicate of img_user_text.
(deprecated in 1.31); Deprecated in favor of fa_actor.
fa_actor
edit| MediaWiki version: | ≥ 1.31 Gerrit change 380669 |
This is a foreign key to actor_id in the actor table.
fa_timestamp
editTimestamp of when upload took place. Duplicate of img_timestamp.
fa_deleted
edit| MediaWiki version: | ≥ 1.10 |
Visibility of deleted revisions, bitfield.
fa_sha1
edit| MediaWiki version: | ≥ 1.21 |
sha1 hash of file content, encoded in base 36
Schema summary
edit| MediaWiki version: | ≥ 1.41 |
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.38 – 1.40 |
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.36 – 1.37 |
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.34 – 1.35 |
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki version: | 1.33 |
DESCRIBE filearchive;
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason_id | bigint(20) unsigned | NO | | NULL | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description_id | bigint(20) unsigned | NO | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | | |
| fa_actor | bigint(20) unsigned | NO | MUL | 0 | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki versions: | 1.31 – 1.32 |
DESCRIBE filearchive;
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | varbinary(767) | YES | | | |
| fa_deleted_reason_id | bigint(20) unsigned | NO | | 0 | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | varbinary(767) | YES | | | |
| fa_description_id | bigint(20) unsigned | NO | | 0 | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | | |
| fa_actor | bigint(20) unsigned | NO | MUL | 0 | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki version: | 1.30 |
DESCRIBE filearchive;
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | varbinary(767) | YES | | | |
| fa_deleted_reason_id | bigint(20) unsigned | NO | | 0 | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | varbinary(767) | YES | | | |
| fa_description_id | bigint(20) unsigned | NO | | 0 | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki versions: | 1.25 – 1.29 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | varbinary(767) | YES | | | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | varbinary(767) | YES | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki version: | 1.24 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | blob | YES | | NULL | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki versions: | 1.21 – 1.23 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | blob | YES | | NULL | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
| fa_sha1 | varbinary(32) | NO | MUL | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki versions: | 1.16 – 1.20 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | blob | YES | | NULL | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | YES | | unknown | |
| fa_minor_mime | varbinary(100) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki versions: | 1.10 – 1.15 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varbinary(255) | NO | MUL | | |
| fa_archive_name | varbinary(255) | YES | | | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | | |
| fa_deleted_user | int(11) | YES | | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | | |
| fa_deleted_reason | blob | YES | | NULL | |
| fa_size | int(10) unsigned | YES | | 0 | |
| fa_width | int(11) | YES | | 0 | |
| fa_height | int(11) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(11) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | YES | | unknown | |
| fa_minor_mime | varbinary(32) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(10) unsigned | YES | | 0 | |
| fa_user_text | varbinary(255) | YES | MUL | NULL | |
| fa_timestamp | binary(14) | YES | | | |
| fa_deleted | tinyint(3) unsigned | NO | | 0 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| MediaWiki version: | 1.9 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varchar(255) | NO | MUL | | |
| fa_archive_name | varchar(255) | YES | | | |
| fa_storage_group | varchar(16) | YES | MUL | NULL | |
| fa_storage_key | varchar(64) | YES | | | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | char(14) | YES | MUL | | |
| fa_deleted_reason | text | YES | | NULL | |
| fa_size | int(8) unsigned | YES | | 0 | |
| fa_width | int(5) | YES | | 0 | |
| fa_height | int(5) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(3) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | YES | | unknown | |
| fa_minor_mime | varchar(32) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(5) unsigned | YES | | 0 | |
| fa_user_text | varchar(255) | YES | | NULL | |
| fa_timestamp | char(14) | YES | | NULL | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.7 – 1.8 |
DESCRIBE filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | AUTO_INCREMENT |
| fa_name | varchar(255) | NO | MUL | | |
| fa_archive_name | varchar(255) | YES | | | |
| fa_storage_group | varchar(16) | YES | MUL | NULL | |
| fa_storage_key | varchar(64) | YES | | | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | char(14) | YES | MUL | | |
| fa_deleted_reason | text | YES | | NULL | |
| fa_size | int(8) unsigned | YES | | 0 | |
| fa_width | int(5) | YES | | 0 | |
| fa_height | int(5) | YES | | 0 | |
| fa_metadata | mediumblob | YES | | NULL | |
| fa_bits | int(3) | YES | | 0 | |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | YES | | unknown | |
| fa_minor_mime | varchar(32) | YES | | unknown | |
| fa_description | tinyblob | YES | | NULL | |
| fa_user | int(5) unsigned | YES | | 0 | |
| fa_user_text | varchar(255) | YES | | | |
| fa_timestamp | char(14) | YES | | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Indexes
edit| MediaWiki version: | ≥ 1.33 |
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 | | | +-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+