--order 502726
/*
      CHANGE REPORT for Table PRODUCT
          - Adding column MINQTYTODELIVER
          - Adding column MAXQTYTODELIVER
      ACTION is ALTER or modify Table PRODUCT
      */

ALTER TABLE PRODUCT ADD (MINQTYTODELIVER      NUMBER NULL);

ALTER TABLE PRODUCT ADD (MAXQTYTODELIVER      NUMBER NULL);

      /*
      CHANGE REPORT for Table PRODUCTLISTPERCUSTOMER
          - Adding column MINQTYTODELIVER
          - Adding column MAXQTYTODELIVER
      ACTION is ALTER or modify Table PRODUCTLISTPERCUSTOMER
      */

ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (MINQTYTODELIVER      NUMBER NULL);

ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (MAXQTYTODELIVER      NUMBER NULL);

--order 502746
      /*
      CHANGE REPORT for Table ROUTESTOP
          - Adding column DATEACTIVE
          - Adding column DATEINACTIVE
      ACTION is ALTER or modify Table ROUTESTOP
      */

ALTER TABLE ROUTESTOP ADD (DATEACTIVE           DATE DEFAULT sysdate NOT NULL);

ALTER TABLE ROUTESTOP ADD (DATEINACTIVE         DATE DEFAULT 
    TO_DATE('31-12-2099','DD-MM-YYYY') NOT NULL);

