Manual:Oldimage table

From MediaWiki.org
Jump to: navigation, search
Manual:Contents MediaWiki database layout Oldimage table


This 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.

See also: Filearchive table

[edit] Fields

oi_name
name of the image (file and article, seems to be the same)
oi_archive_name
name of the image, prefixed by a timestamp of the time where it became an old revision
oi_size
 ??
oi_width
 ??
oi_height
 ??
oi_bits
 ??
oi_description
 ??
oi_user
 ??
oi_user_text
name of original uploader
oi_timestamp
timestamp of original file upload
oi_metadata
 ??
oi_media_type
 ??
oi_major_mime
 ??
oi_minor_mime
 ??
oi_deleted
 ??
oi_sha1
 ??


MediaWiki version: 1.18

describe oldimage; in version 1.18

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name         | varbinary(255)                                                                                         | NO   |     |         |       |
| oi_archive_name | varbinary(255)                                                                                         | NO   |     |         |       |
| 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    | varbinary(255)                                                                                         | NO   |     |         |       |
| oi_timestamp    | varbinary(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')             | NO   |     | unknown |       |
| oi_minor_mime   | varbinary(32)                                                                                          | NO   |     | unknown |       |
| oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0       |       |
| oi_sha1         | varbinary(32)                                                                                          | NO   |     |         |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+


MediaWiki version: 1.16

describe oldimage; in version 1.16

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name         | varchar(255)                                                                                           | NO   |     |         |       |
| oi_archive_name | varchar(255)                                                                                           | NO   |     |         |       |
| 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)                                                                                           | NO   |     |         |       |
| oi_timestamp    | varchar(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')             | NO   |     | unknown |       |
| oi_minor_mime   | varchar(32)                                                                                            | NO   |     | unknown |       |
| oi_deleted      | tinyint(3) unsigned                                                                                    | NO   |     | 0       |       |
| oi_sha1         | varchar(32)                                                                                            | NO   |     |         |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+


MediaWiki version: 1.12

describe oldimage; in version 1.12:

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name         | varchar(255)                                                                                           | NO   | MUL | NULL    |       |
| oi_archive_name | varchar(255)                                                                                           | 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)                                                                                           | NO   | MUL | NULL    |       |
| oi_timestamp    | char(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.11

describe oldimage; in version 1.11:

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name         | varchar(255)                                                                                           | NO   | MUL | NULL    |       |
| oi_archive_name | varchar(255)                                                                                           | NO   |     | NULL    |       |
| 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  | tinyblob                                                                                               | NO   |     | NULL    |       |
| oi_user         | int(10) unsigned                                                                                       | NO   |     | 0       |       |
| oi_user_text    | varchar(255)                                                                                           | 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.9
MediaWiki version: 1.8

describe oldimage; in version 1.8:

+-----------------+-----------------+------+-----+---------+-------+
| Field           | Type            | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| oi_name         | varchar(255)    | NO   | MUL | NULL    |       |
| oi_archive_name | varchar(255)    | 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)    | NO   |     | NULL    |       |
| oi_timestamp    | char(14)        | NO   |     | NULL    |       |
+-----------------+-----------------+------+-----+---------+-------+


MediaWiki version: 1.5

describe oldimage; in version 1.5:

+-----------------+-----------------+------+-----+---------+-------+
| Field           | Type            | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| oi_name         | varchar(255)    | NO   | MUL |         |       |
| oi_archive_name | varchar(255)    | NO   |     |         |       |
| 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   |     |         |       |
| oi_user         | int(5) unsigned | NO   |     | 0       |       |
| oi_user_text    | varchar(255)    | NO   |     |         |       |
| oi_timestamp    | char(14)        | NO   |     |         |       |
+-----------------+-----------------+------+-----+---------+-------+


MediaWiki version: 1.4

describe oldimage; in version 1.4:

 +-----------------+---------------------+------+-----+---------+-------+
 | Field           | Type                | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary |      | MUL |         |       |
 | oi_archive_name | varchar(255) binary |      |     |         |       |
 | oi_size         | int(8) unsigned     |      |     | 0       |       |
 | oi_description  | tinyblob            |      |     |         |       |
 | oi_user         | int(5) unsigned     |      |     | 0       |       |
 | oi_user_text    | varchar(255) binary |      |     |         |       |
 | oi_timestamp    | varchar(14) binary  |      |     |         |       |
 +-----------------+---------------------+------+-----+---------+-------+
Language: English  • 日本語
Personal tools
Namespaces

Variants
Actions
Navigation
Support
Download
Development
Communication
Print/export
Toolbox