ALTER TABLE ITMAPARECUP ADD IDAJSUBAPURCP VARCHAR2(01) DEFAULT 'N' NOT NULL 
   CONSTRAINT CKC_IDAJSUBAPURCP_ITMAPARECUP CHECK (IDAJSUBAPURCP IN ('N','S'))
/

ALTER TABLE ITMAPARECUP ADD IDESTSUBAPUR VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDESTSUBAPUR_ITMAPARECUP CHECK (IDESTSUBAPUR IN ('N','S'))
/

ALTER TABLE GUIACOMPLMAPA ADD IDGUIASUBAPUR VARCHAR2(01) DEFAULT'N' NOT NULL
   CONSTRAINT CKC_IDGUIASUBAPUR_GUIACOMPLMAP CHECK (IDGUIASUBAPUR IN ('N','S'))
/