 where t.old_status <> owi.ACTION_VALUE;
 
 drop table tmp_workflow_guid_map;
--- ****** end backfill for returned status
-
+-- end backfill for returned status
 -- END SAK-15710
 
 -- SAK-16835 columns for new quartz version


create index MRF_SYN_USER on MFR_SYNOPTIC_ITEM (USER_ID);



--////////////////////////////////////////////////////
--// MSGCNTR-177
--// MyWorkspace/Home does now show the Messages & Forums Notifications by default
--////////////////////////////////////////////////////

update SAKAI_SITE_TOOL
Set TITLE = 'Unread Messages and Forums'
Where REGISTRATION = 'sakai.synoptic.messagecenter'; 

INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'Reviewer'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'roster.export'));
INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'Reviewer'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'roster.viewofficialphoto'));
INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'Reviewer'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'roster.viewprofile'));
-- end SAK-18370

-- SAK-17206
alter table POLL_OPTION add DELETED number(1,0) DEFAULT NULL;