Manual:image table

From mediawiki.org
Manual:Contents MediaWiki database layout image table

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

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

Fields[edit]

img_name[edit]

Filename using underscores.

img_size[edit]

File size in bytes.

img_width[edit]

MediaWiki version:
1.5

Image width, in pixels.

img_height[edit]

MediaWiki version:
1.5

Image height, in pixels.

img_metadata[edit]

MediaWiki version:
1.5

Serialized file's properties, as PHP array serialization or as JSON. The json array can contain an address in the text table or external storage. 0, -1 or blank if the extractor fail. T155741

img_bits[edit]

MediaWiki version:
1.5

Bit-depth of GIF/PNG palette-based images (up to 8-bit). Non-palette images (JPEG/PNG/TIFF/SVG) are 0, 8, or 16. All other files default to 0.

img_media_type[edit]

MediaWiki version:
1.5

Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D

img_major_mime[edit]

MediaWiki version:
1.5

Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video

img_minor_mime[edit]

MediaWiki version:
1.5

E.g. jpeg, gif, png, svg+xml, tiff, ogg, pdf vnd.djvu, webm, wav, mpeg, x-flac, midi, x-xcf, sla, webp, etc.

img_description[edit]

MediaWiki version:
1.32

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.

(deprecated); imgcomment_description_id of the image_comment_temp table and the comment table should be used instead!

img_description_id[edit]

MediaWiki version:
1.30

This is a foreign key to comment_id in the comment table.

img_user[edit]

MediaWiki version:
1.33

User ID of the user who uploaded the file.

(deprecated in 1.31) While Actor migration is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the img_actor field instead.

img_user_text[edit]

MediaWiki version:
1.33

User name of the user who uploaded the file.

(deprecated in 1.31) While Actor migration is being done, and depending on the configuration setting $wgActorTableSchemaMigrationStage , this field may be empty and the actor performing the edit can be stored in the img_actor field instead.

img_actor[edit]

MediaWiki version:
1.31

This is a foreign key to actor_id in the actor table and specifies the actor who uploaded the most recent version of the image.

img_timestamp[edit]

Timestamp of when upload took place. Not necessarily the same timestamp as logging.log_timestamp.

Except for image revisions imported from another wiki, the timestamp uniquely identifies the file revision. If two uploads of the same file happen in the same second, the latter one is delayed until it gets a different timestamp.

img_sha1[edit]

MediaWiki version:
1.11

The SHA-1 hash of the file contents in base 36 format. Wikimedia\base_convert() is used to convert from base 16 (hexadecimal) to base 36 and then pad the result to 31 characters.

img_type[edit]

MediaWiki version:
1.4

Schema summary[edit]

