Apr 20, 2023 · Apr 19, 2023 · Apr 20, 2023 · Apr 20, 2023 · Apr 19, 2023 · Apr 20, 2023
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000119_workspace_proxy_name_idx.down.sql b/coderd/database/migrations/000119_workspace_proxy_name_idx.down.sql
 BEGIN;

 DROP INDEX IF EXISTS workspace_proxies_lower_name_idx;

 -- Enforces no active proxies have the same name.
 CREATE UNIQUE INDEX ON workspace_proxies (name) WHERE deleted = FALSE;

 COMMIT;
diff --git a/coderd/database/migrations/000119_workspace_proxy_name_idx.up.sql b/coderd/database/migrations/000119_workspace_proxy_name_idx.up.sql
 BEGIN;

 -- No one is using this feature yet as of writing this migration, so this is
 -- fine. Just delete all workspace proxies to prevent the new index from having
 -- conflicts.
 DELETE FROM workspace_proxies;

 DROP INDEX IF EXISTS workspace_proxies_name_idx;
 CREATE UNIQUE INDEX workspace_proxies_lower_name_idx ON workspace_proxies USING btree (lower(name)) WHERE deleted = FALSE;

 COMMIT;
diff --git a/...tures/000118_workspace_proxy_token.up.sql → ...tures/000119_workspace_proxy_token.up.sql b/...tures/000118_workspace_proxy_token.up.sql → ...tures/000119_workspace_proxy_token.up.sql
diff --git a/coderd/database/unique_constraint.go b/coderd/database/unique_constraint.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,11 @@
		BEGIN;

		-- No one is using this feature yet as of writing this migration, so this is
		-- fine. Just delete all workspace proxies to prevent the new index from having
		-- conflicts.
		DELETE FROM workspace_proxies;

		DROP INDEX IF EXISTS workspace_proxies_name_idx;
		CREATE UNIQUE INDEX workspace_proxies_lower_name_idx ON workspace_proxies USING btree (lower(name)) WHERE deleted = FALSE;

		COMMIT;