coder
diff --git a/‎coderd/database/migrations/000338_workspace_app_status_idle.down.sql
Lines changed: 0 additions & 1 deletion b/‎coderd/database/migrations/000338_workspace_app_status_idle.down.sql
Lines changed: 0 additions & 1 deletion
diff --git a/‎coderd/database/migrations/000340_workspace_app_status_idle.down.sql
Lines changed: 15 additions & 0 deletions b/‎coderd/database/migrations/000340_workspace_app_status_idle.down.sql
Lines changed: 15 additions & 0 deletions
diff --git a/‎coderd/database/migrations/000338_workspace_app_status_idle.up.sql renamed to ‎coderd/database/migrations/000340_workspace_app_status_idle.up.sql b/‎coderd/database/migrations/000338_workspace_app_status_idle.up.sql renamed to ‎coderd/database/migrations/000340_workspace_app_status_idle.up.sql
@@ -0,0 +1,15 @@
+-- It is not possible to delete a value from an enum, so we have to recreate it.
+CREATE TYPE old_workspace_app_status_state AS ENUM ('working', 'complete', 'failure');
+
+-- Convert the new "idle" state into "complete".  This means we lose some
+-- information when downgrading, but this is necessary to swap to the old enum.
+UPDATE workspace_app_statuses SET state = 'complete' WHERE state = 'idle';
+
+-- Swap to the old enum.
+ALTER TABLE workspace_app_statuses
+ALTER COLUMN state TYPE old_workspace_app_status_state
+USING (state::text::old_workspace_app_status_state);
+
+-- Drop the new enum and rename the old one to the final name.
+DROP TYPE workspace_app_status_state;
+ALTER TYPE old_workspace_app_status_state RENAME TO workspace_app_status_state;