Blame · Line-by-line history

`0107_sub_issues.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.

0107_sub_issues.sqlBlame11 lines · 1 contributor

2c61840Claude	1	-- Migration 0107: Sub-issues / epics hierarchy
	2	-- Adds a nullable self-referencing foreign key to `issues` so any issue
	3	-- can be a child of another issue (the parent becomes an "epic").
	4
	5	ALTER TABLE issues
	6	ADD COLUMN parent_issue_id uuid
	7	REFERENCES issues(id)
	8	ON DELETE SET NULL;
	9
	10	CREATE INDEX issues_parent ON issues (parent_issue_id)
	11	WHERE parent_issue_id IS NOT NULL;