Manual:filerevision table

From mediawiki.org

Translate this page

This table stores information about revisions of uploaded images and other files. It is part of the replacement of the following old tables: image , oldimage , filearchive

Primary key.

Name of the file.

File to which this revision belongs. Foreign key to the file table.

Size of this file revision, in bytes.

Width of this file revision, in pixels (if appropriate).

Height of this file revision, in pixels (if appropriate).

Extracted Exif metadata stored as a JSON array (new system) or serialized PHP array (old system). The JSON array can contain an address in the text table or external storage.

Bits per pixel of this file revision (if appropriate).

Upload comment for this file revision. Foreign key to the comment table.

Actor who uploaded this file revision. Foreign key to the actor table.

Timestamp for this file revision (in MW timestamp format).

SHA-1 content hash for this file revision, in base-36.

Filename of the archived file. This is generally a timestamp and ! prepended to the base name.

Whether this file revision is deleted.

DESCRIBEfilerevision;

+-------------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+----------------------+------+-----+---------+----------------+
| fr_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| fr_file | bigint(20) | NO | MUL | NULL | |
| fr_size | bigint(20) unsigned | NO | MUL | 0 | |
| fr_width | int(10) unsigned | NO | | 0 | |
| fr_height | int(10) unsigned | NO | | 0 | |
| fr_metadata | mediumblob | NO | | NULL | |
| fr_bits | int(10) unsigned | NO | | 0 | |
| fr_description_id | bigint(20) unsigned | NO | | NULL | |
| fr_actor | bigint(20) unsigned | NO | MUL | NULL | |
| fr_timestamp | binary(14) | NO | MUL | NULL | |
| fr_sha1 | varbinary(32) | NO | MUL | | |
| fr_archive_name | varbinary(255) | NO | | | |
| fr_deleted | smallint(5) unsigned | NO | | NULL | |
+-------------------+----------------------+------+-----+---------+----------------+

SHOWINDEXINfilerevision;

+--------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| filerevision | 0 | PRIMARY | 1 | fr_id | A | 0 | NULL | NULL | | BTREE | | |
| filerevision | 1 | fr_actor_timestamp | 1 | fr_actor | A | 0 | NULL | NULL | | BTREE | | |
| filerevision | 1 | fr_actor_timestamp | 2 | fr_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| filerevision | 1 | fr_size | 1 | fr_size | A | 0 | NULL | NULL | | BTREE | | |
| filerevision | 1 | fr_timestamp | 1 | fr_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| filerevision | 1 | fr_sha1 | 1 | fr_sha1 | A | 0 | 10 | NULL | | BTREE | | |
| filerevision | 1 | fr_file | 1 | fr_file | A | 0 | NULL | NULL | | BTREE | | |
+--------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Filerevision_table&oldid=7930309"