fix: add index on workspace_agents.auth_token

coadler · coadler · commit bc4b6887acbc · 2022-12-01T19:00:29.000-06:00
diff --git a/coderd/database/migrations/000084_workspace_agents_auth_token_index.down.sql b/coderd/database/migrations/000084_workspace_agents_auth_token_index.down.sql
@@ -0,0 +1 @@
+DROP INDEX workspace_agents_auth_token_idx;
diff --git a/coderd/database/migrations/000084_workspace_agents_auth_token_index.up.sql b/coderd/database/migrations/000084_workspace_agents_auth_token_index.up.sql
@@ -0,0 +1 @@
+CREATE INDEX workspace_agents_auth_token_idx ON workspace_agents USING btree (auth_token);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROP INDEX workspace_agents_auth_token_idx;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+CREATE INDEX workspace_agents_auth_token_idx ON workspace_agents USING btree (auth_token);`