You've already forked agentic-coding-workflow
19 lines
772 B
SQL
19 lines
772 B
SQL
-- commit_summaries: auto-generated commit / PR markdown summaries.
|
|
CREATE TABLE commit_summaries (
|
|
id uuid PRIMARY KEY,
|
|
workspace_id uuid NOT NULL REFERENCES workspaces(id) ON DELETE CASCADE,
|
|
worktree_id uuid NULL,
|
|
branch text NOT NULL,
|
|
commit_sha text NOT NULL,
|
|
kind text NOT NULL DEFAULT 'commit' CHECK (kind IN ('commit','pr')),
|
|
title text,
|
|
body_md text NOT NULL,
|
|
model text,
|
|
status text NOT NULL DEFAULT 'pending' CHECK (status IN ('pending','completed','failed')),
|
|
error text,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
UNIQUE (workspace_id, commit_sha, kind)
|
|
);
|
|
|
|
CREATE INDEX idx_commit_summaries_ws ON commit_summaries (workspace_id, commit_sha);
|