ALTER TABLE MALHAAEREADATA DROP CONSTRAINT FKCOC00591TURNOETD
/
ALTER TABLE MALHAAEREADATA ADD CONSTRAINT CKC_NRTURNOETD_MALHAAEREADATA CHECK (NRTURNOETD IN ('01', '02'))
/
DROP INDEX FKCOC00591TURNOETD
/
ALTER TABLE PREVPAXVOOPRODM DROP CONSTRAINT FKCOC00596TURNOETD
/
ALTER TABLE PREVPAXVOOPRODM ADD CONSTRAINT CKC_NRTURNOETD_PREVPAXVOOPRODM CHECK (NRTURNOETD IN ('01', '02'))
/
DROP INDEX FKCOC00596TURNOETD
/
ALTER TABLE CONEXAOSUBGRUPO ADD (
  IDPROPSUBSEMAM VARCHAR2(1) DEFAULT NULL NULL, 
  QTPROPSUBSEMAM DOUBLE PRECISION DEFAULT NULL NULL, 
  QTPAXDE DOUBLE PRECISION DEFAULT NULL NULL, 
  QTPAXATE DOUBLE PRECISION DEFAULT NULL NULL, 
  QTSUBGRU DOUBLE PRECISION DEFAULT NULL NULL
)
/
ALTER TABLE CONEXAOSUBGRUPO ADD CONSTRAINT CKC_IDPROPSUBSEMAM_CONEXAOSUBG CHECK (IDPROPSUBSEMAM IN ('1','2','3','4','5'))