--todo 11698


ALTER TABLE RAGGEDITEM
	ADD (MODIFICATION_1_ID NUMBER NULL);



ALTER TABLE RAGGEDITEM
	ADD (MODIFICATION_2_ID NUMBER NULL);



ALTER TABLE RAGGEDITEM
	ADD (MODIFICATION_3_ID NUMBER NULL);



CREATE  INDEX XIF17RAGGEDITEM ON RAGGEDITEM
(MODIFICATION_1_ID   ASC) TABLESPACE INDX;



CREATE  INDEX XIF18RAGGEDITEM ON RAGGEDITEM
(MODIFICATION_2_ID   ASC) TABLESPACE INDX;



CREATE  INDEX XIF19RAGGEDITEM ON RAGGEDITEM
(MODIFICATION_3_ID   ASC) TABLESPACE INDX;



ALTER TABLE RAGGEDITEM
ADD CONSTRAINT RAGGEDITEM_MODIFICATION1 FOREIGN KEY (MODIFICATION_1_ID) REFERENCES MODIFICATION (MODIFICATION_ID) ON DELETE SET NULL;



ALTER TABLE RAGGEDITEM
ADD CONSTRAINT RAGGEDITEM_MODIFICATION2 FOREIGN KEY (MODIFICATION_2_ID) REFERENCES MODIFICATION (MODIFICATION_ID) ON DELETE SET NULL;



ALTER TABLE RAGGEDITEM
ADD CONSTRAINT RAGGEDITEM_MODIFICATION3 FOREIGN KEY (MODIFICATION_3_ID) REFERENCES MODIFICATION (MODIFICATION_ID) ON DELETE SET NULL;


