coder
diff --git a/‎coderd/database/dbpurge/dbpurge_test.go
+9-1 b/‎coderd/database/dbpurge/dbpurge_test.go
+9-1
diff --git a/‎coderd/database/dump.sql
+4-1 b/‎coderd/database/dump.sql
+4-1
diff --git a/‎coderd/database/migrations/000179_provisionerdaemon_add_apiversion.down.sql
+2 b/‎coderd/database/migrations/000179_provisionerdaemon_add_apiversion.down.sql
+2
diff --git a/‎coderd/database/migrations/000179_provisionerdaemon_add_apiversion.up.sql
+3 b/‎coderd/database/migrations/000179_provisionerdaemon_add_apiversion.up.sql
+3
diff --git a/‎coderd/database/models.go
+2 b/‎coderd/database/models.go
+2
diff --git a/‎coderd/database/queries.sql.go
+12-5 b/‎coderd/database/queries.sql.go
+12-5
diff --git a/‎coderd/database/queries/provisionerdaemons.sql
+6-3 b/‎coderd/database/queries/provisionerdaemons.sql
+6-3
@@ -217,6 +217,8 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
 		Tags:         database.StringMap{provisionersdk.TagScope: provisionersdk.ScopeOrganization},
 		CreatedAt:    now.Add(-14 * 24 * time.Hour),
 		LastSeenAt:   sql.NullTime{Valid: true, Time: now.Add(-7 * 24 * time.Hour).Add(time.Minute)},
+		Version:      "1.0.0",
+		APIVersion:   "1.0",
 	})
 	require.NoError(t, err)
 	_, err = db.UpsertProvisionerDaemon(ctx, database.UpsertProvisionerDaemonParams{
@@ -226,6 +228,8 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
 		Tags:         database.StringMap{provisionersdk.TagScope: provisionersdk.ScopeOrganization},
 		CreatedAt:    now.Add(-8 * 24 * time.Hour),
 		LastSeenAt:   sql.NullTime{Valid: true, Time: now.Add(-8 * 24 * time.Hour).Add(time.Hour)},
+		Version:      "1.0.0",
+		APIVersion:   "1.0",
 	})
 	require.NoError(t, err)
 	_, err = db.UpsertProvisionerDaemon(ctx, database.UpsertProvisionerDaemonParams{
@@ -236,7 +240,9 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
 			provisionersdk.TagScope: provisionersdk.ScopeUser,
 			provisionersdk.TagOwner: uuid.NewString(),
 		},
-		CreatedAt: now.Add(-9 * 24 * time.Hour),
+		CreatedAt:  now.Add(-9 * 24 * time.Hour),
+		Version:    "1.0.0",
+		APIVersion: "1.0",
 	})
 	require.NoError(t, err)
 	_, err = db.UpsertProvisionerDaemon(ctx, database.UpsertProvisionerDaemonParams{
@@ -249,6 +255,8 @@ func TestDeleteOldProvisionerDaemons(t *testing.T) {
 		},
 		CreatedAt:  now.Add(-6 * 24 * time.Hour),
 		LastSeenAt: sql.NullTime{Valid: true, Time: now.Add(-6 * 24 * time.Hour)},
+		Version:    "1.0.0",
+		APIVersion: "1.0",
 	})
 	require.NoError(t, err)
 
 
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY provisioner_daemons
+		DROP COLUMN api_version;
@@ -0,0 +1,3 @@
+ALTER TABLE ONLY provisioner_daemons
+    ADD COLUMN api_version text NOT NULL DEFAULT '1.0';
+COMMENT ON COLUMN provisioner_daemons.api_version IS 'The API version of the provisioner daemon';
@@ -23,7 +23,8 @@ INSERT INTO
 		provisioners,
 		tags,
 		last_seen_at,
-		"version"
+		"version",
+		api_version
 	)
 VALUES (
 	gen_random_uuid(),
@@ -32,12 +33,14 @@ VALUES (
 	@provisioners,
 	@tags,
 	@last_seen_at,
-	@version
+	@version,
+	@api_version
 ) ON CONFLICT("name", lower((tags ->> 'owner'::text))) DO UPDATE SET
 	provisioners = @provisioners,
 	tags = @tags,
 	last_seen_at = @last_seen_at,
-	"version" = @version
+	"version" = @version,
+	api_version = @api_version
 WHERE
 	-- Only ones with the same tags are allowed clobber
 	provisioner_daemons.tags <@ @tags :: jsonb
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE ONLY provisioner_daemons`
	`2`	`+ DROP COLUMN api_version;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+ALTER TABLE ONLY provisioner_daemons`
	`2`	`+ ADD COLUMN api_version text NOT NULL DEFAULT '1.0';`
	`3`	`+COMMENT ON COLUMN provisioner_daemons.api_version IS 'The API version of the provisioner daemon';`