--Order 20012894.70

ALTER TABLE FINISHINGMETHOD
	ADD (MAXSORT NUMBER  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN FINISHINGMETHOD.MAXSORT IS 'The maximum number of items with this finishing method that are allowed in a client delivery note. When set to 0, there is no maximum.';

ALTER TABLE CLIENTDELIVERYNOTE
        ADD (ADDITIONALTONOTE_ID  NUMBER NULL);

CREATE  INDEX XIF8CLIENTDELIVERYNOTE ON CLIENTDELIVERYNOTE
(ADDITIONALTONOTE_ID   ASC);

ALTER TABLE CLIENTDELIVERYNOTE
ADD CONSTRAINT CLIENTDELNOTE_CLIENTDELNOTE FOREIGN KEY (ADDITIONALTONOTE_ID) REFERENCES CLIENTDELIVERYNOTE (CLIENTDELIVERYNOTE_ID) ON DELETE SET NULL;

