Blame · Line-by-line history

`0104_repo_health_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.

0104_repo_health_cache.sqlBlame9 lines · 1 contributor

77cf834Claude	1	CREATE TABLE IF NOT EXISTS repo_health_cache (
	2	id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
	3	repo_id uuid NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	4	score int NOT NULL,
	5	breakdown jsonb NOT NULL,
	6	computed_at timestamp DEFAULT now(),
	7	expires_at timestamp NOT NULL
	8	);
	9	CREATE UNIQUE INDEX IF NOT EXISTS idx_repo_health_cache_repo ON repo_health_cache(repo_id);