Jump to content

Manual:oldimage table

From mediawiki.org

Translate this page

Languages:

↑ Manual:Contents MediaWiki database layout oldimage table

The oldimage table holds information about old revisions of files. It will be filled when one uploads a new version of an existing file to the wiki. These files are moved to the folder /image/archive. Information on deleted images however will not be stored in the oldimage table; on deletion information is moved to the filearchive instead.

See also: Manual:Filearchive table

Fields

oi_name

Name of the image (file and article, seems to be the same). Comparable to img_name .

oi_archive_name

Name of the image, prefixed by a timestamp of the time where it became an old revision

oi_size

File size in bytes. Comparable to img_size .

oi_width

MediaWiki version:

≥ 1.5

Image width, in pixels. Comparable to img_width .

oi_height

MediaWiki version:

≥ 1.5

Image height, in pixels. Comparable to img_height .

oi_bits

MediaWiki version:

≥ 1.5

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. Comparable to img_bits .

oi_description

MediaWiki version:

≤ 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. Comparable to img_description .

(deprecated in 1.30) oi_description_id and the comment table should be used instead!

oi_description_id

MediaWiki version:

≥ 1.30

This is a foreign key to comment_id in the comment table.

oi_user

MediaWiki version:

≤ 1.33

User ID of the user who uploaded the file. Comparable to img_user .

(deprecated in 1.31) While Actor migration is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the oi_actor field instead.

oi_user_text

MediaWiki version:

≤ 1.33

Name of original uploader. Comparable to img_user_text .

(deprecated in 1.31) While Actor migration is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the oi_actor field instead.

oi_actor

MediaWiki version:

≥ 1.31

This is a foreign key to actor_id in the actor table. Comparable to img_actor .

Replaces oi_user and oi_user_text when the Actor migration is done (and enabled with the configuration setting $wgActorTableSchemaMigrationStage in versions 1.31–1.33).

oi_timestamp

Timestamp of original file upload. Comparable to img_timestamp .

oi_metadata

MediaWiki version:

≥ 1.11

Serialized PHP array of the file's properties. Comparable to img_metadata .

oi_media_type

MediaWiki version:

≥ 1.11

Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE

Comparable to img_media_type .

oi_major_mime

MediaWiki version:

≥ 1.11

Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video

Comparable to img_major_mime .

oi_minor_mime

MediaWiki version:

≥ 1.11

E.g. jpeg, gif, png, etc.

Comparable to img_minor_mime .

oi_deleted

MediaWiki version:

≥ 1.11

Set when the image revision was deleted.

oi_sha1

MediaWiki version:

≥ 1.11

The SHA-1 hash of the file contents in base 36 format. includes/GlobalFunctions.php's wfBaseConvert is used to convert from base 16 (hexadecimal) to base 36 and then pad the result to 31 characters. Comparable to img_sha1 .

Schema summary

MediaWiki version:

≥ 1.41

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | bigint(20) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | MUL | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

MediaWiki versions:

1.36 – 1.40

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

MediaWiki versions:

1.34 – 1.35

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+

MediaWiki version:

1.33

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | | |
| oi_actor | bigint(20) unsigned | NO | MUL | 0 | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+

MediaWiki versions:

1.31 – 1.32

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | | |
| oi_description_id | bigint(20) unsigned | NO | | 0 | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | | |
| oi_actor | bigint(20) unsigned | NO | MUL | 0 | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+

MediaWiki version:

1.30

DESCRIBEoldimage;

+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | | |
| oi_description_id | bigint(20) unsigned | NO | | 0 | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+

MediaWiki versions:

1.25 – 1.29

DESCRIBEoldimage;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | NULL | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+

MediaWiki version:

1.24

DESCRIBEoldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_width | int(5) | NO | | 0 | |
 | oi_height | int(5) | NO | | 0 | |
 | oi_bits | int(3) | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | MUL | NULL | |
 | oi_timestamp | binary(14) | NO | | NULL | |
 | oi_metadata | mediumblob | NO | | NULL | |
 | oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
 | oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
 | oi_minor_mime | varbinary(100) | NO | | unknown | |
 | oi_deleted | tinyint(3) unsigned | NO | | 0 | |
 | oi_sha1 | varbinary(32) | NO | MUL | NULL | |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

MediaWiki versions:

1.16 – 1.23

DESCRIBEoldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_width | int(5) | NO | | 0 | |
 | oi_height | int(5) | NO | | 0 | |
 | oi_bits | int(3) | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | MUL | NULL | |
 | oi_timestamp | binary(14) | NO | | NULL | |
 | oi_metadata | mediumblob | NO | | NULL | |
 | oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
 | oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
 | oi_minor_mime | varbinary(100) | NO | | unknown | |
 | oi_deleted | tinyint(3) unsigned | NO | | 0 | |
 | oi_sha1 | varbinary(32) | NO | MUL | NULL | |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

MediaWiki versions:

1.11 – 1.15

DESCRIBEoldimage;

 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_width | int(5) | NO | | 0 | |
 | oi_height | int(5) | NO | | 0 | |
 | oi_bits | int(3) | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | MUL | NULL | |
 | oi_timestamp | binary(14) | NO | | NULL | |
 | oi_metadata | mediumblob | NO | | NULL | |
 | oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
 | oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
 | oi_minor_mime | varbinary(32) | NO | | unknown | |
 | oi_deleted | tinyint(3) unsigned | NO | | 0 | |
 | oi_sha1 | varbinary(32) | NO | MUL | NULL | |
 +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

MediaWiki version:

1.10

DESCRIBEoldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_width | int(5) | NO | | 0 | |
 | oi_height | int(5) | NO | | 0 | |
 | oi_bits | int(3) | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | | NULL | |
 | oi_timestamp | binary(14) | NO | | NULL | |
 +-----------------+---------------------+------+-----+---------+-------+

MediaWiki versions:

1.5 – 1.9

DESCRIBEoldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_width | int(5) | NO | | 0 | |
 | oi_height | int(5) | NO | | 0 | |
 | oi_bits | int(3) | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | | NULL | |
 | oi_timestamp | char(14) binary | NO | | NULL | |
 +-----------------+---------------------+------+-----+---------+-------+

MediaWiki versions:

1.1 – 1.4

DESCRIBEoldimage;

 +-----------------+---------------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name | varchar(255) binary | NO | MUL | NULL | |
 | oi_archive_name | varchar(255) binary | NO | | NULL | |
 | oi_size | int(8) unsigned | NO | | 0 | |
 | oi_description | tinyblob | NO | | NULL | |
 | oi_user | int(5) unsigned | NO | | 0 | |
 | oi_user_text | varchar(255) binary | NO | | NULL | |
 | oi_timestamp | char(14) binary | NO | | NULL | |
 +-----------------+---------------------+------+-----+---------+-------+

Indexes

MediaWiki version:

≥ 1.34

SHOWINDEXINoldimage;

+----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| oldimage | 1 | oi_actor_timestamp | 1 | oi_actor | A | 0 | NULL | NULL | | BTREE | | |
| oldimage | 1 | oi_actor_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| oldimage | 1 | oi_name_timestamp | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | |
| oldimage | 1 | oi_name_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| oldimage | 1 | oi_name_archive_name | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | |
| oldimage | 1 | oi_name_archive_name | 2 | oi_archive_name | A | 0 | 14 | NULL | | BTREE | | |
| oldimage | 1 | oi_sha1 | 1 | oi_sha1 | A | 0 | 10 | NULL | | BTREE | | |
| oldimage | 1 | oi_timestamp | 1 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | |
+----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

v
t
e

Engines

Current	MariaDB MySQL PostgreSQL SQLite
Former	Oracle SQL Server

Technical documentation

Configuration

Development

Core tables

Current

Former

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