---ABS-159007
ALTER TABLE ROUTECONTROLEXTRAINFO DROP CONSTRAINT CHK_RCEXTRAINFO_TRUCKLOADSTAT;

ALTER TABLE ROUTECONTROLEXTRAINFO ADD CONSTRAINT CHK_RCEXTRAINFO_TRUCKLOADSTAT CHECK (TRUCKLOADSTATUS IN (1, 2, 3, 4));

COMMENT ON COLUMN ROUTECONTROLEXTRAINFO.TRUCKLOADSTATUS IS '1 = Not started (default) 2 = In progress 3 = Completed 4 = Closing Route';
