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
FieldsEdit
fa_idEdit
Unique row id.
fa_nameEdit
Original base filename; key to image.img_name , page.page_title , etc.
fa_archive_nameEdit
Filename of archived file, if an old revision, with prepended timestamp. E.g. 20090311210905!Constant_and_setup.png
fa_storage_groupEdit
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_keyEdit
SHA-1 of the file contents plus extension, used as a key for storage. E.g. 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
fa_deleted_userEdit
User who deleted the file
fa_deleted_timestampEdit
Time of deletion, if this file is deleted
fa_deleted_reasonEdit
Deletion comment, if this file is deleted
(deprecated) fa_deleted_reason_id and the comment table should be used instead!
fa_deleted_reason_idEdit
MediaWiki version: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_sizeEdit
File size in bytes. Duplicate of img_size .
fa_widthEdit
Image width, in pixels. Duplicate of img_width .
fa_heightEdit
Image height, in pixels. Duplicate of img_height .
fa_metadataEdit
Serialized PHP array of the file's properties. Duplicate of img_metadata .
fa_bitsEdit
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_typeEdit
Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE
Duplicate of img_media_type .
fa_major_mimeEdit
Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video
Duplicate of img_major_mime .
fa_minor_mimeEdit
E.g. jpeg, gif, png, etc.
Duplicate of img_minor_mime .
fa_descriptionEdit
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_idEdit
MediaWiki version: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_userEdit
User ID of the user who uploaded the file. Duplicate of img_user .
fa_user_textEdit
User name of the user who uploaded the file. Duplicate of img_user_text .
(deprecated in 1.31); Deprecated in favor of fa_actor.
fa_actorEdit
MediaWiki version: | ≥ 1.31 Gerrit change 380669 |
This is a foreign key to actor_id in the actor table.
fa_timestampEdit
Timestamp of when upload took place. Duplicate of img_timestamp .
fa_deletedEdit
MediaWiki version: | ≥ 1.10 |
Visibility of deleted revisions, bitfield.
fa_sha1Edit
MediaWiki version: | ≥ 1.21 |
sha1 hash of file content, encoded in base 36
Schema summaryEdit
MediaWiki version: | ≥ 1.38 |
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 | | | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
IndexesEdit
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 | | | +-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+