SAK-6102 Sakai_Person_T notes field size change (2.x)
SAK-6102 - Getting issue details... STATUS , SAK-3917 - Getting issue details... STATUS : Users who have been running Sakai prior to 19 July 2006 release of Sakai 2.2.0 should check the field size of the SAKAI_PERSON_T "Notes" field. A field size change was added to the 2.1.2 to 2.2.0 conversion script on 17 January 2007. Depending on when deployers executed the 2.1.2->2.2.0 conversion script for the 2.1->2.2 upgrade, this update may have been missed. See the following Jiras as well as the sakai-dev "Notes in SAKAI_PERSON_T table" thread discussion for more information.
MySQL
--- reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_mysql_conversion.sql 2007/01/17 18:57:13 20392 +++ reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_mysql_conversion.sql 2007/01/17 19:10:09 20393 @@ -2237,3 +2237,9 @@ ---------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE SAKAI_SESSION CHANGE SESSION_IP SESSION_IP VARCHAR (128); + +---------------------------------------------------------------------------------------------------------------------------------------- +-- Increase the field size for the NOTES field in the SAKAI_PERSON_T table +---------------------------------------------------------------------------------------------------------------------------------------- + +ALTER TABLE SAKAI_PERSON_T CHANGE NOTES NOTES varchar(4000);
Oracle
--- reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_oracle_conversion.sql 2007/01/17 18:57:13 20392 +++ reference/trunk/docs/conversion/sakai_2_1_2-2_2_0_oracle_conversion.sql 2007/01/17 19:10:09 20393 @@ -2243,3 +2243,9 @@ ---------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE SAKAI_SESSION MODIFY SESSION_IP VARCHAR2 (128); + +---------------------------------------------------------------------------------------------------------------------------------------- +-- Increase the field size for the NOTES field in the SAKAI_PERSON_T table +---------------------------------------------------------------------------------------------------------------------------------------- + +ALTER TABLE SAKAI_PERSON_T MODIFY (NOTES varchar2(4000));