infra/sql/0008_job_metadata.sql

Metadata

• Purpose: SQL migration or seed data script for persistent storage.
• Domain: infrastructure
• Language: sql
• Bytes: 1227
• Lines: 41
• Content hash (short): e8705977
• Source (start): infra/sql/0008_job_metadata.sql:1
• Source (end): infra/sql/0008_job_metadata.sql:41

Indexed Symbols

No indexed functions/methods detected in this file.

Markdown Headings (if applicable)

No markdown headings detected.

Source Preview

alter table if exists background_jobs
  add column if not exists queued_at timestamptz;

alter table if exists background_jobs
  add column if not exists started_at timestamptz;

alter table if exists background_jobs
  add column if not exists completed_at timestamptz;

alter table if exists background_jobs
  add column if not exists error_code text;

alter table if exists background_jobs
  add column if not exists error_message text;

alter table if exists background_jobs
  add column if not exists artifact_url text;

alter table if exists background_jobs
  add column if not exists retry_count integer not null default 0;

update background_jobs
   set queued_at = created_at
 where queued_at is null;