ALTER TABLE par_nota_fiscal_contingencia
  ADD COLUMN mail_assinatura character varying;
  
UPDATE par_nota_fiscal_contingencia SET mail_assinatura = '' WHERE mail_assinatura IS NULL;

ALTER TABLE par_nota_fiscal_contingencia
  ALTER COLUMN mail_assinatura SET NOT NULL;