--- ABS-68455 / ABS-68809

----------- PACKINGNOTECONTAINERCONTENT -----------
DROP INDEX XIF1PNCONTAINERCONTENTS;
DROP INDEX XIF2PNCONTAINERCONTENTS;

ALTER TABLE PACKINGNOTECONTAINERCONTENT ADD (PACKINGNOTELINE_ID NUMBER NOT NULL);

CREATE INDEX XIF1PNCONTAINERCONTENT ON PACKINGNOTECONTAINERCONTENT (PACKINGNOTECONTAINER_ID ASC);
CREATE INDEX XIF2PNCONTAINERCONTENT ON PACKINGNOTECONTAINERCONTENT (UNIQUEITEM_LINK_ID ASC);
CREATE INDEX XIF3PNCONTAINERCONTENT ON PACKINGNOTECONTAINERCONTENT (PACKINGNOTELINE_ID ASC);

ALTER TABLE PACKINGNOTECONTAINERCONTENT
  ADD CONSTRAINT PNCONTCONTENT_PNLINE FOREIGN KEY (PACKINGNOTELINE_ID)
  REFERENCES PACKINGNOTELINE (PACKINGNOTELINE_ID) ON DELETE CASCADE;
