--ABS-86229 / ABS-89343

-----------------MUASETTINGS---------------------------
ALTER TABLE MUASETTINGS ADD (TIMEOUT NUMBER DEFAULT 300 NOT NULL);

COMMENT ON COLUMN MUASETTINGS.TIMEOUT
	IS 'Timeout in seconds used when a wearer is logged out for no activity';
	
-----------------MUAWEARERPROFILE---------------------------
ALTER TABLE MUAWEARERPROFILE ADD (TOKENRESET VARCHAR2(24) DEFAULT NULL);

COMMENT ON COLUMN MUAWEARERPROFILE.TOKENRESET
	IS 'This token is used for resetting the Password or Pin in MUA Application';

-----------------LOSTITEMSHISTORY---------------------------
ALTER TABLE LOSTITEMSHISTORY ADD (STATUS NUMBER DEFAULT 0 NOT NULL CONSTRAINT CHK_LOSTITEMSHISTORY_STATUS CHECK (STATUS IN (0,1,2)));

COMMENT ON COLUMN LOSTITEMSHISTORY.STATUS
	IS '0 = In progress
1 = Found
2 = Not Found';

ALTER TABLE LOSTITEMSHISTORY DROP COLUMN CLOSEDDATE;
-----------------FLAG---------------------------------------
ALTER TABLE FLAG ADD (LOSTANDFOUND VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_FLAG_LOSTANDFOUND CHECK(LOSTANDFOUND IN ('Y','N')));