Added automatic_updates to workspaces table

Signed-off-by: Spike Curtis <spike@coder.com>
coder · spikecurtis · Oct 6, 2023 · May 10, 2023 · May 10, 2023 · May 10, 2023
commit e1ba28eb9df8429c81165daf5e949b5f66a07d0c
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000161_workspace_automatic_updates.down.sql b/coderd/database/migrations/000161_workspace_automatic_updates.down.sql
@@ -0,0 +1,4 @@
+BEGIN;
+ALTER TABLE workspaces DROP COLUMN IF EXISTS automatic_updates;
+DROP TYPE IF EXISTS automatic_updates;
+COMMIT;
diff --git a/coderd/database/migrations/000161_workspace_automatic_updates.up.sql b/coderd/database/migrations/000161_workspace_automatic_updates.up.sql
@@ -0,0 +1,8 @@
+BEGIN;
+-- making this an enum in case we want to later add other options, like 'if_compatible_vars'
+CREATE TYPE automatic_updates AS ENUM (
+    'always',
+    'never'
+);
+ALTER TABLE workspaces ADD COLUMN IF NOT EXISTS automatic_updates automatic_updates NOT NULL DEFAULT 'never'::automatic_updates;
+COMMIT;
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