-- 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';