-- ABS-29914

-----------------------WEARERTEMPASSIGNMENT -----------------------

ALTER TABLE WEARERTEMPASSIGNMENT MODIFY (ISSUETOWEARERDATE DATE NULL);
ALTER TABLE WEARERTEMPASSIGNMENT ADD (ORIGIN NUMBER(1) NULL CONSTRAINT ORIGIN_VALID1_3 CHECK (ORIGIN IN (1, 2)));

COMMENT ON COLUMN WEARERTEMPASSIGNMENT.ORIGIN IS ' 
1 - Android App
2 - WalknCloset
';



