[Building Sakai] MSGCNTR-503

[DAVID ROLDAN MARTINEZ]

	Hi all,

	Michelle Wagner and myself need some support in the fixing of https://jira.sakaiproject.org/browse/MSGCNTR-503 (Priority messages internationalization). The problem is that in the database is stored the priority value (Normal, High and Low) depending on the active locale, that is, if I'm working in Spanish it will be store Normal, Alta o Baja; if I'm working in English, the values will be Normal, Low and High.
	You'll find a patch fixing this attached at JIRA (https://jira.sakaiproject.org/secure/attachment/25843/msgcntr_MSGCNTR-503.patch.txt). The fix is quite easy: it stores a status code instead of the priority (pvt_priority_normal, pvt_priority_high, pvt_priority_high). The when displaying to the user, message bundle is loaded to show the corresponding message to the right key. The problem is that to be backward compatible it needs a database script. You also can find it at JIRA (https://jira.sakaiproject.org/secure/attachment/26125/oracle.sql) for Oracle and supposed to be valid for all locales. We have tested it in Spanish, English and Catalan...and here is where we need help. Can anybody test it in other locales and comment at JIRA the results, please?

	Thank you very much in advance.

	Cheers,

Dr. David Roldán Martínez
Universidad Politécnica de Valencia, Spain
Sakai QA lead for Internationalization