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

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

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

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

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