-- ABS-10810
---------------------PRINTQUEUE---------------------
ALTER TABLE PRINTQUEUE ADD (STERILIZATIONRUN_ID NUMBER NULL,
							FINISHINGMETHOD_ID NUMBER NULL);

CREATE INDEX XIF12PRINTQUEUE ON PRINTQUEUE (STERILIZATIONRUN_ID);

CREATE INDEX XIF13PRINTQUEUE ON PRINTQUEUE (FINISHINGMETHOD_ID);
  
COMMENT ON COLUMN PRINTQUEUE.STERILIZATIONRUN_ID
  IS 'Filled only for cleanroom labels.';
  
COMMENT ON COLUMN PRINTQUEUE.FINISHINGMETHOD_ID
  IS 'Filled only for cleanroom labels.';
						
ALTER TABLE PRINTQUEUE
  ADD CONSTRAINT PRINTQUEUE_STERILIZATIONRUN_ID FOREIGN KEY (STERILIZATIONRUN_ID)
  REFERENCES STERILIZATIONRUN (STERILIZATIONRUN_ID) ON DELETE SET NULL;
  
ALTER TABLE PRINTQUEUE
  ADD CONSTRAINT PRINTQUEUE_FINISHINGMETHOD_ID FOREIGN KEY (FINISHINGMETHOD_ID)
  REFERENCES FINISHINGMETHOD (FINISHINGMETHOD_ID) ON DELETE SET NULL;
  