1 CREATE SEQUENCE uploadstash_us_id_seq
;
2 CREATE TYPE media_type
AS ENUM ('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE');
4 CREATE TABLE uploadstash (
5 us_id
INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uploadstash_us_id_seq'),
11 us_timestamp TIMESTAMPTZ
,
16 us_media_type media_type
DEFAULT NULL,
17 us_image_width
INTEGER,
18 us_image_height
INTEGER,
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
);