MediaWiki version:
1.41

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field              | Type                                                                                                        | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name           | varbinary(255)                                                                                              | NO   | PRI |         |       |
| img_size           | bigint(20) 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','3D') | YES  | MUL | NULL    |       |
| img_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL    |       |
| img_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | NULL    |       |
| img_timestamp      | binary(14)                                                                                                  | NO   | MUL | NULL    |       |
| img_sha1           | varbinary(32)                                                                                               | NO   | MUL |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.36 – 1.40

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field              | Type                                                                                                        | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name           | varbinary(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','3D') | YES  | MUL | NULL    |       |
| img_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL    |       |
| img_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | NULL    |       |
| img_timestamp      | binary(14)                                                                                                  | NO   | MUL | NULL    |       |
| img_sha1           | varbinary(32)                                                                                               | NO   | MUL |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.34 – 1.35

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field              | Type                                                                                                        | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name           | varbinary(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','3D') | YES  | MUL | NULL    |       |
| img_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL    |       |
| img_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | NULL    |       |
| img_timestamp      | varbinary(14)                                                                                               | NO   | MUL |         |       |
| img_sha1           | varbinary(32)                                                                                               | NO   | MUL |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki version:
1.33

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field              | Type                                                                                                        | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name           | varbinary(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','3D') | YES  | MUL | NULL    |       |
| img_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description_id | bigint(20) unsigned                                                                                         | NO   |     | NULL    |       |
| img_user           | int(10) unsigned                                                                                            | NO   | MUL | 0       |       |
| img_user_text      | varbinary(255)                                                                                              | NO   | MUL |         |       |
| img_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | 0       |       |
| img_timestamp      | varbinary(14)                                                                                               | NO   | MUL |         |       |
| img_sha1           | varbinary(32)                                                                                               | NO   | MUL |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.31 – 1.32

DESCRIBE image;

+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field              | Type                                                                                                        | Null | Key | Default | Extra |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name           | varbinary(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','3D') | YES  | MUL | NULL    |       |
| img_major_mime     | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime     | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description    | varbinary(767)                                                                                              | NO   |     |         |       |
| img_description_id | bigint(20) unsigned                                                                                         | NO   |     | 0       |       |
| img_user           | int(10) unsigned                                                                                            | NO   | MUL | 0       |       |
| img_user_text      | varbinary(255)                                                                                              | NO   | MUL |         |       |
| img_actor          | bigint(20) unsigned                                                                                         | NO   | MUL | 0       |       |
| img_timestamp      | varbinary(14)                                                                                               | NO   | MUL |         |       |
| img_sha1           | varbinary(32)                                                                                               | NO   | MUL |         |       |
+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki version:
1.30

DESCRIBE image;

+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                        | Null | Key | Default | Extra |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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','3D') | YES  | MUL | NULL    |       |
| img_major_mime  | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')       | NO   |     | unknown |       |
| img_minor_mime  | varbinary(100)                                                                                              | NO   |     | unknown |       |
| img_description | varbinary(767)                                                                                              | NO   |     |         |       |
| img_user        | int(10) unsigned                                                                                            | NO   | MUL | 0       |       |
| img_user_text   | varbinary(255)                                                                                              | NO   | MUL | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                               | NO   | MUL |         |       |
| img_sha1        | varbinary(32)                                                                                               | NO   | MUL |         |       |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.25 – 1.29

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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  | MUL | NULL    |       |
| img_major_mime  | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')  | NO   |     | unknown |       |
| img_minor_mime  | varbinary(100)                                                                                         | NO   |     | unknown |       |
| img_description | varbinary(767)                                                                                         | NO   |     | NULL    |       |
| img_user        | int(10) unsigned                                                                                       | NO   | MUL | 0       |       |
| img_user_text   | varbinary(255)                                                                                         | NO   | MUL | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                          | NO   | MUL |         |       |
| img_sha1        | varbinary(32)                                                                                          | NO   | MUL |         |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki version:
1.24

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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','chemical')  | NO   |     | unknown |       |
| img_minor_mime  | varbinary(100)                                                                                         | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |       |
| img_sha1        | varbinary(32)                                                                                          | NO   |     | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.16 – 1.23

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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  | varbinary(100)                                                                                         | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |       |
| img_sha1        | varbinary(32)                                                                                          | NO   |     | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.11 – 1.15

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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  | varbinary(32)                                                                                          | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |       |
| img_sha1        | varbinary(32)                                                                                          | NO   |     | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki version:
1.10

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varbinary(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  | varbinary(32)                                                                                          | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
| img_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.5 – 1.9

DESCRIBE image;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varchar(255) binary                                                                                    | 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) binary                                                                                     | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255) binary                                                                                    | NO   |     | NULL    |       |
| img_timestamp   | char(14) binary                                                                                        | NO   | MUL | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
MediaWiki versions:
1.1 – 1.4

DESCRIBE image;

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

Indexes[edit]

MediaWiki version:
1.34

SHOW INDEX IN image;

+-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name            | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| image |          0 | PRIMARY             |            1 | img_name       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_actor_timestamp |            1 | img_actor      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_actor_timestamp |            2 | img_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_size            |            1 | img_size       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_timestamp       |            1 | img_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_sha1            |            1 | img_sha1       | A         |           0 |       10 | NULL   |      | BTREE      |         |               |
| image |          1 | img_media_mime      |            1 | img_media_type | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| image |          1 | img_media_mime      |            2 | img_major_mime | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| image |          1 | img_media_mime      |            3 | img_minor_mime | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+