feat(coderd/database): add api_version to provisioner_daemons table

coder · johnstcn · Dec 14, 2023 · Dec 14, 2023 · Dec 14, 2023 · Dec 14, 2023
commit 92a905a2d98ddd9cf89840608a90590a8c1b1cc7
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000179_provisionerdaemon_add_apiversion.down.sql b/coderd/database/migrations/000179_provisionerdaemon_add_apiversion.down.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY provisioner_daemons
+		DROP COLUMN api_version;
diff --git a/coderd/database/migrations/000179_provisionerdaemon_add_apiversion.up.sql b/coderd/database/migrations/000179_provisionerdaemon_add_apiversion.up.sql
@@ -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';
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY provisioner_daemons
		DROP COLUMN api_version;