Skip to content

Commit 76196df

Browse files
johnstcnjohnstcn
committed
add unique index
1 parent 0d5cd98 commit 76196df

File tree

3 files changed

+6
-1
lines changed

3 files changed

+6
-1
lines changed

‎coderd/database/dump.sql

Lines changed: 3 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000185_user_pinned_workspaces.up.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,5 @@
11
CREATE TABLE user_pinned_workspaces (
22
user_id uuid NOT NULL,
3-
workspace_id uuid NOT NULL
3+
workspace_id uuid NOT NULL,
4+
UNIQUE(user_id, workspace_id)
45
);

‎coderd/database/unique_constraint.go

Lines changed: 1 addition & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)