Blame · Line-by-line history

`0096_recurring_patterns.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.

0096_recurring_patterns.sqlBlame14 lines · 1 contributor

34e63b9Claude	1	CREATE TABLE IF NOT EXISTS recurring_patterns (
	2	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
	3	repository_id UUID NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	4	title TEXT NOT NULL,
	5	occurrences INTEGER NOT NULL DEFAULT 1,
	6	commit_shas JSONB NOT NULL DEFAULT '[]',
	7	root_cause_hypothesis TEXT,
	8	suggested_file TEXT,
	9	severity TEXT NOT NULL DEFAULT 'medium',
	10	detected_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
	11	expires_at TIMESTAMPTZ NOT NULL DEFAULT NOW() + INTERVAL '24 hours'
	12	);
	13	CREATE INDEX IF NOT EXISTS idx_recurring_patterns_repo ON recurring_patterns(repository_id);
	14	CREATE INDEX IF NOT EXISTS idx_recurring_patterns_expires ON recurring_patterns(expires_at);