Manual:Oldimage table
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki database layout | Oldimage table |
This table holds information about old revisions of images. It will be filled when one uploads a new version of an existing image to the wiki. These images are moved to the folder /image/archive.
See also: Filearchive table
- 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_timestamp
- timestamp of original file upload
- oi_user_text
- name of original uploader
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 | | | | | +-----------------+---------------------+------+-----+---------+-------+
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.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.9
describe oldimage; in version 1.9:
+-----------------+-----------------+------+-----+---------+-------+ | 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.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.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 | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
