forked from mtusi2026/mtusi2026lab6
24 lines
1001 B
SQL
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);
|