Commitb64af42

committed

Add down migration

Also bump migration number since new ones have merged since.

1 parentaba8129 commitb64af42Copy full SHA for b64af42

File tree

+15

-1

lines changed

+15

-1

lines changed

Lines changed: 0 additions & 1 deletion

This file was deleted.

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,15 @@`
	`1`	`+-- It is not possible to delete a value from an enum, so we have to recreate it.`
	`2`	`+CREATETYPEold_workspace_app_status_stateAS ENUM ('working','complete','failure');`
	`3`	`+`
	`4`	`+-- Convert the new "idle" state into "complete". This means we lose some`
	`5`	`+-- information when downgrading, but this is necessary to swap to the old enum.`
	`6`	`+UPDATE workspace_app_statusesSET state='complete'WHERE state='idle';`
	`7`	`+`
	`8`	`+-- Swap to the old enum.`
	`9`	`+ALTERTABLE workspace_app_statuses`
	`10`	`+ALTER COLUMN state TYPE old_workspace_app_status_state`
	`11`	`+USING (state::text::old_workspace_app_status_state);`
	`12`	`+`
	`13`	`+-- Drop the new enum and rename the old one to the final name.`
	`14`	`+DROPTYPE workspace_app_status_state;`
	`15`	`+ALTERTYPE old_workspace_app_status_state RENAME TO workspace_app_status_state;`

File renamed without changes.

Comments

(0)