-- 1 up
CREATE TABLE IF NOT EXISTS files (
    short text PRIMARY KEY,
    deleted boolean default false,
    mediatype text,
    filename text,
    filesize integer,
    counter integer default 0,
    delete_at_first_view boolean,
    delete_at_day integer,
    created_at integer,
    created_by text,
    last_access_at integer,
    mod_token text,
    nbslices integer,
    complete boolean default false,
    passwd text
);

CREATE TABLE IF NOT EXISTS slices (
    short text NOT NULL REFERENCES files(short) ON DELETE CASCADE,
    j integer NOT NULL,
    path text unique NOT NULL,
    constraint slice_short_j UNIQUE (short, j)
);
-- 1 down
DROP TABLE slices;
DROP TABLE files;