ALTER TABLE VENDA ADD DSURLFOTOVEN VARCHAR2(1000) NULL
/

ALTER TABLE VENDA ADD IDCHECKEDVEN VARCHAR2(1) DEFAULT 'N' NULL
   CONSTRAINT CKC_IDCHECKEDVEN_VENDA CHECK (IDCHECKEDVEN IN ('N','S'))
/

ALTER TABLE COMANDAVEN ADD DSURLFOTOCMD VARCHAR2(1000) NULL
/

ALTER TABLE COMANDAVEN ADD IDCHECKEDCMD VARCHAR2(1) DEFAULT 'N' NULL
   CONSTRAINT CKC_IDCHECKEDCMD_COMANDAVEN CHECK (IDCHECKEDCMD IN ('N','S'))
/ 