Manual:Oldimage table

This table holds information about old revisions of images. It will be filled when one uploads a new version of an image to the wiki. These images are moved to the folder /image/archive.

Note: MediaWiki does not by default keep deleted revisions of articles. To enable undeletion of images take a look at the parameter $wgFileStore.


 * 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

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

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

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

mysql> describe mw_oldimage; +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+ 10 rows in set (0.00 sec)
 * 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    |       |