ALTER TABLE flx_conta_banc ADD COLUMN dias_desconto integer; ALTER TABLE flx_conta_banc ADD COLUMN percentual_desconto numeric(18,6); UPDATE flx_conta_banc SET dias_desconto = 0 WHERE dias_desconto IS NULL ; UPDATE flx_conta_banc SET percentual_desconto = 0 WHERE percentual_desconto IS NULL ; ALTER TABLE flx_conta_banc ALTER COLUMN dias_desconto SET NOT NULL; ALTER TABLE flx_conta_banc ALTER COLUMN percentual_desconto SET NOT NULL;