ALTER TABLE PARASUPRI ADD RDFORNECED VARCHAR2(1)  DEFAULT 'L' NOT NULL 
/

ALTER TABLE PARASUPRI ADD RDREGIAO VARCHAR2(1)  DEFAULT 'L' NOT NULL 
/

ALTER TABLE PARASUPRI ADD RDMARCA VARCHAR2(1)  DEFAULT 'L' NOT NULL
/

ALTER TABLE PARASUPRI ADD RDPROD VARCHAR2(1)  DEFAULT 'L' NOT NULL
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_RDFORNECED_PARASUPRI CHECK (RDFORNECED IN ('L', 'M', 'T'))
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_RDREGIAO_PARASUPRI CHECK (RDREGIAO IN ('L', 'M', 'T'))
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_RDMARCA_PARASUPRI CHECK (RDMARCA IN ('L', 'M', 'T'))
/

ALTER TABLE PARASUPRI ADD CONSTRAINT CKC_RDPROD_PARASUPRI CHECK (RDPROD IN ('L', 'M', 'T'))
/ 