--20010670.370


COMMENT ON COLUMN CUSTOMER.ALLOCATIONMETHOD IS '0 = No re-allocation
2 = Allocation only, no automatic ordering';


update customer c set c.allocationmethod=2 where c.allocationmethod=1;
commit;


ALTER TABLE CUSTOMER
DROP CONSTRAINT ALLOCATIONMETHOD_VALID1;


ALTER TABLE CUSTOMER
  ADD CONSTRAINT ALLOCATIONMETHOD_VALID1
  CHECK (ALLOCATIONMETHOD IN (0, 2));