--ABS-104716/ABS-105297
--------- WEARERINVENTORY ----------

ALTER TABLE WEARERINVENTORY ADD (TEMPORARYMAXINVENTORY NUMBER DEFAULT 0 NOT NULL);

COMMENT ON COLUMN WEARERINVENTORY.TEMPORARYMAXINVENTORY
  IS 'Used for storing the previous max inventory for inventory increases when system setting MAKECIRC=MAXONCHANGEMAX = 1';

UPDATE WEARERINVENTORY W
SET W.TEMPORARYMAXINVENTORY = W.MAXINVENTORY;
COMMIT;

--------- WORKORDERLINE----------
ALTER TABLE WORKORDERLINE ADD (MAXINVENTORYINCREASE NUMBER DEFAULT 0 NOT NULL);

COMMENT ON COLUMN WORKORDERLINE.MAXINVENTORYINCREASE
  IS 'Used for storing the increase in max inventory that generated this work order when system setting MAKECIRC=MAXONCHANGEMAX = 1';