--todo 9531

ALTER TABLE STOCKTRANSACTION DROP CONSTRAINT STOCKTRANSACTION_FROMSTOCKROOM;

ALTER TABLE STOCKTRANSACTION DROP CONSTRAINT STOCKTRANSACTION_TOSTOCKROOM;
   
      /*
      CHANGE REPORT for Table STOCKTRANSACTION
          - Changing definition of relation STOCKTRANSACTION_FROMSTOCKROOM
          - Changing definition of relation STOCKTRANSACTION_TOSTOCKROOM
      ACTION is ALTER or modify Table STOCKTRANSACTION
      */

ALTER TABLE STOCKTRANSACTION
       ADD  ( CONSTRAINT STOCKTRANSACTION_FROMSTOCKROOM
              FOREIGN KEY (FROMSTOCKROOMLOCATION_ID)
                             REFERENCES STOCKROOMLOCATION
                             ON DELETE SET NULL ) ;

ALTER TABLE STOCKTRANSACTION
       ADD  ( CONSTRAINT STOCKTRANSACTION_TOSTOCKROOM
              FOREIGN KEY (TOSTOCKROOMLOCATION_ID)
                             REFERENCES STOCKROOMLOCATION 
                             ON DELETE SET NULL ) ;


