ALTER TABLE SOLICADIANTAMENTO ADD NRSOLICADIAINTE NUMBER
/

ALTER TABLE GERAL_PAG ADD CDFORMPGTO VARCHAR2(2)
/
ALTER TABLE GERAL_PAG
    ADD CONSTRAINT FKFIN00418FORMPGTO FOREIGN KEY  (CDFORMPGTO)
       REFERENCES FORMPGTO (CDFORMPGTO)
/

CREATE INDEX FIN00418_FK ON GERAL_PAG (CDFORMPGTO)
/
ALTER TABLE GERAL_PAG ADD CDSERIEENTR VARCHAR2(5)
/
ALTER TABLE GERAL_PAG
    ADD CONSTRAINT FKFIN00419SERIEENTR FOREIGN KEY  (CDSERIEENTR)
       REFERENCES SERIEENTR (CDSERIEENTR)
/
CREATE INDEX FIN00419_FK ON GERAL_PAG (CDSERIEENTR)
/
ALTER TABLE GERAL_PAG ADD CDTIPOOPER VARCHAR2(2)
/
ALTER TABLE GERAL_PAG ADD IDENTRSAIDOP VARCHAR2(1)
/
ALTER TABLE GERAL_PAG
    ADD CONSTRAINT FKFIN00420TIPOOPERAC FOREIGN KEY  (CDTIPOOPER, IDENTRSAIDOP)
       REFERENCES TIPOOPERAC (CDTIPOOPER, IDENTRSAIDOP)
/
CREATE INDEX FIN00420_FK ON GERAL_PAG (CDTIPOOPER ASC, IDENTRSAIDOP ASC)
/
ALTER TABLE GERAL_PAG ADD CDCLIENTID VARCHAR2(1000)
/
ALTER TABLE GERAL_PAG ADD CDCLIENTSECRET VARCHAR2(1000)
/