Manual:Image table

The image table describes images and other uploaded files. However, the image description pages are stored like other pages. See also: Manual:Image Administration. Many of the fields in this table are analogous to those in the oldimage table. Some of this information was adapted from  in the MediaWiki   directory.

The path for the actual image is not stored in this table: see Manual:$wgHashedUploadDirectory.

img_name
Filename.

img_size
File size in bytes.

img_width
Image width, in pixels.

img_height
Image height, in pixels.

img_metadata
Serialized PHP array of the file's properties.

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

img_media_type
Possibilities are UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, and ARCHIVE.

img_major_mime
Possibilities are unknown, application, audio, image, text, video, message, model, and multipart.

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

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

img_user
User ID of who uploaded the file.

img_user_text
User name of who uploaded the file.

img_timestamp
Timestamp of when upload took place.

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

Versions
mysql> DESCRIBE mimage; +-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+ 14 rows in set (0,00 sec)
 * Field          | Type                                                                                                   | Null | Key | Default | Extra |
 * img_name       | varchar(255)                                                                                           | NO   | PRI |         |       |
 * img_size       | int(10) unsigned                                                                                       | NO   | MUL | 0       |       |
 * img_width      | int(11)                                                                                                | NO   |     | 0       |       |
 * img_height     | int(11)                                                                                                | NO   |     | 0       |       |
 * img_metadata   | mediumblob                                                                                             | NO   |     | NULL    |       |
 * img_bits       | int(11)                                                                                                | NO   |     | 0       |       |
 * img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 * img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 * img_minor_mime | varbinary(100)                                                                                         | NO   |     | unknown |       |
 * img_description | tinyblob                                                                                              | NO   |     | NULL    |       |
 * img_user       | int(10) unsigned                                                                                       | NO   |     | 0       |       |
 * img_user_text  | varchar(255)                                                                                           | NO   | MUL | NULL    |       |
 * img_timestamp  | varbinary(14)                                                                                          | NO   | MUL |         |       |
 * img_sha1       | varbinary(32)                                                                                          | NO   | MUL |         |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * Field          | Type                                                                                                   | Null | Key | Default | Extra |
 * img_name       | varchar(255)                                                                                           | NO   | PRI | NULL    |       |
 * img_size       | int(8) unsigned                                                                                        | NO   | MUL | 0       |       |
 * img_width      | int(5)                                                                                                 | NO   |     | 0       |       |
 * img_height     | int(5)                                                                                                 | NO   |     | 0       |       |
 * img_metadata   | mediumblob                                                                                             | NO   |     | NULL    |       |
 * img_bits       | int(3)                                                                                                 | NO   |     | 0       |       |
 * img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 * img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 * img_minor_mime | varchar(32)                                                                                            | NO   |     | unknown |       |
 * img_description | tinyblob                                                                                              | NO   |     | NULL    |       |
 * img_user       | int(5) unsigned                                                                                        | NO   |     | 0       |       |
 * img_user_text  | varchar(255)                                                                                           | NO   | MUL | NULL    |       |
 * img_timestamp  | char(14)                                                                                               | NO   | MUL | NULL    |       |
 * img_sha1       | varbinary(32)                                                                                          | NO   | MUL | NULL    |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * Field          | Type                                                                                                   | Null | Key | Default | Extra |
 * img_name       | varchar(255)                                                                                           | NO   | PRI | NULL    |       |
 * img_size       | int(10) unsigned                                                                                       | NO   | MUL | 0       |       |
 * img_width      | int(11)                                                                                                | NO   |     | 0       |       |
 * img_height     | int(11)                                                                                                | NO   |     | 0       |       |
 * img_metadata   | mediumblob                                                                                             | NO   |     | NULL    |       |
 * img_bits       | int(11)                                                                                                | NO   |     | 0       |       |
 * img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 * img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 * img_minor_mime | varbinary(32)                                                                                          | NO   |     | unknown |       |
 * img_description | tinyblob                                                                                              | NO   |     | NULL    |       |
 * img_user       | int(10) unsigned                                                                                       | NO   |     | 0       |       |
 * img_user_text  | varchar(255)                                                                                           | NO   | MUL | NULL    |       |
 * img_timestamp  | varbinary(14)                                                                                          | NO   | MUL | NULL    |       |
 * img_sha1       | varbinary(32)                                                                                          | NO   | MUL | NULL    |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * Field          | Type                                                                                                   | Null | Key | Default | Extra |
 * img_name       | varchar(255)                                                                                           | NO   | PRI | NULL    |       |
 * img_size       | int(8) unsigned                                                                                        | NO   | MUL | 0       |       |
 * img_width      | int(5)                                                                                                 | NO   |     | 0       |       |
 * img_height     | int(5)                                                                                                 | NO   |     | 0       |       |
 * img_metadata   | mediumblob                                                                                             | NO   |     | NULL    |       |
 * img_bits       | int(3)                                                                                                 | NO   |     | 0       |       |
 * img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
 * img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
 * img_minor_mime | varchar(32)                                                                                            | NO   |     | unknown |       |
 * img_description | tinyblob                                                                                              | NO   |     | NULL    |       |
 * img_user       | int(5) unsigned                                                                                        | NO   |     | 0       |       |
 * img_user_text  | varchar(255)                                                                                           | NO   |     | NULL    |       |
 * img_timestamp  | char(14)                                                                                               | NO   | MUL | NULL    |       |

+-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field          | Type                | Null | Key | Default | Extra |
 * img_name       | varchar(255) binary |      |     |         |       |
 * img_size       | int(8) unsigned     |      |     | 0       |       |
 * img_description | tinyblob           |      |     |         |       |
 * img_user       | int(5) unsigned     |      |     | 0       |       |
 * img_user_text  | varchar(255) binary |      |     |         |       |
 * img_timestamp  | varchar(14) binary  |      |     |         |       |