ALTER TABLE bas_smtp_email
  ADD COLUMN assinatura_email character varying;
  
UPDATE bas_smtp_email SET assinatura_email = '' WHERE assinatura_email IS NULL;

ALTER TABLE bas_smtp_email
  ALTER COLUMN assinatura_email SET NOT NULL;