ALTER TABLE PARASUPRI ADD IDUTLORCAMENTO VARCHAR2(1) DEFAULT 'S'
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDUTLORCAMENTO CHECK (IDUTLORCAMENTO IN ('S', 'N'))
/

ALTER TABLE PARASUPRI ADD IDCONSVALPREC VARCHAR2(1) DEFAULT 'N'
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDCONSVALPREC CHECK (IDCONSVALPREC IN ('S', 'N'))
/

ALTER TABLE PARASUPRI ADD IDALTPRODAPROV VARCHAR2(1) DEFAULT 'S'
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDALTPRODAPROV CHECK (IDALTPRODAPROV IN ('S', 'N'))
/

ALTER TABLE PARASUPRI ADD IDALTERAQTDE VARCHAR2(1) DEFAULT 'D'
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_IDALTERAQTDE CHECK (IDALTERAQTDE IN ('I', 'D', 'A'))
/ 