Skip to main content

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