ALTER TABLE GRUPSERVFAT ADD CDTIPOOPER VARCHAR2(2) NULL
/

ALTER TABLE GRUPSERVFAT ADD IDENTRSAIDOP VARCHAR2(1) NULL
/

ALTER TABLE GRUPSERVFAT 
   ADD CONSTRAINT FKPLA01283GRUPSERVTPOPER FOREIGN KEY (IDENTRSAIDOP, CDTIPOOPER) 
      REFERENCES TIPOOPERAC(IDENTRSAIDOP, CDTIPOOPER)
/

CREATE INDEX PLA01283_FK ON GRUPSERVFAT(IDENTRSAIDOP ASC, CDTIPOOPER ASC)
/

ALTER TABLE CTRLVENDAANTEC ADD CDEMPRESA VARCHAR2(2) NULL
/

ALTER TABLE CTRLVENDAANTEC ADD CDINSCESTA VARCHAR2(16) NULL
/

ALTER TABLE CTRLVENDAANTEC ADD CDINSCMUNI VARCHAR2(16) NULL
/

ALTER TABLE CTRLVENDAANTEC ADD CDSERIE VARCHAR2(5) NULL
/

ALTER TABLE CTRLVENDAANTEC
   ADD CONSTRAINT FKPLA01284VENDAANTEC_SERIENF FOREIGN KEY (CDSERIE, CDEMPRESA, CDINSCESTA, CDINSCMUNI)
      REFERENCES SERIENF (CDSERIE, CDEMPRESA, CDINSCESTA, CDINSCMUNI)
/

CREATE INDEX PLA01284_FK ON CTRLVENDAANTEC(CDSERIE ASC, CDEMPRESA ASC, CDINSCESTA ASC, CDINSCMUNI ASC)
/