Skip to content

Commit 9a20d98

Browse files
mafredrimafredri
committed
create index
1 parent 4649f19 commit 9a20d98

File tree

2 files changed

+8
-0
lines changed

2 files changed

+8
-0
lines changed

‎coderd/database/dump.sql

Lines changed: 4 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000302_add_workspace_agent_devcontainers.up.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -13,3 +13,7 @@ COMMENT ON COLUMN workspace_agent_devcontainers.workspace_agent_id IS 'Workspace
1313
COMMENT ON COLUMN workspace_agent_devcontainers.created_at IS 'Creation timestamp';
1414
COMMENT ON COLUMN workspace_agent_devcontainers.workspace_folder IS 'Workspace folder';
1515
COMMENT ON COLUMN workspace_agent_devcontainers.config_path IS 'Path to devcontainer.json.';
16+
17+
CREATE INDEX workspace_agent_devcontainers_workspace_agent_id ON workspace_agent_devcontainers (workspace_agent_id);
18+
19+
COMMENT ON INDEX workspace_agent_devcontainers_workspace_agent_id IS 'Workspace agent foreign key and query index';

0 commit comments

Comments
 (0)