-- ABS-86229/ABS-87670

----------------- MUAWEARERPROFILE -------------------

ALTER TABLE MUAWEARERPROFILE ADD (REPAIRCOMPLETED VARCHAR2(1) DEFAULT 'Y' NOT NULL,
                                  NEWGARMENTSDELIVERED VARCHAR2(1) DEFAULT 'Y' NOT NULL,
                                  NEWGARMENTSDELAYED VARCHAR2(1) DEFAULT 'Y' NOT NULL,
                                  GARMENTSREPLACEMENT VARCHAR2(1) DEFAULT 'Y' NOT NULL,
                                  SENDNOTIFICATIONTOEMAIL VARCHAR2(1) DEFAULT 'Y' NOT NULL);
                            
COMMENT ON COLUMN MUAWEARERPROFILE.REPAIRCOMPLETED
IS 'If value = Y, then notifications will be send.';
COMMENT ON COLUMN MUAWEARERPROFILE.NEWGARMENTSDELIVERED 
IS 'If value = Y, then notifications will be send.';
COMMENT ON COLUMN MUAWEARERPROFILE.NEWGARMENTSDELAYED 
IS 'If value = Y, then notifications will be send.';
COMMENT ON COLUMN MUAWEARERPROFILE.GARMENTSREPLACEMENT
IS 'If value = Y, then notifications will be send.';