patch-uploadstash.sql 805 B

12345678910111213141516171819202122232425
  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. CREATE TABLE uploadstash (
  4. us_id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uploadstash_us_id_seq'),
  5. us_user INTEGER,
  6. us_key TEXT,
  7. us_orig_path TEXT,
  8. us_path TEXT,
  9. us_source_type TEXT,
  10. us_timestamp TIMESTAMPTZ,
  11. us_status TEXT,
  12. us_size INTEGER,
  13. us_sha1 TEXT,
  14. us_mime TEXT,
  15. us_media_type media_type DEFAULT NULL,
  16. us_image_width INTEGER,
  17. us_image_height INTEGER,
  18. us_image_bits INTEGER
  19. );
  20. CREATE INDEX us_user_idx ON uploadstash (us_user);
  21. CREATE UNIQUE INDEX us_key_idx ON uploadstash (us_key);
  22. CREATE INDEX us_timestamp_idx ON uploadstash (us_timestamp);