ALTER TABLE GERPARAMGERAL ADD CDCLIENTE VARCHAR2(21) NULL
/

ALTER TABLE GERPARAMGERAL ADD CDCCUSCLIE VARCHAR2(10) NULL
/

ALTER TABLE GERPARAMGERAL ADD CDTIPOCONS VARCHAR2(2) NULL
/

ALTER TABLE GERPARAMGERAL
   ADD CONSTRAINT FKVND00876CLIENTE FOREIGN KEY (CDCLIENTE)
      REFERENCES CLIENTE (CDCLIENTE)
/

CREATE INDEX VND00876_FK ON GERPARAMGERAL(CDCLIENTE ASC)
/

ALTER TABLE GERPARAMGERAL
   ADD CONSTRAINT FKVND00877CCUSCLIE FOREIGN KEY (CDCLIENTE, CDCCUSCLIE)
      REFERENCES CCUSCLIE (CDCLIENTE, CDCCUSCLIE)
/

CREATE INDEX VND00877_FK ON GERPARAMGERAL(CDCLIENTE ASC, CDCCUSCLIE ASC)
/

ALTER TABLE GERPARAMGERAL
   ADD CONSTRAINT FKVND00878TIPOCONS FOREIGN KEY (CDTIPOCONS)
      REFERENCES TIPOCONS (CDTIPOCONS)
/

CREATE INDEX VND00878_FK ON GERPARAMGERAL(CDTIPOCONS ASC)
/