ALTER TABLE TIPOCONS ADD IDPERALTDESCFID VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE TIPOCONS ADD CONSTRAINT CKC_IDPERALTDESCFID_TIPOCONS CHECK (IDPERALTDESCFID IN ('S','N'))
/
ALTER TABLE COMANDAVEN ADD VRDESCFID FLOAT NULL
/
ALTER TABLE EXTRATOCONS ADD CONSTRAINT CKC_IDTPMOVEXT CHECK (IDTPMOVEXT IN ('C','D','V','E','F'))
/
ALTER TABLE VENDA ADD NRVENDARESTORA VARCHAR2(10) NULL