bgpwtf/cccampix/verifier/model/migrations/1565806867_pgp_key_state.up.sql

ALTER TABLE peer_pgp_keys ADD COLUMN state STRING check ( state = 'unchecked' or state = 'unknown' or state = 'known' ) NOT NULL DEFAULT 'unchecked';
ALTER TABLE peer_pgp_keys ALTER COLUMN state DROP DEFAULT;