Manual:image テーブル
image テーブルでは、画像やその他のアップロードされたファイルを記述します。
しかしながら、画像の説明ページはその他のページと同じように格納されます。
関連項目: 画像の管理
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.
フィールド
img_name
Filename using underscores.
img_size
ファイル サイズ (バイト単位)。
img_width
| MediaWiki バージョン: | ≧ 1.5 |
画像の幅 (ピクセル単位)。
img_height
| MediaWiki バージョン: | ≧ 1.5 |
画像の高さ (ピクセル単位)。
img_metadata
| MediaWiki バージョン: | ≧ 1.5 |
Serialized file's properties as JSON (on older installations as PHP array).
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
| MediaWiki バージョン: | ≧ 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
| MediaWiki バージョン: | ≧ 1.5 |
取り得る値: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D
img_major_mime
| MediaWiki バージョン: | ≧ 1.5 |
取り得る値: unknown, application, audio, chemical, image, message, model, multipart, text, video
img_minor_mime
| MediaWiki バージョン: | ≧ 1.5 |
例: jpeg, gif, png, svg+xml, tiff, ogg, pdf vnd.djvu, webm, wav, mpeg, x-flac, midi, x-xcf, sla, webp, etc.
img_description
| MediaWiki バージョン: | ≦ 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.
(廃止予定); imgcomment_description_id of the image_comment_temp table and the comment table should be used instead!
img_description_id
| MediaWiki バージョン: | ≧ 1.30 |
This is a foreign key to comment_id in the comment table.
img_user
| MediaWiki バージョン: | ≦ 1.33 |
User ID of the user who uploaded the file.
(1.31 で廃止予定)
While 操作者の移行 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
| MediaWiki バージョン: | ≦ 1.33 |
User name of the user who uploaded the file.
(1.31 で廃止予定)
While 操作者の移行 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
| MediaWiki バージョン: | ≧ 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
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
| MediaWiki バージョン: | ≧ 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
| MediaWiki バージョン: | ≦ 1.4 |
スキーマの要約
| MediaWiki バージョン: | ≧ 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 バージョン: | 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 | | +-----------------+---------------------+------+-----+---------+-------+
インデックス
| MediaWiki バージョン: | ≧ 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 | | | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+