ALTER TABLE bas_filial ADD COLUMN email CHARACTER VARYING (100);

UPDATE bas_filial SET email = '' WHERE email IS NULL;

ALTER TABLE bas_filial ALTER COLUMN email SET NOT NULL;