--order 502705      
      /*
      CHANGE REPORT for Table PRODUCTLISTPERCUSTOMER
          - Adding column ALLOWRETURNTOSTOCK
      ACTION is ALTER or modify Table PRODUCTLISTPERCUSTOMER
      */

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

COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.ALLOWRETURNTOSTOCK IS '0 = Yes (default)
1 = Yes, excluding special sizes
2 = No';

--order 502706    
      /*
      CHANGE REPORT for Table PRODUCTLISTPERCUSTOMER
          - Adding column ORDERVIAWEB
      ACTION is ALTER or modify Table PRODUCTLISTPERCUSTOMER
      */

ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (ORDERVIAWEB          NUMBER(1) DEFAULT 
    0 NOT NULL
                                   CONSTRAINT OrderViaWeb_valid
                                          CHECK (ORDERVIAWEB IN (0, 1)));

COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.ORDERVIAWEB IS '0 = No (default)
1 = Yes';