sql.migration.V20150422120100__CreateFiles.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of actor-persist Show documentation

actor-persist

There is a newer version: 3.0.0

CREATE TABLE files (
  id bigint NOT NULL,
  access_salt text NOT NULL,
  s3_upload_key text NOT NULL,
  is_uploaded boolean default false NOT NULL,
  PRIMARY KEY (id)
);

CREATE INDEX on files(s3_upload_key);

CREATE TABLE file_parts (
  file_id bigint NOT NULL,
  number int NOT NULL,
  size int NOT NULL,
  s3_upload_key text NOT NULL,
  PRIMARY KEY (file_id, number)
)