infra/sql/0009_workflow_execution_metadata.sql

Metadata

• Purpose: SQL migration or seed data script for persistent storage.
• Domain: infrastructure
• Language: sql
• Bytes: 697
• Lines: 21
• Content hash (short): 510e11d8
• Source (start): infra/sql/0009_workflow_execution_metadata.sql:1
• Source (end): infra/sql/0009_workflow_execution_metadata.sql:21

Indexed Symbols

No indexed functions/methods detected in this file.

Markdown Headings (if applicable)

No markdown headings detected.

Source Preview

alter table if exists workflow_executions
  add column if not exists input_ref text;

alter table if exists workflow_executions
  add column if not exists output_ref text;

alter table if exists workflow_executions
  add column if not exists evidence_ref text;

alter table if exists workflow_executions
  add column if not exists duration_ms integer;

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

alter table if exists workflow_executions
  add column if not exists failure_code text;

create index if not exists idx_workflow_executions_workspace_status_requested
  on workflow_executions(workspace_id, status, requested_at desc);