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
Unique row ID.
Original base filename; key to image.img_name , page.page_title , etc.
Filename of archived file, if an old revision, with prepended timestamp. E.g. 20090311210905!Constant_and_setup.png
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.
SHA-1 of the file contents plus extension, used as a key for storage. E.g. 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
User who deleted the file
fa_deleted_timestamp[edit]Time of deletion, if this file is deleted
Deletion comment, if this file is deleted
(deprecated) fa_deleted_reason_id and the comment table should be used instead!
≥ 1.30
This is a foreign key to comment_id in the comment table.
File size in bytes. Duplicate of img_size .
Image width, in pixels. Duplicate of img_width .
Image height, in pixels. Duplicate of img_height .
Serialized PHP array of the file's properties. Duplicate of img_metadata .
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 .
Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
Duplicate of img_media_type .
Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video
Duplicate of img_major_mime .
E.g. jpeg, gif, png, etc.
Duplicate of img_minor_mime .
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!
≥ 1.30
This is a foreign key to comment_id in the comment table.
User ID of the user who uploaded the file. Duplicate of img_user .
User name of the user who uploaded the file. Duplicate of img_user_text .
(deprecated in 1.31); Deprecated in favor of fa_actor.
This is a foreign key to actor_id in the actor table.
Timestamp of when upload took place. Duplicate of img_timestamp .
MediaWiki version:≥ 1.10
Visibility of deleted revisions, bitfield.
MediaWiki version:≥ 1.21
sha1 hash of file content, encoded in base 36
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
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 | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
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 | | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
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 | | | +-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4