Manual:uploadstash table
↑ Manual:Contents | MediaWiki database layout | uploadstash table |
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 |
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 | 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 |
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 | 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 |
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 versions: | 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 versions: | 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 version: | 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 | | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
Indexes edit
MediaWiki version: | ≥ 1.18 |
SHOW INDEX IN uploadstash;
+-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +-------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+