Manual:oldimage テーブル
| ↑ Manual:コンテンツ | MediaWiki のデータベース レイアウト | oldimage テーブル |
oldimage テーブルは、ファイルの過去の版についての情報を保持します。
これは、既存のファイルの新しいバージョンがウィキにアップロードされる時に記録されます。
これらのファイルはフォルダー /image/archive に移されます。
Information on deleted images however will not be stored in the oldimage table; on deletion information is moved to the filearchive instead.
関連項目: Manual:filearchive テーブル
フィールド
oi_name
画像の名称 (ファイルと記事、同じであるように思われます)。 img_name に相当します。
oi_archive_name
画像の名称、それが過去の版になった時のタイムスタンプの接頭辞がつけられます
oi_size
ファイル サイズ (バイト単位)。 img_size に相当します。
oi_width
| MediaWiki バージョン: | ≧ 1.5 |
画像の幅 (ピクセル単位)。 img_width に相当します。
oi_height
| MediaWiki バージョン: | ≧ 1.5 |
画像の高さ (ピクセル単位)。 img_height に相当します。
oi_bits
| MediaWiki バージョン: | ≧ 1.5 |
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_bits に相当します。
oi_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. img_description に相当します。
(1.30 で廃止予定) oi_description_id and the comment table should be used instead!
oi_description_id
| MediaWiki バージョン: | ≧ 1.30 |
This is a foreign key to comment_id in the comment table.
oi_user
| MediaWiki バージョン: | ≦ 1.33 |
User ID of the user who uploaded the file. img_user に相当します。
(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 oi_actor field instead.
oi_user_text
| MediaWiki バージョン: | ≦ 1.33 |
元のアップロード者の名前。 img_user_text に相当します。
(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 oi_actor field instead.
oi_actor
| MediaWiki バージョン: | ≧ 1.31 |
This is a foreign key to actor_id in the actor table. img_actor に相当します。
Replaces oi_user and oi_user_text when the 操作者の移行 is done (and enabled with the configuration setting $wgActorTableSchemaMigrationStage in versions 1.31–1.33).
oi_timestamp
元のファイルアップロードのタイムスタンプ。 img_timestamp に相当します。
oi_metadata
| MediaWiki バージョン: | ≧ 1.11 |
Serialized PHP array of the file's properties. img_metadata に相当します。
oi_media_type
| MediaWiki バージョン: | ≧ 1.11 |
Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE
img_media_type に相当します。
oi_major_mime
| MediaWiki バージョン: | ≧ 1.11 |
Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video
img_major_mime に相当します。
oi_minor_mime
| MediaWiki バージョン: | ≧ 1.11 |
例: jpeg, gif, png, etc.
img_minor_mime に相当します。
oi_deleted
| MediaWiki バージョン: | ≧ 1.11 |
Set when the image revision was deleted.
oi_sha1
| MediaWiki バージョン: | ≧ 1.11 |
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. img_sha1 に相当します。
スキーマの要約
| MediaWiki バージョン: | ≧ 1.41 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | bigint(20) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | MUL | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.36 – 1.40 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.34 – 1.35 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_actor | bigint(20) unsigned | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.33 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description_id | bigint(20) unsigned | NO | | NULL | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | | |
| oi_actor | bigint(20) unsigned | NO | MUL | 0 | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.31 – 1.32 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | | |
| oi_description_id | bigint(20) unsigned | NO | | 0 | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | | |
| oi_actor | bigint(20) unsigned | NO | MUL | 0 | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.30 |
DESCRIBE oldimage;
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | | |
| oi_description_id | bigint(20) unsigned | NO | | 0 | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-------------------+-------------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.25 – 1.29 |
DESCRIBE oldimage;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| oi_name | varbinary(255) | NO | MUL | | |
| oi_archive_name | varbinary(255) | NO | | | |
| oi_size | int(10) unsigned | NO | | 0 | |
| oi_width | int(11) | NO | | 0 | |
| oi_height | int(11) | NO | | 0 | |
| oi_bits | int(11) | NO | | 0 | |
| oi_description | varbinary(767) | NO | | NULL | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varbinary(255) | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.24 |
DESCRIBE oldimage;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) binary | NO | MUL | NULL | |
| oi_archive_name | varchar(255) binary | NO | | NULL | |
| oi_size | int(8) unsigned | NO | | 0 | |
| oi_width | int(5) | NO | | 0 | |
| oi_height | int(5) | NO | | 0 | |
| oi_bits | int(3) | NO | | 0 | |
| oi_description | tinyblob | NO | | NULL | |
| oi_user | int(5) unsigned | NO | | 0 | |
| oi_user_text | varchar(255) binary | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.16 – 1.23 |
DESCRIBE oldimage;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) binary | NO | MUL | NULL | |
| oi_archive_name | varchar(255) binary | NO | | NULL | |
| oi_size | int(8) unsigned | NO | | 0 | |
| oi_width | int(5) | NO | | 0 | |
| oi_height | int(5) | NO | | 0 | |
| oi_bits | int(3) | NO | | 0 | |
| oi_description | tinyblob | NO | | NULL | |
| oi_user | int(5) unsigned | NO | | 0 | |
| oi_user_text | varchar(255) binary | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.11 – 1.15 |
DESCRIBE oldimage;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) binary | NO | MUL | NULL | |
| oi_archive_name | varchar(255) binary | NO | | NULL | |
| oi_size | int(8) unsigned | NO | | 0 | |
| oi_width | int(5) | NO | | 0 | |
| oi_height | int(5) | NO | | 0 | |
| oi_bits | int(3) | NO | | 0 | |
| oi_description | tinyblob | NO | | NULL | |
| oi_user | int(5) unsigned | NO | | 0 | |
| oi_user_text | varchar(255) binary | NO | MUL | NULL | |
| oi_timestamp | binary(14) | NO | | NULL | |
| oi_metadata | mediumblob | NO | | NULL | |
| oi_media_type | ENUM('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| oi_major_mime | ENUM('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| oi_minor_mime | varbinary(32) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.10 |
DESCRIBE oldimage;
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | oi_name | varchar(255) binary | NO | MUL | NULL | | | oi_archive_name | varchar(255) binary | NO | | NULL | | | oi_size | int(8) unsigned | NO | | 0 | | | oi_width | int(5) | NO | | 0 | | | oi_height | int(5) | NO | | 0 | | | oi_bits | int(3) | NO | | 0 | | | oi_description | tinyblob | NO | | NULL | | | oi_user | int(5) unsigned | NO | | 0 | | | oi_user_text | varchar(255) binary | NO | | NULL | | | oi_timestamp | binary(14) | NO | | NULL | | +-----------------+---------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.5 – 1.9 |
DESCRIBE oldimage;
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | oi_name | varchar(255) binary | NO | MUL | NULL | | | oi_archive_name | varchar(255) binary | NO | | NULL | | | oi_size | int(8) unsigned | NO | | 0 | | | oi_width | int(5) | NO | | 0 | | | oi_height | int(5) | NO | | 0 | | | oi_bits | int(3) | NO | | 0 | | | oi_description | tinyblob | NO | | NULL | | | oi_user | int(5) unsigned | NO | | 0 | | | oi_user_text | varchar(255) binary | NO | | NULL | | | oi_timestamp | char(14) binary | NO | | NULL | | +-----------------+---------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.1 – 1.4 |
DESCRIBE oldimage;
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | oi_name | varchar(255) binary | NO | MUL | NULL | | | oi_archive_name | varchar(255) binary | NO | | NULL | | | oi_size | int(8) unsigned | NO | | 0 | | | oi_description | tinyblob | NO | | NULL | | | oi_user | int(5) unsigned | NO | | 0 | | | oi_user_text | varchar(255) binary | NO | | NULL | | | oi_timestamp | char(14) binary | NO | | NULL | | +-----------------+---------------------+------+-----+---------+-------+
インデックス
| MediaWiki バージョン: | ≧ 1.34 |
SHOW INDEX IN oldimage;
+----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | oldimage | 1 | oi_actor_timestamp | 1 | oi_actor | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_actor_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_timestamp | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_timestamp | 2 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_archive_name | 1 | oi_name | A | 0 | NULL | NULL | | BTREE | | | | oldimage | 1 | oi_name_archive_name | 2 | oi_archive_name | A | 0 | 14 | NULL | | BTREE | | | | oldimage | 1 | oi_sha1 | 1 | oi_sha1 | A | 0 | 10 | NULL | | BTREE | | | | oldimage | 1 | oi_timestamp | 1 | oi_timestamp | A | 0 | NULL | NULL | | BTREE | | | +----------+------------+----------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+