Blame · Line-by-line history

`0086_explain_cache.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.

0086_explain_cache.sqlBlame10 lines · 1 contributor

0a69faaClaude	1	-- Migration 0077: repo_explain_cache table
	2	-- Stores the structured AI analysis result (JSON) for the "Explain This Repo"
	3	-- feature. Keyed per-repo; replaced on regeneration.
	4	CREATE TABLE IF NOT EXISTS repo_explain_cache (
	5	id serial PRIMARY KEY,
	6	repo_id uuid NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	7	result jsonb NOT NULL,
	8	created_at timestamp DEFAULT now(),
	9	UNIQUE(repo_id)
	10	);