ALTER TABLE COMANDAVEN ADD IDCOMANDAEXT VARCHAR2(64)
/

ALTER TABLE COMANDAVEN ADD IDENTRPLAT VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE COMANDAVEN ADD CONSTRAINT CKC_IDENTRPLAT_COMANDAVEN CHECK (IDENTRPLAT IN ('F', 'M', 'N'))
/

ALTER TABLE VENDA ADD IDCOMANDAEXT VARCHAR2(64)
/

ALTER TABLE VENDA ADD IDENTRPLAT VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE VENDA ADD CONSTRAINT CKC_IDENTRPLAT_VENDA CHECK (IDENTRPLAT IN ('F', 'M', 'N'))
/