--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1433/01.add_state.sql	Fri Mar 27 15:31:03 2020 +0100
@@ -0,0 +1,19 @@
+-- DROP and re-CREATE type because adding a value isn't possible in transaction
+-- https://www.postgresql.org/docs/11/sql-altertype.html#id-1.9.3.42.7
+
+ALTER TABLE import.imports
+    ALTER COLUMN state DROP DEFAULT,
+    ALTER COLUMN state TYPE varchar;
+
+DROP TYPE import_state;
+
+CREATE TYPE import_state AS ENUM (
+    'queued',
+    'running',
+    'failed', 'unchanged', 'pending',
+    'accepted', 'declined', 'reviewed'
+);
+
+ALTER TABLE import.imports
+    ALTER COLUMN state TYPE import_state USING CAST(state AS import_state),
+    ALTER COLUMN state SET DEFAULT 'queued';