| 1 |
|
| 2 |
CREATE TABLE repo_collaborators ( |
| 3 |
id UUID PRIMARY KEY DEFAULT gen_random_uuid(), |
| 4 |
repo_id UUID NOT NULL REFERENCES git_repos(id) ON DELETE CASCADE, |
| 5 |
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 6 |
can_push BOOLEAN NOT NULL DEFAULT true, |
| 7 |
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), |
| 8 |
UNIQUE (repo_id, user_id) |
| 9 |
); |
| 10 |
|
| 11 |
CREATE INDEX idx_repo_collaborators_repo_id ON repo_collaborators(repo_id); |
| 12 |
CREATE INDEX idx_repo_collaborators_user_id ON repo_collaborators(user_id); |
| 13 |
|