max / makenotwork

268 B · 7 lines History Blame Raw

1	-- Prevent two public projects from claiming the same slug.
2	-- The /p/{slug} routes resolve by slug alone, so at most one
3	-- public project may own a given slug at a time.
4	CREATE UNIQUE INDEX idx_projects_public_slug
5	ON projects (slug)
6	WHERE is_public = true;
7