fix: add prebuild_status migration

evgeniy-scherbina · evgeniy-scherbina · commit 0fd347acf5d4 · 2025-05-16T15:19:15.000Z
diff --git a/coderd/database/migrations/000326_add_status_to_template_presets.down.sql b/coderd/database/migrations/000326_add_status_to_template_presets.down.sql
@@ -0,0 +1,5 @@
+-- Remove the column from the table first (must happen before dropping the enum type)
+ALTER TABLE template_version_presets DROP COLUMN prebuild_status;
+
+-- Then drop the enum type
+DROP TYPE prebuild_status;
diff --git a/coderd/database/migrations/000326_add_status_to_template_presets.up.sql b/coderd/database/migrations/000326_add_status_to_template_presets.up.sql
@@ -0,0 +1,7 @@
+CREATE TYPE prebuild_status AS ENUM (
+  'normal',           -- Prebuilds are working as expected; this is the default, healthy state.
+  'hard_limited',     -- Prebuilds have failed repeatedly and hit the configured hard failure limit; won't be retried anymore.
+  'validation_failed' -- Prebuilds failed due to a non-retryable validation error (e.g. template misconfiguration); won't be retried.
+);
+
+ALTER TABLE template_version_presets ADD COLUMN prebuild_status prebuild_status DEFAULT 'normal';
