--Order 20011903.70


ALTER TABLE STOCKTRANSACTION
	ADD (NEWSIZEDEFINITION_ID NUMBER NULL);


COMMENT ON COLUMN STOCKTRANSACTION.NEWSIZEDEFINITION_ID IS 'This is filled when an item with unfinished size or with an alternative size is issued (the new size is the circulation size)';


CREATE  INDEX XIF7STOCKTRANSACTION ON STOCKTRANSACTION
(NEWSIZEDEFINITION_ID   ASC);


ALTER TABLE STOCKTRANSACTION
ADD CONSTRAINT STOCKTRANSACTION_SIZEDEFINITIO FOREIGN KEY (NEWSIZEDEFINITION_ID) REFERENCES SIZEDEFINITION (SIZEDEFINITION_ID) ON DELETE SET NULL;
