-- ABS-10165

---------------------   WEARERINVENTORY   -------------------------------------

ALTER TABLE WEARERINVENTORY
DROP CONSTRAINT SELECTFLAGRETURN_VALID;

ALTER TABLE WEARERINVENTORY ADD CONSTRAINT SELECTFLAGRETURN_VALID CHECK (SELECTFLAGRETURN BETWEEN 1 AND 6);

COMMENT ON COLUMN WEARERINVENTORY.SELECTFLAGRETURN IS '1 = First scanned
2 = Oldest
3 = Newest
4 = Most washed
5 = Least washed
6 = Not scanned recently';