Filearchive table
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki database layout | Filearchive table |
The filearchive table stores all the media that has been deleted, similar to the archive table's job for text. This is the table that makes image undeletion possible. Prior to MediaWiki 1.11, this was disabled per default, and Manual:$wgSaveDeletedFiles must be set to true to enable it. Since version 1.11, the behavior is controlled by $wgFileStore, and deleted files are per default stored in $wgUploadDirectory/deleted.
See also: Oldimage table
| MediaWiki version: | 1.8 |
DESCRIBE filearchive in MediaWiki 1.8 gives the following:
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varchar(255) | NO | MUL | NULL | |
| fa_archive_name | varchar(255) | YES | | NULL | |
| fa_storage_group | varchar(16) | YES | MUL | NULL | |
| fa_storage_key | varchar(64) | YES | | NULL | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | char(14) | YES | MUL | NULL | |
| 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 version: | 1.9 |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varchar(255) | NO | MUL | NULL | |
| fa_archive_name | varchar(255) | YES | | NULL | |
| fa_storage_group | varchar(16) | YES | MUL | NULL | |
| fa_storage_key | varchar(64) | YES | | NULL | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | char(14) | YES | MUL | NULL | |
| 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 version: | 1.11 |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varchar(255) | NO | MUL | NULL | |
| fa_archive_name | varchar(255) | YES | | NULL | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | NULL | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | binary(14) | YES | MUL | NULL | |
| fa_deleted_reason | text | 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 | varchar(255) | YES | | NULL | |
| fa_timestamp | binary(14) | YES | | NULL | |
| fa_deleted | tinyint(3) | NO | | 0 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| MediaWiki version: | 1.12 |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| fa_id | int(11) | NO | PRI | NULL | auto_increment |
| fa_name | varchar(255) | NO | MUL | NULL | |
| fa_archive_name | varchar(255) | YES | | NULL | |
| fa_storage_group | varbinary(16) | YES | MUL | NULL | |
| fa_storage_key | varbinary(64) | YES | | NULL | |
| fa_deleted_user | int(11) | YES | MUL | NULL | |
| fa_deleted_timestamp | char(14) | YES | MUL | NULL | |
| 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 | |
| fa_deleted | tinyint(1) unsigned | NO | | 0 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
