Blame · Line-by-line history

`0103_workspace_jobs.sql`

Each line is annotated with the commit that last touched it. Click any SHA to jump to that commit and see the surrounding change.

0103_workspace_jobs.sqlBlame16 lines · 1 contributor

77cf834Claude	1	-- Workspace job persistence (hot path is in-memory; this is for auditability)
	2	CREATE TABLE IF NOT EXISTS workspace_jobs (
	3	id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
	4	repo_id uuid NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	5	issue_id uuid NOT NULL REFERENCES issues(id) ON DELETE CASCADE,
	6	triggered_by uuid REFERENCES users(id),
	7	status text NOT NULL DEFAULT 'pending',
	8	plan_comment text,
	9	branch_name text,
	10	pr_number int,
	11	error_message text,
	12	started_at timestamp DEFAULT now(),
	13	updated_at timestamp DEFAULT now()
	14	);
	15	CREATE INDEX IF NOT EXISTS idx_workspace_jobs_repo ON workspace_jobs(repo_id);
	16	CREATE INDEX IF NOT EXISTS idx_workspace_jobs_issue ON workspace_jobs(issue_id);