Blame · Line-by-line history

`0088_releases_changelog.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.

0088_releases_changelog.sqlBlame22 lines · 1 contributor

6e41e81Claude	1	-- Migration 0077: ensure the releases table and its index exist.
	2	-- The table was first created in 0001_green_ecosystem.sql; this migration
	3	-- is a no-op guard so the AI Changelog Generator feature can declare its
	4	-- own dependency cleanly, and so fresh deploys from a stripped-down seed
	5	-- always get the table even if 0001 is re-run in a different order.
	6
	7	CREATE TABLE IF NOT EXISTS releases (
	8	id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
	9	repository_id uuid NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	10	author_id uuid NOT NULL REFERENCES users(id),
	11	tag text NOT NULL,
	12	name text NOT NULL,
	13	body text,
	14	target_commit text NOT NULL,
	15	is_draft boolean DEFAULT false NOT NULL,
	16	is_prerelease boolean DEFAULT false NOT NULL,
	17	created_at timestamp DEFAULT now() NOT NULL,
	18	published_at timestamp,
	19	UNIQUE(repository_id, tag)
	20	);
	21
	22	CREATE INDEX IF NOT EXISTS releases_repo ON releases(repository_id, created_at DESC);