Commit9e218f7

committed

chore: Enforce workspace proxy unique name case insensitive

1 parentf94ac55 commit9e218f7Copy full SHA for 9e218f7

File tree

+19

-0

lines changed

+19

-0

lines changed

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;`

Comments

(0)