Blame · Line-by-line history

`0102_cross_repo_impact.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.

0102_cross_repo_impact.sqlBlame9 lines · 1 contributor

6ecda8fClaude	1	-- Cross-repo impact cache (15min TTL, cleared on new PR push)
	2	CREATE TABLE IF NOT EXISTS cross_repo_impact_cache (
	3	id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
	4	pr_id uuid NOT NULL REFERENCES pull_requests(id) ON DELETE CASCADE,
	5	report jsonb NOT NULL,
	6	analyzed_at timestamp DEFAULT now(),
	7	cached_until timestamp NOT NULL
	8	);
	9	CREATE INDEX IF NOT EXISTS idx_cross_repo_impact_pr ON cross_repo_impact_cache(pr_id);