summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-uploadstash.sql
blob: 8fd9fb99e832891f7846d909b50ad0c88d4adc1e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
CREATE SEQUENCE uploadstash_us_id_seq;
CREATE TYPE media_type AS ENUM ('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE');

CREATE TABLE uploadstash (
  us_id           INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uploadstash_us_id_seq'),
  us_user         INTEGER,
  us_key		  TEXT,
  us_orig_path    TEXT,
  us_path		  TEXT,
  us_source_type  TEXT,
  us_timestamp	  TIMESTAMPTZ,
  us_status		  TEXT,
  us_size		  INTEGER,
  us_sha1		  TEXT,
  us_mime		  TEXT,
  us_media_type	  media_type DEFAULT NULL,
  us_image_width  INTEGER,
  us_image_height INTEGER,
  us_image_bits   INTEGER
);

CREATE INDEX us_user_idx ON uploadstash (us_user);
CREATE UNIQUE INDEX us_key_idx ON uploadstash (us_key);
CREATE INDEX us_timestamp_idx ON uploadstash (us_timestamp);