1.4.x, r84264

Integrated in profile2 trunk #268 (See http://builds.sakaiproject.org:8080/job/profile2%20trunk/268/)
DB upgrade scripts for SakaiPerson

r84262. These are already in the main conversion scripts. Needs a merge to 1.4.

MySQL:
alter table SAKAI_PERSON_T add STAFF_PROFILE text;
alter table SAKAI_PERSON_T add UNIVERSITY_PROFILE_URL text;
alter table SAKAI_PERSON_T add ACADEMIC_PROFILE_URL text;
alter table SAKAI_PERSON_T add PUBLICATIONS text;
alter table SAKAI_PERSON_T add BUSINESS_BIOGRAPHY text;

Oracle:
alter table SAKAI_PERSON_T add STAFF_PROFILE varchar2(4000);
alter table SAKAI_PERSON_T add UNIVERSITY_PROFILE_URLvarchar2(4000);
alter table SAKAI_PERSON_T add ACADEMIC_PROFILE_URL varchar2(4000);
alter table SAKAI_PERSON_T add PUBLICATIONS varchar2(4000);
alter table SAKAI_PERSON_T add BUSINESS_BIOGRAPHY varchar2(4000);

So far we have:

<property name="staffProfile" column="STAFF_PROFILE" type="string" length="4000" />
<property name="universityProfileUrl" column="UNIVERSITY_PROFILE_URL" type="string" length="4000" />
<property name="academicProfileUrl" column="ACADEMIC_PROFILE_URL" type="string" length="4000" />
<property name="publications" column="PUBLICATIONS" type="string" length="4000" />
<property name="businessBiography" column="BUSINESS_BIOGRAPHY" type="string" length="4000" />

Also need to check the other fields are correctly setup, eg string/4000, and if not, provide a conversion.