Manual: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

oi_name
画像の名称 (ファイルと記事、同じであるように思われます). Comparable to img_name.

oi_archive_name
画像の名称、それが過去のリビジョンになった時のタイムスタンプの接頭辞がつけられます

oi_size
File size in bytes. Comparable to img_size.

oi_width
Image width, in pixels. Comparable to img_width.

oi_height
Image height, in pixels. Comparable to img_height.

oi_bits
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
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.

Deprecated; oi_description_id and the comment table should be used instead!

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

oi_user
User ID of the user who uploaded the file. Comparable to img_user.

oi_user_text
元のアップローダーの名前. Comparable to img_user_text.

oi_timestamp
元のファイルアップロードのタイムスタンプ. Comparable to img_timestamp.

oi_metadata
Serialized PHP array of the file's properties. Comparable to img_metadata.

oi_media_type
Possibilities are UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, and ARCHIVE. Comparable to img_media_type.

oi_major_mime
Possibilities are unknown, application, audio, chemical, image, message, model, multipart, text, and video. Comparable to img_major_mime.

oi_minor_mime
E.g. jpeg, gif, png, etc. Comparable to img_minor_mime.

oi_deleted
revdeleted

oi_sha1
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.

Schema summary
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 | varbinary(767)                                                                                         | 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    |       | +-++--+-+-+---+

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    |       | +-++--+-+-+---+

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    |       | +-++--+-+-+---+

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    |       | +-++--+-+-+---+

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    |       | +-+-+--+-+-+---+

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    |       | +-+-+--+-+-+---+

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    |       | +-+-+--+-+-+---+