-- 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;