sailfork / t3code-github / .repos/ alchemy-effect/ examples/ neon/ migrations/ 0001_uploads.sql

CREATE TABLE uploads (
  id uuid PRIMARY KEY,
  owner_id text NOT NULL,
  object_key text NOT NULL UNIQUE,
  filename text NOT NULL,
  content_type text NOT NULL,
  expected_bytes bigint NOT NULL CHECK (expected_bytes BETWEEN 1 AND 10485760),
  actual_bytes bigint,
  status text NOT NULL DEFAULT 'awaiting_upload'
    CHECK (status IN ('awaiting_upload', 'ready', 'rejected')),
  created_at timestamptz NOT NULL DEFAULT now(),
  processed_at timestamptz
);
CREATE INDEX uploads_owner_created ON uploads (owner_id, created_at DESC);
CREATE TABLE upload_events (
  invocation_id text PRIMARY KEY,
  object_key text NOT NULL,
  processed_at timestamptz NOT NULL DEFAULT now()
);