Manual:uploadstash テーブル

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Uploadstash table and the translation is 36% complete.
Other languages:
English • ‎中文 • ‎日本語
Manual:コンテンツ MediaWiki のデータベース レイアウト uploadstash table/ja


MediaWiki バージョン: 1.18

The Manual:UploadStash table stores information about newly uploaded files before they're moved into the actual filestore, see also Manual:UploadStash . It contains information on incomplete uploads; these can e.g. happen when the user left the upload page before the upload completed. The cleanupUploadStash.php maintenance script can be used to remove orphaned entries from this table.

フィールド

us_id

主キー。

us_user

The user who uploaded the file.

us_key

File key. This is how applications actually search for the file. This might go away, or become the primary key.

us_orig_path

The original path.

us_path

The temporary path at which the file is actually stored.

us_source_type

Which type of upload the file came from (sometimes). 例: "url"

us_timestamp

The date/time on which the file was added

us_status

例: "finished"

us_chunk_inx

MediaWiki バージョン: 1.19

Chunk counter starts at 0, current offset is stored in us_size

us_props

MediaWiki バージョン: 1.21

Serialized file properties from File::getPropsFromPath

us_size

File properties from File::getPropsFromPath. These may prove unnecessary.

us_sha1

This hash comes from File::sha1Base36(), and is 31 characters

us_mime

Combination of img_major_mime and img_minor_mime . 例: image/png

us_media_type

Media type as defined by the MEDIATYPE_xxx constants, should duplicate definition in the image table.

us_image_width

画像固有のプロパティ。

us_image_height

画像固有のプロパティ。

us_image_bits

画像固有のプロパティ。

スキーマの要約

MediaWiki バージョン: 1.30

DESCRIBE uploadstash;

+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field           | Type                                                                                                        | Null | Key | Default | Extra          |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id           | int(10) unsigned                                                                                            | NO   | PRI | NULL    | auto_increment |
| us_user         | int(10) unsigned                                                                                            | NO   | MUL | NULL    |                |
| us_key          | varbinary(255)                                                                                              | NO   | UNI | NULL    |                |
| us_orig_path    | varbinary(255)                                                                                              | NO   |     | NULL    |                |
| us_path         | varbinary(255)                                                                                              | NO   |     | NULL    |                |
| us_source_type  | varbinary(50)                                                                                               | YES  |     | NULL    |                |
| us_timestamp    | varbinary(14)                                                                                               | NO   | MUL | NULL    |                |
| us_status       | varbinary(50)                                                                                               | NO   |     | NULL    |                |
| us_chunk_inx    | int(10) unsigned                                                                                            | YES  |     | NULL    |                |
| us_props        | blob                                                                                                        | YES  |     | NULL    |                |
| us_size         | int(10) unsigned                                                                                            | NO   |     | NULL    |                |
| us_sha1         | varbinary(31)                                                                                               | NO   |     | NULL    |                |
| us_mime         | varbinary(255)                                                                                              | YES  |     | NULL    |                |
| us_media_type   | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES  |     | NULL    |                |
| us_image_width  | int(10) unsigned                                                                                            | YES  |     | NULL    |                |
| us_image_height | int(10) unsigned                                                                                            | YES  |     | NULL    |                |
| us_image_bits   | smallint(5) unsigned                                                                                        | YES  |     | NULL    |                |
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
MediaWiki バージョン: 1.21 – 1.29

DESCRIBE uploadstash;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra          |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id           | int(10) unsigned                                                                                       | NO   | PRI | NULL    | auto_increment |
| us_user         | int(10) unsigned                                                                                       | NO   | MUL | NULL    |                |
| us_key          | varbinary(255)                                                                                         | NO   | UNI | NULL    |                |
| us_orig_path    | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_path         | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_source_type  | varbinary(50)                                                                                          | YES  |     | NULL    |                |
| us_timestamp    | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
| us_status       | varbinary(50)                                                                                          | NO   |     | NULL    |                |
| us_chunk_inx    | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_props        | blob                                                                                                   | YES  |     | NULL    |                |
| us_size         | int(10) unsigned                                                                                       | NO   |     | NULL    |                |
| us_sha1         | varbinary(31)                                                                                          | NO   |     | NULL    |                |
| us_mime         | varbinary(255)                                                                                         | YES  |     | NULL    |                |
| us_media_type   | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |                |
| us_image_width  | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_height | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_bits   | smallint(5) unsigned                                                                                   | YES  |     | NULL    |                |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
MediaWiki バージョン: 1.19 – 1.20

DESCRIBE uploadstash;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra          |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id           | int(10) unsigned                                                                                       | NO   | PRI | NULL    | auto_increment |
| us_user         | int(10) unsigned                                                                                       | NO   | MUL | NULL    |                |
| us_key          | varbinary(255)                                                                                         | NO   | UNI | NULL    |                |
| us_orig_path    | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_path         | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_source_type  | varbinary(50)                                                                                          | YES  |     | NULL    |                |
| us_timestamp    | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
| us_status       | varbinary(50)                                                                                          | NO   |     | NULL    |                |
| us_chunk_inx    | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_size         | int(10) unsigned                                                                                       | NO   |     | NULL    |                |
| us_sha1         | varbinary(31)                                                                                          | NO   |     | NULL    |                |
| us_mime         | varbinary(255)                                                                                         | YES  |     | NULL    |                |
| us_media_type   | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |                |
| us_image_width  | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_height | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_bits   | smallint(5) unsigned                                                                                   | YES  |     | NULL    |                |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
MediaWiki バージョン: 1.18

DESCRIBE uploadstash;

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra          |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| us_id           | int(10) unsigned                                                                                       | NO   | PRI | NULL    | auto_increment |
| us_user         | int(10) unsigned                                                                                       | NO   | MUL | NULL    |                |
| us_key          | varbinary(255)                                                                                         | NO   | UNI | NULL    |                |
| us_orig_path    | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_path         | varbinary(255)                                                                                         | NO   |     | NULL    |                |
| us_source_type  | varbinary(50)                                                                                          | YES  |     | NULL    |                |
| us_timestamp    | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
| us_status       | varbinary(50)                                                                                          | NO   |     | NULL    |                |
| us_size         | int(10) unsigned                                                                                       | NO   |     | NULL    |                |
| us_sha1         | varbinary(31)                                                                                          | NO   |     | NULL    |                |
| us_mime         | varbinary(255)                                                                                         | YES  |     | NULL    |                |
| us_media_type   | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |                |
| us_image_width  | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_height | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
| us_image_bits   | smallint(5) unsigned                                                                                   | YES  |     | NULL    |                |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+