--Order 20015188

ALTER TABLE PROOFOFVISITHISTORY
  DROP COLUMN SIGNATURE CASCADE CONSTRAINTS;

ALTER TABLE DELIVERYPOINT
ADD (SIGNATUREBARCODE VARCHAR2(24) NULL);

ALTER TABLE DELIVERYSIGNATURE
ADD (BARCODE VARCHAR2(24) NULL,
          SCANNEDYN VARCHAR2(1) NULL CONSTRAINT SCANNEDYN_valid CHECK (SCANNEDYN IN ('Y', 'N')),
          SCANTIMESTAMP DATE NULL);

