--ABS-64225 / ABS-70159
---------------- CLIENT ----------------
COMMENT ON COLUMN CLIENT.ALLOWREPAIR
  IS '0 = Not applicable / Defined on Customer
1 = Repair Allowed';

UPDATE CLIENT C 
SET C.ALLOWREPAIR = 0
WHERE C.ALLOWREPAIR NOT IN (0, 1);

COMMIT;

ALTER TABLE CLIENT
  DROP CONSTRAINT ALLOWREPAIR_VALID1_2;
ALTER TABLE CLIENT
  ADD CONSTRAINT ALLOWREPAIR_VALID2
  CHECK (ALLOWREPAIR IN (0,1));
