ALTER TABLE DELIVERYM ADD (
  IDDELIVCOMPL VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  VRPERSBYUT DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERSBYNUT DOUBLE PRECISION DEFAULT NULL NULL, 
  VRALTXPORT DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERDESCFIXO DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERDESCDESV DOUBLE PRECISION DEFAULT NULL NULL, 
  VRPERDESCCOND DOUBLE PRECISION DEFAULT NULL NULL, 
  IDCALCPROPDLCOM VARCHAR2(1) DEFAULT NULL NULL, 
  IDDESCDESV VARCHAR2(1) DEFAULT NULL NULL, 
  IDDESCCOND VARCHAR2(1) DEFAULT NULL NULL, 
  IDDESCFIXO VARCHAR2(1) DEFAULT NULL NULL
)
/
ALTER TABLE DELIVERYM ADD CONSTRAINT CKC_IDCALCPROPDLCOM_DELIVERYM CHECK (IDCALCPROPDLCOM IN ('S','N'))
/
ALTER TABLE DELIVERYM ADD CONSTRAINT CKC_IDDELIVCOMPL_DELIVERYM CHECK (IDDELIVCOMPL IN ('S','N'))
/
ALTER TABLE DELIVERYM ADD CONSTRAINT CKC_IDDESCDESV_DELIVERYM CHECK (IDDESCDESV IN ('1','2'))
/
ALTER TABLE DELIVERYM ADD CONSTRAINT CKC_IDDESCFIXO_DELIVERYM CHECK (IDDESCFIXO IN ('1','2'))
/
ALTER TABLE DELIVERYM ADD CONSTRAINT CKC_IDDESCCOND_DELIVERYM CHECK (IDDESCCOND IN ('1','2'))