chore: Enforce workspace proxy unique name case insensitive

Emyrk · Emyrk · commit 9e218f73dfb6 · 2023-04-19T09:04:45.000-05:00
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;
+
+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;
