ALTER TABLE CONSUMIDOR ADD IDATUCONSONLINE VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDATUCONSONLINE_CONSUMIDOR CHECK (IDATUCONSONLINE IN ('S','N')) NOVALIDATE
/ 

ALTER TABLE CONSUMIDOR ADD DTATUCONSONLINE DATE NULL
/

ALTER TABLE PARAVEND ADD IDUTICONSONLINE VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDUTICONSONLINE_PARAVEND CHECK (IDUTICONSONLINE IN ('S','N'))
/

ALTER TABLE PARAVEND ADD CDURLCONSONLINE VARCHAR2(250) NULL
/

ALTER TABLE CAIXA ADD NRDIASCONSMSDE VARCHAR2(3) NULL
/