max / makenotwork

244 B · 7 lines History Blame Raw

1	ALTER TABLE projects ADD COLUMN git_repo_name VARCHAR(64);
2
3	-- Each user can link a given repo to at most one project.
4	CREATE UNIQUE INDEX idx_projects_git_repo_unique
5	ON projects (user_id, git_repo_name)
6	WHERE git_repo_name IS NOT NULL;
7