maintenance/archives/patch-uploadstash.sql

   1 --
   2 -- Store information about newly uploaded files before they're
   3 -- moved into the actual filestore
   4 --
   5 CREATE TABLE /*_*/uploadstash (
   6         us_id int unsigned NOT NULL PRIMARY KEY auto_increment,
   7
   8         -- the user who uploaded the file.
   9         us_user int unsigned NOT NULL,
  10
  11         -- file key. this is how applications actually search for the file.
  12         -- this might go away, or become the primary key.
  13         us_key varchar(255) NOT NULL,
  14
  15         -- the original path
  16         us_orig_path varchar(255) NOT NULL,
  17
  18         -- the temporary path at which the file is actually stored
  19         us_path varchar(255) NOT NULL,
  20
  21         -- which type of upload the file came from (sometimes)
  22         us_source_type varchar(50),
  23
  24         -- the date/time on which the file was added
  25         us_timestamp varbinary(14) not null,
  26
  27         us_status varchar(50) not null,
  28
  29         -- file properties from FSFile::getProps().  these may prove unnecessary.
  30         --
  31         us_size int unsigned NOT NULL,
  32         -- this hash comes from FSFile::getSha1Base36(), and is 31 characters
  33         us_sha1 varchar(31) NOT NULL,
  34         us_mime varchar(255),
  35         -- Media type as defined by the MEDIATYPE_xxx constants, should duplicate definition in the image table
  36         us_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL,
  37         -- image-specific properties
  38         us_image_width int unsigned,
  39         us_image_height int unsigned,
  40         us_image_bits smallint unsigned
  41 ) /*$wgDBTableOptions*/;
  42
  43 -- sometimes there's a delete for all of a user's stuff.
  44 CREATE INDEX /*i*/us_user ON /*_*/uploadstash (us_user);
  45 -- pick out files by key, enforce key uniqueness
  46 CREATE UNIQUE INDEX /*i*/us_key ON /*_*/uploadstash (us_key);
  47 -- the abandoned upload cleanup script needs this
  48 CREATE INDEX /*i*/us_timestamp ON /*_*/uploadstash (us_timestamp);