[Summary view] [Print] [Text view]

   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);