maintenance/postgres/archives/patch-uploadstash.sql

   1 CREATE SEQUENCE uploadstash_us_id_seq;
   2 CREATE TYPE media_type AS ENUM ('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE');
   3
   4 CREATE TABLE uploadstash (
   5   us_id           INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uploadstash_us_id_seq'),
   6   us_user         INTEGER,
   7   us_key                  TEXT,
   8   us_orig_path    TEXT,
   9   us_path                 TEXT,
  10   us_source_type  TEXT,
  11   us_timestamp    TIMESTAMPTZ,
  12   us_status               TEXT,
  13   us_size                 INTEGER,
  14   us_sha1                 TEXT,
  15   us_mime                 TEXT,
  16   us_media_type   media_type DEFAULT NULL,
  17   us_image_width  INTEGER,
  18   us_image_height INTEGER,
  19   us_image_bits   INTEGER
  20 );
  21
  22 CREATE INDEX us_user_idx ON uploadstash (us_user);
  23 CREATE UNIQUE INDEX us_key_idx ON uploadstash (us_key);
  24 CREATE INDEX us_timestamp_idx ON uploadstash (us_timestamp);