chore: add unique org name constraint to db

aslilac · aslilac · commit 59d5bc293043 · 2024-05-17T18:22:33.000Z
diff --git a/coderd/database/migrations/000210_unique_org_name.down.sql b/coderd/database/migrations/000210_unique_org_name.down.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY organizations
+	DROP CONSTRAINT IF EXISTS organizations_name;
diff --git a/coderd/database/migrations/000210_unique_org_name.up.sql b/coderd/database/migrations/000210_unique_org_name.up.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY organizations
+	ADD CONSTRAINT organizations_name UNIQUE (name);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE ONLY organizations`
	`2`	`+ DROP CONSTRAINT IF EXISTS organizations_name;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE ONLY organizations`
	`2`	`+ ADD CONSTRAINT organizations_name UNIQUE (name);`