[#SAK-15165] Extend SakaiPerson to add more fields

Sakai

Extend SakaiPerson to add more fields

Created: 15-Dec-2008 02:11 Updated: 22-Jan-2010 02:45

Component/s:

Profile

Affects Version/s:

None

Fix Version/s:

2.7.0, 2.7.x

Time Tracking:

Not Specified

2.7.x Status:	Resolved
2.6.x Status:	None
2.5.x Status:	None
2.4.x Status:	None

Description

« Hide

The new Profile work needs more fields in SakaiPerson. This ticket will track these changes.

All

Comments

Work Log

Change History

Subversion Commits

git Commits

Sort Order:

[ Permlink | « Hide ]

Steve Swinsburg added a comment - 25-Mar-2009 07:29

The following new fields have been added as of r59096:

- favouriteBooks
- favouriteTvShows
- favouriteMovies
- favouriteQuotes

[ Permlink | « Hide ]

Steve Swinsburg added a comment - 08-May-2009 08:43

This requires a database conversion script to go from 2.6 to 2.7 to add these fields.

Have contacted Peter to check if there is a place in Confluence/Jira to put these conversions for 2.7

[ Permlink | « Hide ]

Steve Swinsburg added a comment - 29-Nov-2009 14:50

MySQL:
alter table SAKAI_PERSON_T add FAVOURITE_BOOKS text;
alter table SAKAI_PERSON_T add FAVOURITE_TV_SHOWS text;
alter table SAKAI_PERSON_T add FAVOURITE_MOVIES text;
alter table SAKAI_PERSON_T add FAVOURITE_QUOTES text;
alter table SAKAI_PERSON_T add EDUCATION_COURSE text;
alter table SAKAI_PERSON_T add EDUCATION_SUBJECTS text;

Oracle:
alter table SAKAI_PERSON_T add FAVOURITE_BOOKS varchar2(4000);
alter table SAKAI_PERSON_T add FAVOURITE_TV_SHOWS varchar2(4000);
alter table SAKAI_PERSON_T add FAVOURITE_MOVIES varchar2(4000);
alter table SAKAI_PERSON_T add FAVOURITE_QUOTES varchar2(4000);
alter table SAKAI_PERSON_T add EDUCATION_COURSE varchar2(4000);
alter table SAKAI_PERSON_T add EDUCATION_SUBJECTS varchar2(4000);

[ Permlink | « Hide ]

Beth Kirschner added a comment - 04-Jan-2010 09:44

Merged conversion scripts to 2.7.x