Add down migration

Also bump migration number since new ones have merged since.
coder · code-asher · Jun 20, 2025 · Jun 17, 2025 · Jun 17, 2025 · Jun 20, 2025
commit b64af42bc8bc693693b4a0a39ee94cf4f33dbcb0
diff --git a/coderd/database/migrations/000338_workspace_app_status_idle.down.sql b/coderd/database/migrations/000338_workspace_app_status_idle.down.sql
diff --git a/coderd/database/migrations/000340_workspace_app_status_idle.down.sql b/coderd/database/migrations/000340_workspace_app_status_idle.down.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;
diff --git a/...s/000338_workspace_app_status_idle.up.sql → ...s/000340_workspace_app_status_idle.up.sql b/...s/000338_workspace_app_status_idle.up.sql → ...s/000340_workspace_app_status_idle.up.sql