-- ABS-12593 Alternative Supplier selection in purchasing issue ABS-14052

ALTER TABLE PURCHASEREQUEST ADD (SUPPLIERPRODUCT_ID NUMBER NULL);

CREATE INDEX XIF7PURCHASEREQUEST ON PURCHASEREQUEST (SUPPLIERPRODUCT_ID);

ALTER TABLE PURCHASEREQUEST
  ADD CONSTRAINT PURCHASEREQUEST_SUPPLIERPROD FOREIGN KEY (SUPPLIERPRODUCT_ID)
  REFERENCES SUPPLIERPRODUCT (SUPPLIERPRODUCT_ID) ON DELETE SET NULL;