Manual:Uploadstash table

The uploadstash table stores information about newly uploaded files before they're moved into the actual filestore, see also .

It contains information on incomplete uploads; these can e.g. happen when the user left the upload page before the upload completed.

The  maintenance script can be used to remove orphaned entries from this table.

us_id
Primary key.

us_user
The man>Special:MyLanguage/Manual:user table#user_id|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).

E.g. "url"

us_timestamp
The date/time on which the file was added

us_status
E.g. "finished"

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

us_props
Serialized file properties from File::getPropsFromPath

us_size
File properties from .

These may prove unnecessary.

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

us_mime
Combination of  and .

E.g., image/png

us_media_type
Media type as defined by the MEDIATYPE_xxx constants, should duplicate man>Special:MyLanguage/Manual:image table#img_media_type|definition in the image table.

us_image_width
Image-specific property.

us_image_height
Image-specific property.

us_image_bits
Image-specific properties.

Schema summary
<tt>DESCRIBE uploadstash;</tt> +-++--+-+-++ +-++--+-+-++ +-++--+-+-++
 * 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         | varchar(255)                                                                                           | NO   | UNI | NULL    |                |
 * us_orig_path   | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_path        | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_source_type | varchar(50)                                                                                            | YES  |     | NULL    |                |
 * us_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
 * us_status      | varchar(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        | varchar(31)                                                                                            | NO   |     | NULL    |                |
 * us_mime        | varchar(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    |                |

<tt>DESCRIBE uploadstash;</tt> +-++--+-+-++ +-++--+-+-++ +-++--+-+-++
 * 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         | varchar(255)                                                                                           | NO   | UNI | NULL    |                |
 * us_orig_path   | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_path        | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_source_type | varchar(50)                                                                                            | YES  |     | NULL    |                |
 * us_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
 * us_status      | varchar(50)                                                                                            | NO   |     | NULL    |                |
 * us_chunk_inx   | int(10) unsigned                                                                                       | YES  |     | NULL    |                |
 * us_size        | int(10) unsigned                                                                                       | NO   |     | NULL    |                |
 * us_sha1        | varchar(31)                                                                                            | NO   |     | NULL    |                |
 * us_mime        | varchar(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    |                |

<tt>DESCRIBE uploadstash;</tt> +-++--+-+-++ +-++--+-+-++ +-++--+-+-++
 * 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         | varchar(255)                                                                                           | NO   | UNI | NULL    |                |
 * us_orig_path   | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_path        | varchar(255)                                                                                           | NO   |     | NULL    |                |
 * us_source_type | varchar(50)                                                                                            | YES  |     | NULL    |                |
 * us_timestamp   | varbinary(14)                                                                                          | NO   | MUL | NULL    |                |
 * us_status      | varchar(50)                                                                                            | NO   |     | NULL    |                |
 * us_size        | int(10) unsigned                                                                                       | NO   |     | NULL    |                |
 * us_sha1        | varchar(31)                                                                                            | NO   |     | NULL    |                |
 * us_mime        | varchar(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    |                |