Příručka:Databázová tabulka filearchive
| ↑ Manuál:Obsah | MediaWiki schéma databáze | Tabulka filearchive |
Tabulka filearchive ukládá informace o všech médiích, která byla odstraněna, podobně jako úloha tabulky archive pro revizi odstraněného textu.
Tyto soubory jsou umístěny v úložišti pro smazané soubory. V místním úložišti je to s největší pravděpodobností složka images/deleted/.
Toto je tabulka, která umožňuje obnovení obrázku.
Smazané soubory jsou uloženy na místě definovaném $wgDeletedDirectory, což je výchozí $wgUploadDirectory/deleted.
Související odkazy:
Příručka:Databázová tabulka oldimage
Pole
fa_id
Jedinečné ID řádku.
fa_name
Původní základní název souboru. Klíč k image.img_name, page.page_title atd.
fa_archive_name
Název archivovaného souboru, pokud se jedná o starou revizi, s předřazeným časovým razítkem. Například 20090311210905!Constant_and_setup.png
fa_storage_group
Ve které přihrádce (stromu adresářů nebo úložišti objektů) jsou data souboru uložena. Měl by být 'smazán' pro soubory, které byly odstraněny. Žádný jiný zásobník se zatím nepoužívá.
fa_storage_key
SHA-1 obsahu souboru plus přípona, používaný jako klíč pro ukládání. Například 8f8a562add37052a1848ff7771a2c515db94baa9.jpg
fa_deleted_user
Uživatel, který soubor smazal
fa_deleted_timestamp
Čas smazání, pokud je tento soubor smazán
fa_deleted_reason
Komentář k odstranění, pokud je tento soubor smazán
(zastaralé)
fa_deleted_reason_id a místo toho by měla být použita tabulka comment!
fa_deleted_reason_id
| Verze MediaWiki: | ≥ 1.30 |
Toto je cizí klíč k comment_id v tabulce comment.
fa_size
Velikost souboru v bajtech. Duplikát img_size.
fa_width
Šířka obrázku, v pixelech. Duplikát img_width.
fa_height
Výška obrázku, v pixelech. Duplikát img_height.
fa_metadata
Serializované pole PHP vlastností souboru. Duplikát img_metadata.
fa_bits
Bitová hloubka obrázků založených na paletě GIF/PNG (až 16 bitů). Obrázky bez palety (JPEG/PNG/TIFF/SVG) mají hodnotu 0 nebo 8. Všechny ostatní soubory mají výchozí hodnotu 0. Duplikát img_bits.
fa_media_type
Možnosti jsou: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
Duplikát img_media_type.
fa_major_mime
Možnosti jsou: unknown, application, audio, chemical, image, message, model, multipart, text, video
Duplikát img_major_mime.
fa_minor_mime
Například jpeg, gif, png, etc.
Duplikát img_minor_mime.
fa_description
| Verze MediaWiki: | ≤ 1.32 |
Pole popisu zadané během nahrávání. Není to popisná stránka (související File: stránka wiki), ale "souhrn" poskytnutý uživatelem v případě opětovného nahrání. Duplikát img_description.
(zastaralé)
Místo toho je třeba použít fa_description_id a tabulku comment!
fa_description_id
| Verze MediaWiki: | ≥ 1.30 |
Toto je cizí klíč k comment_id v tabulce comment.
fa_user
ID uživatele, který soubor nahrál. Duplikát img_user.
fa_user_text
Uživatelské jméno uživatele, který nahrál soubor. Duplikát img_user_text.
(zastaralé od 1.31); Ukončeno ve prospěch fa_actor.
fa_actor
| Verze MediaWiki: | ≥ 1.31 Gerrit change 380669 |
Toto je cizí klíč k actor_id v tabulce actor.
fa_timestamp
Časové razítko, kdy došlo k nahrání. Duplikát img_timestamp.
fa_deleted
| Verze MediaWiki: | ≥ 1.10 |
Viditelnost smazaných revizí, bitové pole.
fa_sha1
| Verze MediaWiki: | ≥ 1.21 |
sha1 hash obsahu souboru, zakódovaný v základu 36
Přehled změn ve schématu tabulky
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+----------------+
| Verze 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 | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Verze 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 | | | |
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Indexy
| Verze 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 | | | +-------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+