alter table `JOB_EXECUTION_CONTEXT` add `USERNAME_DESTINATION` text, add `USERNAME_ORIGINS` text, add `USERNAME_TO_ASSIGN` text, add `INSTITUTIONAL_EMAIL_TO_ASSIGN` text;

update PARTY_CONTACT SET VISIBLE_PUBLIC=1 WHERE OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contacts.PhysicalDeliveryOfficeContact' OR OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contacts.PostBoxContact' OR OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contacts.InternalPhone' OR (OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contacts.EmailAddress' AND TYPE='INSTITUTIONAL') OR (OJB_CONCRETE_CLASS='net.sourceforge.fenixedu.domain.contacts.WebAddress' AND TYPE='INSTITUTIONAL');