-- ABS-159186 / ABS-170674

-- ADD/MODIFY COLUMNS 
ALTER TABLE UNIQUEITEMCLIENTPOOL ADD CLIENTDELIVERYNOTE_ID NUMBER;
-- CREATE/RECREATE PRIMARY, UNIQUE AND FOREIGN KEY CONSTRAINTS 
ALTER TABLE UNIQUEITEMCLIENTPOOL
  ADD CONSTRAINT FK_UNIQUEITEMCLIENTPOOL_CDN FOREIGN KEY (CLIENTDELIVERYNOTE_ID)
  REFERENCES CLIENTDELIVERYNOTE (CLIENTDELIVERYNOTE_ID) ON DELETE SET NULL;
