Files
mtusi2026lab5/migrations/005_attachment_jobs.sql
2026-11-06 18:45:08 +03:00

24 lines
1001 B
SQL

ALTER TABLE attachments
ADD COLUMN updated_at timestamptz NOT NULL DEFAULT clock_timestamp(),
ADD COLUMN status text NOT NULL DEFAULT 'ready'
CHECK (status IN ('queued', 'processing', 'ready', 'failed')),
ADD COLUMN staging_key text,
ADD COLUMN variants jsonb NOT NULL DEFAULT '[]',
ADD COLUMN error_code text;
ALTER TABLE attachments ALTER COLUMN status SET DEFAULT 'queued';
CREATE TABLE attachment_jobs (
id uuid PRIMARY KEY,
attachment_id uuid NOT NULL UNIQUE REFERENCES attachments(id),
pipeline_version bigint NOT NULL DEFAULT 1 CHECK (pipeline_version = 1),
attempt bigint NOT NULL DEFAULT 0,
failures bigint NOT NULL DEFAULT 0,
available_at timestamptz NOT NULL DEFAULT now(),
published_at timestamptz,
lease_until timestamptz,
lease_token uuid,
created_at timestamptz NOT NULL DEFAULT clock_timestamp(),
replay_audit jsonb NOT NULL DEFAULT '[]'
);
CREATE INDEX attachment_jobs_due_idx ON attachment_jobs(available_at);