Manual:filearchive table
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki database layout | filearchive table |
Contents
- 1 Fields
- 1.1 fa_id
- 1.2 fa_name
- 1.3 fa_archive_name
- 1.4 fa_storage_group
- 1.5 fa_storage_key
- 1.6 fa_deleted_user
- 1.7 fa_deleted_timestamp
- 1.8 fa_deleted_reason
- 1.9 fa_size
- 1.10 fa_width
- 1.11 fa_height
- 1.12 fa_metadata
- 1.13 fa_bits
- 1.14 fa_media_type
- 1.15 fa_major_mime
- 1.16 fa_minor_mime
- 1.17 fa_description
- 1.18 fa_user
- 1.19 fa_user_text
- 1.20 fa_timestamp
- 1.21 fa_deleted
- 1.22 fa_sha1
- 2 Schema
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. Prior to MediaWiki 1.11, this was disabled per default, and Manual:$wgSaveDeletedFiles had to 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
Fields[edit | edit source]
fa_id[edit | edit source]
Unique row id.
fa_name[edit | edit source]
Original base filename; key to image.img_name, page.page_title, etc.
fa_archive_name[edit | edit source]
Filename of archived file, if an old revision, with prepended timestamp. E.g. 20090311210905!Constant_and_setup.png.
fa_storage_group[edit | edit source]
Which storage bin (directory tree or object store) the file data is stored in. Should be 'deleted' for files that have been deleted; any other bin is not yet in use.
fa_storage_key[edit | edit source]
SHA-1 of the file contents plus extension, used as a key for storage. eg 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
fa_deleted_user[edit | edit source]
User who deleted the file, if this file is deleted
fa_deleted_timestamp[edit | edit source]
Time of deletion, if this file is deleted
fa_deleted_reason[edit | edit source]
Deletion comment, if this file is deleted
fa_size[edit | edit source]
File size in bytes. Duplicate of img_size.
fa_width[edit | edit source]
Image width, in pixels. Duplicate of img_width.
fa_height[edit | edit source]
Image height, in pixels. Duplicate of img_height.
fa_metadata[edit | edit source]
Serialized PHP array of the file's properties. Duplicate of img_metadata.
fa_bits[edit | edit source]
Bit-depth of GIF/PNG palette-based images (up to 16-bit). Non-palette images (JPEG/PNG/TIFF/SVG) are 0 or 8. All other files default to 0. Duplicate of img_bits.
fa_media_type[edit | edit source]
Possibilities are UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, and ARCHIVE. Duplicate of img_media_type.
fa_major_mime[edit | edit source]
Possibilities are unknown, application, audio, image, text, video, message, model, and multipart. Duplicate of img_major_mime.
fa_minor_mime[edit | edit source]
E.g. jpeg, gif, png, etc. Duplicate of img_minor_mime.
fa_description[edit | edit source]
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.
fa_user[edit | edit source]
User ID of who uploaded the file. Duplicate of img_user.
fa_user_text[edit | edit source]
User name of who uploaded the file. Duplicate of img_user.
fa_timestamp[edit | edit source]
Timestamp of when upload took place. Duplicate of img_timestamp.
fa_deleted[edit | edit source]
| MediaWiki version: | ≥ 1.10 |
Visibility of deleted revisions, bitfield.
fa_sha1[edit | edit source]
| MediaWiki version: | ≥ 1.21 |
sha1 hash of file content
Schema[edit | edit source]
| MediaWiki version: | ≥ 1.21 |
mysql> 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 | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
22 rows in set (0.00 sec)
| MediaWiki version: | 1.18 |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| 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 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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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.9 |
| MediaWiki version: | 1.8 |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
 Databases |
Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist |
|---|
| Language: | English • 日本語 • polski |
|---|
