create_photos.sql

-- +goose Up
CREATE TABLE photos (
    id uuid primary key default uuid_generate_v4() NOT NULL,
    reel_id uuid NOT NULL REFERENCES reels(id),
    path text NOT NULL,
    thumbnail text,
    bytes bigint NOT NULL,
    rev text NOT NULL,
    exif text,
    cleaned boolean NOT NULL default false,
    updated_at timestamp NOT NULL default now(),
    created_at timestamp NOT NULL default now(),
    deleted_at timestamp
);

CREATE UNIQUE INDEX photos_reel_rev ON photos(reel_id, rev);

-- +goose Down
DROP TABLE photos;