Commit7fa1112

authored

chore: Enforce workspace proxy unique name case insensitive (#7202)

* chore: Enforce workspace proxy unique name case insensitive

1 parent9abfe97 commit7fa1112Copy full SHA for 7fa1112

File tree

+21

-2

lines changed

+21

-2

lines changed

Lines changed: 1 addition & 1 deletion

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,8 @@`
	`1`	`+BEGIN;`
	`2`	`+`
	`3`	`+DROPINDEX IF EXISTS workspace_proxies_lower_name_idx;`
	`4`	`+`
	`5`	`+-- Enforces no active proxies have the same name.`
	`6`	`+CREATEUNIQUE INDEXON workspace_proxies (name)WHERE deleted= FALSE;`
	`7`	`+`
	`8`	`+COMMIT;`

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,11 @@`
	`1`	`+BEGIN;`
	`2`	`+`
	`3`	`+-- No one is using this feature yet as of writing this migration, so this is`
	`4`	`+-- fine. Just delete all workspace proxies to prevent the new index from having`
	`5`	`+-- conflicts.`
	`6`	`+DELETEFROM workspace_proxies;`
	`7`	`+`
	`8`	`+DROPINDEX IF EXISTS workspace_proxies_name_idx;`
	`9`	`+CREATEUNIQUE INDEXworkspace_proxies_lower_name_idxON workspace_proxies USING btree (lower(name))WHERE deleted= FALSE;`
	`10`	`+`
	`11`	`+COMMIT;`

File renamed without changes.

Lines changed: 1 addition & 1 deletion

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Comments

(0)