coder
diff --git a/‎coderd/coderd.go
Lines changed: 7 additions & 0 deletions b/‎coderd/coderd.go
Lines changed: 7 additions & 0 deletions
diff --git a/‎coderd/database/dump.sql
Lines changed: 2 additions & 1 deletion b/‎coderd/database/dump.sql
Lines changed: 2 additions & 1 deletion
diff --git a/‎coderd/database/migrations/000070_deployment_graph.down.sql
Lines changed: 2 additions & 0 deletions b/‎coderd/database/migrations/000070_deployment_graph.down.sql
Lines changed: 2 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000070_deployment_graph.up.sql
Lines changed: 2 additions & 0 deletions b/‎coderd/database/migrations/000070_deployment_graph.up.sql
Lines changed: 2 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000070_provisioner_log_lines.down.sql b/‎coderd/database/migrations/000070_provisioner_log_lines.down.sql
diff --git a/‎coderd/database/migrations/000071_provisioner_log_lines.down.sql
Lines changed: 3 additions & 0 deletions b/‎coderd/database/migrations/000071_provisioner_log_lines.down.sql
Lines changed: 3 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000070_provisioner_log_lines.up.sql renamed to ‎coderd/database/migrations/000071_provisioner_log_lines.up.sql b/‎coderd/database/migrations/000070_provisioner_log_lines.up.sql renamed to ‎coderd/database/migrations/000071_provisioner_log_lines.up.sql
diff --git a/‎coderd/database/models.go
Lines changed: 2 additions & 1 deletion b/‎coderd/database/models.go
Lines changed: 2 additions & 1 deletion
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 22 additions & 13 deletions b/‎coderd/database/queries.sql.go
Lines changed: 22 additions & 13 deletions
diff --git a/‎coderd/database/queries/workspaceagents.sql
Lines changed: 3 additions & 2 deletions b/‎coderd/database/queries/workspaceagents.sql
Lines changed: 3 additions & 2 deletions
@@ -16,6 +16,7 @@ import (
 	"github.com/andybalholm/brotli"
 	"github.com/go-chi/chi/v5"
 	"github.com/go-chi/chi/v5/middleware"
+	"github.com/google/uuid"
 	"github.com/klauspost/compress/zstd"
 	"github.com/prometheus/client_golang/prometheus"
 	"go.opentelemetry.io/otel/trace"
@@ -165,6 +166,7 @@ func New(options *Options) *API {
 
 	r := chi.NewRouter()
 	api := &API{
+		ID:          uuid.New(),
 		Options:     options,
 		RootHandler: r,
 		siteHandler: site.Handler(site.FS(), binFS),
@@ -579,6 +581,11 @@ func New(options *Options) *API {
 
 type API struct {
 	*Options
+	// ID is a uniquely generated ID on initialization.
+	// This is used to associate objects with a specific
+	// Coder API instance, like workspace agents to a
+	// specific replica.
+	ID                                uuid.UUID
 	Auditor                           atomic.Pointer[audit.Auditor]
 	WorkspaceClientCoordinateOverride atomic.Pointer[func(rw http.ResponseWriter) bool]
 	WorkspaceQuotaEnforcer            atomic.Pointer[workspacequota.Enforcer]
 
@@ -0,0 +1,2 @@
+ALTER TABLE workspace_agents
+    DROP COLUMN last_connected_replica_id;
@@ -0,0 +1,2 @@
+ALTER TABLE workspace_agents
+    ADD COLUMN last_connected_replica_id uuid;
@@ -0,0 +1,3 @@
+ALTER TABLE provisioner_job_logs DROP COLUMN id;
+
+ALTER TABLE provisioner_job_logs ADD COLUMN id uuid NOT NULL DEFAULT gen_random_uuid();
@@ -64,8 +64,9 @@ UPDATE
 SET
 	first_connected_at = $2,
 	last_connected_at = $3,
-	disconnected_at = $4,
-	updated_at = $5
+	last_connected_replica_id = $4,
+	disconnected_at = $5,
+	updated_at = $6
 WHERE
 	id = $1;
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE workspace_agents`
	`2`	`+ DROP COLUMN last_connected_replica_id;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE workspace_agents`
	`2`	`+ ADD COLUMN last_connected_replica_id uuid;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+ALTER TABLE provisioner_job_logs DROP COLUMN id;`
	`2`	`+`
	`3`	`+ALTER TABLE provisioner_job_logs ADD COLUMN id uuid NOT NULL DEFAULT gen_random_uuid();`