max / makenotwork

815 B · 17 lines History Blame Raw

1	-- Project sections: tabbed markdown content blocks within projects.
2	-- Mirrors item_sections (migration 054) but scoped to projects, for content
3	-- that applies across all platform releases (privacy policy, terms, FAQ, etc).
4	CREATE TABLE project_sections (
5	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
6	project_id UUID NOT NULL REFERENCES projects(id) ON DELETE CASCADE,
7	title VARCHAR(100) NOT NULL,
8	slug VARCHAR(120) NOT NULL,
9	body TEXT NOT NULL DEFAULT '',
10	sort_order INTEGER NOT NULL DEFAULT 0,
11	created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
12	updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
13	);
14
15	CREATE UNIQUE INDEX idx_project_sections_project_slug ON project_sections(project_id, slug);
16	CREATE INDEX idx_project_sections_project_order ON project_sections(project_id, sort_order);
17