ALTER TABLE INSCRESTAD ADD CDAJCREDPRES VARCHAR2(20) NULL 
/

ALTER TABLE INSCRESTAD ADD IDUTSUBAPURCP VARCHAR2(01) DEFAULT 'N' NOT NULL 
   CONSTRAINT CKC_IDUTSUBAPURCP_INSCRESTAD CHECK (IDUTSUBAPURCP IN ('N','S'))
/

ALTER TABLE INSCRESTAD ADD IDINDICSUBAPURCP VARCHAR2(01) DEFAULT '3' NOT NULL 
   CONSTRAINT CKC_IDINDICSUBAPURCP_INSCRESTA CHECK (IDINDICSUBAPURCP IN ('3','4','5','6','7','8'))
/

ALTER TABLE INSCRESTAD ADD DSOUTRAAPURCP VARCHAR2(250) NULL
/

ALTER TABLE INSCRESTAD ADD CDAJESTORNOCP VARCHAR2(20) NULL
/

ALTER TABLE INSCRESTAD ADD DSESTORNOCP VARCHAR2(250) NULL
/

DROP INDEX UN_RECEBRUTALIQMAPA_01
/

ALTER TABLE RECEBRUTALIQMAPA DROP CONSTRAINT UN_RECEBRUTALIQMAPA_01
/