ALTER TABLE PAR_GERAL_FAS ADD CDPROFATSOLI VARCHAR2(10) NULL
/

CREATE INDEX FAT00256_FK ON PAR_GERAL_FAS (CDPROFATSOLI ASC)
/

ALTER TABLE PAR_GERAL_FAS
ADD CONSTRAINT FKFAT00256PRODUTO FOREIGN KEY (CDPROFATSOLI)
REFERENCES PRODUTO (CDPRODUTO)
/

ALTER TABLE PAR_GERAL_FAS MODIFY DTULTATUPFAS DEFAULT SYSDATE
/

ALTER TABLE EQUIPETRAB ADD CDOPERRESP VARCHAR2(12) NULL
/

ALTER TABLE EQUIPETRAB ADD QTLIMSEMAPROP FLOAT NULL
/

CREATE INDEX GEP00260_FK ON EQUIPETRAB (CDOPERRESP ASC)
/

ALTER TABLE EQUIPETRAB
ADD CONSTRAINT FKGEP00260OPERADOR FOREIGN KEY (CDOPERRESP)
REFERENCES OPERADOR (CDOPERADOR)
/

ALTER TABLE PARFILIALGEP ADD CDPROCATEINT VARCHAR2(10) NULL
/

ALTER TABLE PARFILIALGEP ADD CDPROCATEDES VARCHAR2(10) NULL
/

CREATE INDEX GEP00261_FK ON PARFILIALGEP (CDPROCATEINT ASC)
/

CREATE INDEX GEP00262_FK ON PARFILIALGEP (CDPROCATEDES ASC)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00261PROCESSO FOREIGN KEY (CDPROCATEINT)
REFERENCES PROCESSO (CDPROCESSO)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00262PROCESSO FOREIGN KEY (CDPROCATEDES)
REFERENCES PROCESSO (CDPROCESSO)
/

ALTER TABLE PARFILIALGEP ADD CDPROCESSOGCO VARCHAR2(10) NULL
/

CREATE INDEX GEP00307_FK ON PARFILIALGEP (CDPROCESSOGCO ASC)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00307PROCESSO FOREIGN KEY (CDPROCESSOGCO)
REFERENCES PROCESSO (CDPROCESSO)
/

ALTER TABLE PARFILIALGEP ADD CDPROCESSOQA VARCHAR2(10) NULL
/

CREATE INDEX GEP00308_FK ON PARFILIALGEP (CDPROCESSOQA ASC)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00308PROCESSO FOREIGN KEY (CDPROCESSOQA)
REFERENCES PROCESSO (CDPROCESSO)
/

ALTER TABLE PARFILIALGEP ADD CDOPERAUDITQA VARCHAR2(12) NULL
/

CREATE INDEX GEP00309_FK ON PARFILIALGEP (CDOPERAUDITQA ASC)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00309OPERADOR FOREIGN KEY (CDOPERAUDITQA)
REFERENCES OPERADOR (CDOPERADOR)
/

ALTER TABLE PARFILIALGEP ADD CDOPERAUDITGCO VARCHAR2(12) NULL
/

CREATE INDEX GEP00310_FK ON PARFILIALGEP (CDOPERAUDITGCO ASC)
/

ALTER TABLE PARFILIALGEP
ADD CONSTRAINT FKGEP00310OPERADOR FOREIGN KEY (CDOPERAUDITGCO)
REFERENCES OPERADOR (CDOPERADOR)
/

ALTER TABLE DATAGRPROJETO ADD DTSEGURAGRPROJ DATE NULL
/

ALTER TABLE DATAGRPROJETO ADD DTQAGRPROJ DATE NULL
/

ALTER TABLE BASELINEPROJ ADD DTFINULTATIVBL DATE NULL
/

ALTER TABLE BASELINEPROJ ADD DTINIBASELINE DATE NULL
/

ALTER TABLE BASELINEPROJ ADD DTFINBASELINE DATE NULL
/

ALTER TABLE ITEMTAREFA ADD IDCONCATTARE CHAR(1) DEFAULT 'N' NULL
CONSTRAINT CKC_IDCONCATTARE CHECK (IDCONCATTARE IS NULL OR (IDCONCATTARE IN ('S','N')))
/