coder · Emyrk · Apr 20, 2023 · Apr 19, 2023 · Apr 20, 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
@@ -0,0 +1,8 @@
+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;
 -- Enforces no active proxies have the same name. 
 CREATE UNIQUE INDEX ON workspace_proxies (name) WHERE deleted = FALSE; 
 -- 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
@@ -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;
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