-- ABS-95563 / ABS-107616
ALTER TABLE ROUTE ADD (ROUTEHANDLING NUMBER DEFAULT 0 NOT NULL 
                  CONSTRAINT CHK_ROUTE_ROUTEHANDLING CHECK (ROUTEHANDLING IN (0,1,2)));

COMMENT ON COLUMN ROUTE.ROUTEHANDLING 
IS '0 = Not applicable or all
1 = Handled via Route Assistant only
2 = Handled via OMD only
Default 0.
Only used in combination with modules MATTRANSPORT and OMDINTERFACE.';
