Manual:oldimage table/ja
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki データベース レイアウト | oldimage table/ja |
このテーブルは画像の、過去のリビジョンについての情報を保持します。 これは、既に存在している画像の新しいバージョンが wiki にアップロードされる時に記録されます。これらの画像は /image/archive のフォルダーに移されます。Information on deleted images however will not be stored in the oldimage table; on deletion information is moved to the filearchive instead.
関連項目: Filearchive table/ja
フィールド[edit | edit source]
oi_name[edit | edit source]
画像の名称 (ファイルと記事、同じであるように思われます)。Comparable to img_name.
oi_archive_name[edit | edit source]
画像の名称、それが過去のリビジョンになった時のタイムスタンプの接頭辞がつけられます
oi_size[edit | edit source]
File size in bytes. Comparable to img_size.
oi_width[edit | edit source]
Image width, in pixels. Comparable to img_width.
oi_height[edit | edit source]
Image height, in pixels. Comparable to img_height.
oi_bits[edit | edit source]
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[edit | edit source]
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. Comparable to img_description.
oi_user[edit | edit source]
User ID of who uploaded the file. Comparable to img_user.
oi_user_text[edit | edit source]
元のアップローダーの名前。Comparable to img_user_text.
oi_timestamp[edit | edit source]
元のファイルアップロードのタイムスタンプ。Comparable to img_timestamp.
oi_metadata[edit | edit source]
Serialized PHP array of the file's properties. Comparable to img_metadata.
oi_media_type[edit | edit source]
Possibilities are UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, and ARCHIVE. Comparable to img_media_type.
oi_major_mime[edit | edit source]
Possibilities are unknown, application, audio, image, text, video, message, model, and multipart. Comparable to img_major_mime.
oi_minor_mime[edit | edit source]
E.g. jpeg, gif, png, etc. Comparable to img_minor_mime.
oi_deleted[edit | edit source]
revdeleted
oi_sha1[edit | edit source]
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. Comparable to img_sha1.
スキーマ[edit | edit source]
| MediaWiki バージョン: | 1.19 – 1.20 |
mysql> 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 | tinyblob | 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') | NO | | unknown | |
| oi_minor_mime | varbinary(100) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+----------------+-------+
| MediaWiki バージョン: | 1.18 |
describe oldimage; バージョン 1.18 において:
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varbinary(255) | NO | | | |
| oi_archive_name | varbinary(255) | NO | | | |
| 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 | varbinary(255) | NO | | | |
| oi_timestamp | varbinary(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') | NO | | unknown | |
| oi_minor_mime | varbinary(32) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varbinary(32) | NO | | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.16 |
describe oldimage; バージョン 1.16 において:
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) | NO | | | |
| oi_archive_name | varchar(255) | NO | | | |
| 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) | NO | | | |
| oi_timestamp | varchar(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') | NO | | unknown | |
| oi_minor_mime | varchar(32) | NO | | unknown | |
| oi_deleted | tinyint(3) unsigned | NO | | 0 | |
| oi_sha1 | varchar(32) | NO | | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.12 |
describe oldimage; バージョン 1.12 において:
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) | NO | MUL | NULL | |
| oi_archive_name | varchar(255) | 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) | NO | MUL | NULL | |
| oi_timestamp | char(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.11 |
describe oldimage; バージョン 1.11 において:
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| oi_name | varchar(255) | NO | MUL | NULL | |
| oi_archive_name | varchar(255) | NO | | NULL | |
| 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 | tinyblob | NO | | NULL | |
| oi_user | int(10) unsigned | NO | | 0 | |
| oi_user_text | varchar(255) | 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.9 |
| MediaWiki バージョン: | 1.8 |
describe oldimage; バージョン 1.8 において:
+-----------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------------+------+-----+---------+-------+ | oi_name | varchar(255) | NO | MUL | NULL | | | oi_archive_name | varchar(255) | 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) | NO | | NULL | | | oi_timestamp | char(14) | NO | | NULL | | +-----------------+-----------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.5 |
describe oldimage; バージョン 1.5 において:
+-----------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------------+------+-----+---------+-------+ | oi_name | varchar(255) | NO | MUL | | | | oi_archive_name | varchar(255) | NO | | | | | 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 | | | | | oi_user | int(5) unsigned | NO | | 0 | | | oi_user_text | varchar(255) | NO | | | | | oi_timestamp | char(14) | NO | | | | +-----------------+-----------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.4 |
describe oldimage; バージョン 1.4 において:
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | oi_name | varchar(255) binary | | MUL | | | | oi_archive_name | varchar(255) binary | | | | | | oi_size | int(8) unsigned | | | 0 | | | oi_description | tinyblob | | | | | | oi_user | int(5) unsigned | | | 0 | | | oi_user_text | varchar(255) binary | | | | | | oi_timestamp | varchar(14) binary | | | | | +-----------------+---------------------+------+-----+---------+-------+
 データベース |
エンジン: MySQL – PostgreSQL – SQLite 技術文書: スキーマ (テーブル) – API property associations – フィールド接頭辞 – Primary key storage in other fields – ウィキメディアの拡張機能の表 /en 設定: 設定 – 共有 /en 開発: アクセス – 最適化 /en – Policy /en – 更新プログラム – 拡張機能スキーマの更新 /en – パッチ ファイル /en コア テーブル: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist |
|---|
| 言語: | English • 日本語 |
|---|
