Manual:image table
| ↑ 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
editimg_name
editFilename using underscores.
img_size
editFile 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
editTimestamp 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 | | | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+