--Order 20015188

ALTER TABLE PROOFOFVISITHISTORY
  ADD (SIGNATURE VARCHAR2(1) DEFAULT 'N' NOT NULL  CONSTRAINT  YN_VALIDATIONFIELD121 CHECK (SIGNATURE IN ('Y', 'N')));

--Order 20015187

ALTER TABLE PRODUCTLISTPERCUSTOMER
	ADD (CONFIRMPRODUCTONPDA NUMBER  DEFAULT 0 NOT NULL CONSTRAINT CONFIRMPRODUCTONPDA_valid CHECK (CONFIRMPRODUCTONPDA IN (0, 1, 2)));

COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.CONFIRMPRODUCTONPDA IS '0 = Not applicable / Inherit from product
1 = Yes
2 = No
';

ALTER TABLE PRODUCT
	ADD (CONFIRMPRODUCTONPDA NUMBER  DEFAULT 1 NOT NULL CONSTRAINT CONFIRMPRODUCTONPDA_valid1 CHECK (CONFIRMPRODUCTONPDA IN (1, 2)));

COMMENT ON COLUMN PRODUCT.CONFIRMPRODUCTONPDA IS '1 = Yes
2 = No';
