Manual:Filearchive table/pl
↑ Podręcznik:Spis treści | Opis i struktura bazy danych MediaWiki | Tabela filearchive |
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
.
Zobacz też:
Manual:Oldimage table
Pola
fa_id
Unique row ID.
fa_name
Original base filename; key to image.img_name , page.page_title , etc.
fa_archive_name
Filename of archived file, if an old revision, with prepended timestamp. E.g. 20090311210905!Constant_and_setup.png
fa_storage_group
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
SHA-1 of the file contents plus extension, used as a key for storage. E.g. 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
fa_deleted_user
User who deleted the file
fa_deleted_timestamp
Time of deletion, if this file is deleted
fa_deleted_reason
Deletion comment, if this file is deleted
(przestarzałe)
fa_deleted_reason_id
and the comment
table should be used instead!
fa_deleted_reason_id
Wersja MediaWiki: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_size
File size in bytes. Duplicate of img_size .
fa_width
Image width, in pixels. Duplicate of img_width .
fa_height
Image height, in pixels. Duplicate of img_height .
fa_metadata
Serialized PHP array of the file's properties. Duplicate of img_metadata .
fa_bits
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
Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
Duplicate of img_media_type .
fa_major_mime
Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video
Duplicate of img_major_mime .
fa_minor_mime
E.g. jpeg, gif, png, etc.
Duplicate of img_minor_mime .
fa_description
Wersja MediaWiki: | ≤ 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 .
(przestarzałe)
fa_description_id
and the comment
table should be used instead!
fa_description_id
Wersja MediaWiki: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
fa_user
User ID of the user who uploaded the file. Duplicate of img_user .
fa_user_text
User name of the user who uploaded the file. Duplicate of img_user_text .
(przestarzałe od 1.31); Deprecated in favor of fa_actor.
fa_actor
Wersja MediaWiki: | ≥ 1.31 Gerrit change 380669 |
This is a foreign key to actor_id in the actor table.
fa_timestamp
Timestamp of when upload took place. Duplicate of img_timestamp .
fa_deleted
Wersja MediaWiki: | ≥ 1.10 |
Visibility of deleted revisions, bitfield.
fa_sha1
Wersja MediaWiki: | ≥ 1.21 |
sha1 hash of file content, encoded in base 36
Schema summary
Wersja MediaWiki: | ≥ 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersja MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersja MediaWiki: | 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 | | | +----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersja MediaWiki: | 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 | | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersje MediaWiki: | 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 | | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersje MediaWiki: | 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 | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersje MediaWiki: | 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 | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
Wersja MediaWiki: | 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 | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Wersje MediaWiki: | 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 | | | | +----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Indeksy
Wersja MediaWiki: | ≥ 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 | | | +-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+