Manual:filerevision table

↑ Manual:Contents

MediaWiki database layout

filerevision table

MediaWiki version:

≥ 1.44 Gerrit change 1091477

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

Fields

fr_id

Primary key.

fr_file

Name of the file.

fr_file

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

fr_size

Size of this file revision, in bytes.

fr_width

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

fr_height

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

fr_metadata

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.

fr_bits

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

fr_description_id

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

fr_actor

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

fr_timestamp

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

fr_sha1

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

fr_archive_name

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

fr_deleted

Whether this file revision is deleted.

Schema summary

MediaWiki version:

≥ 1.44 Gerrit change 1091477

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 | | +-------------------+----------------------+------+-----+---------+----------------+ 

Indexes

MediaWiki version:

≥ 1.44 Gerrit change 1091477

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 | | | +--------------+------------+--------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+