Manual:uploadstash table
From mediawiki.org
MediaWiki version:
≥ 1.18
The 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.
Fields
[edit ]us_id
[edit ]Primary key.
us_user
[edit ]The user who uploaded the file.
us_key
[edit ]File key. This is how applications actually search for the file. This might go away, or become the primary key.
us_orig_path
[edit ]The original path.
us_path
[edit ]The temporary path at which the file is actually stored.
us_source_type
[edit ]Which type of upload the file came from (sometimes). E.g. "url"
us_timestamp
[edit ]The date/time on which the file was added
us_status
[edit ]E.g. "finished"
us_chunk_inx
[edit ] MediaWiki version:
≥ 1.19
Chunk counter starts at 0, current offset is stored in us_size
us_props
[edit ] MediaWiki version:
≥ 1.21
Serialized file properties from File::getPropsFromPath
us_size
[edit ]File properties from File::getPropsFromPath. These may prove unnecessary.
us_sha1
[edit ]This hash comes from File::sha1Base36(), and is 31 characters
us_mime
[edit ]Combination of img_major_mime and img_minor_mime . E.g., image/png
us_media_type
[edit ]Media type as defined by the MEDIATYPE_xxx constants, should duplicate definition in the image table.
us_image_width
[edit ]Image-specific property.
us_image_height
[edit ]Image-specific property.
us_image_bits
[edit ]Image-specific properties.
Schema summary
[edit ] MediaWiki version:
≥ 1.41
DESCRIBEuploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 | binary(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 | bigint(20) 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 versions:
1.36 – 1.40
DESCRIBEuploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 | binary(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 versions:
1.30 – 1.35
DESCRIBEuploadstash;
+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 versions:
1.21 – 1.29
DESCRIBEuploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 versions:
1.19 – 1.20
DESCRIBEuploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 version:
1.18
DESCRIBEuploadstash;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| 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 | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Indexes
[edit ] MediaWiki version:
≥ 1.18
SHOWINDEXINuploadstash;
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | uploadstash | 0 | PRIMARY | 1 | us_id | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 0 | us_key | 1 | us_key | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 1 | us_user | 1 | us_user | A | 0 | NULL | NULL | | BTREE | | | | uploadstash | 1 | us_timestamp | 1 | us_timestamp | A | 0 | NULL | NULL | | BTREE | | | +-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+