--Order 20015392

ALTER TABLE CLIENTDELIVERYNOTE ADD (MOVEDFROMCLIENT_LINK_ID NUMBER NULL);
ALTER TABLE CLIENTDELIVERYNOTE ADD (MOVEDDATE DATE NULL);

CREATE INDEX XIF12CLIENTDELIVERYNOTE ON CLIENTDELIVERYNOTE (MOVEDFROMCLIENT_LINK_ID);

ALTER TABLE CLIENTDELIVERYNOTE
  ADD CONSTRAINT CLIENTDELIVERYNOTE_MOVEDFROMCL FOREIGN KEY (MOVEDFROMCLIENT_LINK_ID)
  REFERENCES CLIENT_LINK (CLIENT_LINK_ID) ON DELETE SET NULL;