ALTER TABLE BOLETOS DROP OBSERVACAO;

commit;

ALTER TABLE BOLETOS ADD OBSERVACAO VARCHAR(1000) CHARACTER SET WIN1252 COLLATE WIN1252;

commit;

ALTER TABLE REC_MENSAL ADD CODCLIREF INTEGER;

commit;

ALTER TABLE CLIP_CONFIG ADD ACAD_RECIBOBOLETO SMALLINT;

commit;

UPDATE CLIP_CONFIG SET ACAD_RECIBOBOLETO = 0;

commit;

CREATE INDEX MOVIMENTOPLANO_IDX1 ON MOVIMENTOPLANO (NRDOC);

commit;
