ALTER TABLE flx_conta_banc ADD COLUMN IF NOT EXISTS cobranca_vinculada character varying (1) ;
UPDATE flx_conta_banc SET cobranca_vinculada = (CASE WHEN trim(tipo_cobranca) != '' AND banco = 1 THEN '1' ELSE '0' END) WHERE cobranca_vinculada IS NULL;
ALTER TABLE flx_conta_banc ALTER COLUMN cobranca_vinculada SET NOT NULL;