--SO 20016107

ALTER TABLE UNIQUEITEMEMBLEM  ADD (EMBLEMTEMPLATELINE_ID NUMBER NULL, 
                                   PLACEMENT_ID NUMBER NULL);
                                   
ALTER TABLE UNIQUEITEMEMBLEM 
  ADD CONSTRAINT UIEMBLEM_EMBLEMTEMPLINE FOREIGN KEY (EMBLEMTEMPLATELINE_ID)
  REFERENCES EMBLEMTEMPLATELINE (EMBLEMTEMPLATELINE_ID) ON DELETE SET NULL;

CREATE INDEX XIF4UNIQUEITEMEMBLEM  ON UNIQUEITEMEMBLEM 
(EMBLEMTEMPLATELINE_ID   ASC);


                                   
ALTER TABLE UNIQUEITEMEMBLEM 
  ADD CONSTRAINT UIEMBLEM_PLACEMENT FOREIGN KEY (PLACEMENT_ID)
  REFERENCES PLACEMENT (PLACEMENT_ID) ON DELETE SET NULL;

CREATE INDEX XIF5UNIQUEITEMEMBLEM  ON UNIQUEITEMEMBLEM 
(PLACEMENT_ID   ASC);