fix: Remove unique index on auth tokens

kylecarbs · kylecarbs · commit b27ad1aa5247 · 2022-04-25T02:53:29.000Z
If a workspace is started multiple times, resources may
not be invalidated. This means an auth token can be
reused for a workspace.

coderd closes old agent connections, so this is expected
behavior, and the agent will reconnect properly.
diff --git a/coderd/database/migrations/000004_jobs.up.sql b/coderd/database/migrations/000004_jobs.up.sql
@@ -80,7 +80,7 @@ CREATE TABLE workspace_agents (
     last_connected_at timestamptz,
     disconnected_at timestamptz,
     resource_id uuid NOT NULL REFERENCES workspace_resources (id) ON DELETE CASCADE,
-    auth_token uuid NOT NULL UNIQUE,
+    auth_token uuid NOT NULL,
     auth_instance_id varchar(64),
     architecture varchar(64) NOT NULL,
     environment_variables jsonb,
