      
      /*
      CHANGE REPORT for Table WORKORDER
          - Adding column WORKORDERPICKED
      ACTION is ALTER or modify Table WORKORDER
      */

ALTER TABLE WORKORDER ADD (WORKORDERPICKED      VARCHAR2(1) DEFAULT 'N' NOT 
    NULL
                                   CONSTRAINT YN_ValidationNew101
                                          CHECK (WORKORDERPICKED IN ('Y', 'N')))
    ;

 /*
      CHANGE REPORT for Table WORKSTATION
          - Adding a new relationship WORKSTATION_STOCKROOM_ID
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK WORKSTATION_STOCKROOM_ID of table WORKSTATION, which references table STOCKROOM).
          - Adding column STOCKROOM_ID
      ACTION is ALTER or modify Table WORKSTATION
      */

ALTER TABLE WORKSTATION ADD (STOCKROOM_ID         NUMBER NULL);


ALTER TABLE WORKSTATION
       ADD  ( CONSTRAINT WORKSTATION_STOCKROOM_ID
              FOREIGN KEY (STOCKROOM_ID)
                             REFERENCES STOCKROOM ) ;

