Upgrade Step

    MySQL

    Oracle

    Notes

    2.6.0

    sakai_2_6_0_mysql_conversion.sql

    sakai_2_6_0_oracle_conversion.sql

    Use scripts updated in 2.6.x branch (r65964+). Include fixes for SAK-16751 - Comment out site.add.course backfill SQL Closed , SAK-16753 - new 2.6 asn.share.drafts permission should be added into conversion script Closed and SAK-16809 - 2.6.0 upgrade script has index, column add in wrong order, related to SAK-16554 Closed .

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion001_SAK-16668.sql

    sakai_2_6_0-2_6_x_oracle_conversion001_SAK-16668.sql

    SAK-16668 - assignments / private notes and model answers does not display proper error message for text over 255 characters Closed : if you upgraded to Sakai 2.6.0 PRIOR to 1 Sept 2009 you must run this conversion to update data types in ASN_MA_ITEM_T and ASN_NOTE_ITEM_T.

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion002_SAK-16548.sql

    sakai_2_6_0-2_6_x_oracle_conversion002_SAK-16548.sql

    SAK-17219 - Conversion script for 2.6.1 is slow to run on large assignment data sets and should be improved Closed , SAK-16548 - Incorrect internationalization showing the grade NO GRADE Closed : Matt Jones (UMich) reports that the original 2.6.0 to 2.6.1 conversion script for the assignment_content table "is inefficient, potentially locks tables and performs too many scans, especially if there are hundreds of thousands of rows." Matt has revised both the MySQL and Oracle conversion scripts to improve their performance.

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion003_SAK-16847.sql

    sakai_2_6_0-2_6_x_oracle_conversion003_SAK-16847.sql

    SAK-16847 - asn.share.drafts permission should be added into 2.6.1 conversion script Closed : adds asn.share.drafts to SAKAI_REALM_FUNCTION.

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion004_SAK-10512.sql

    sakai_2_6_0-2_6_x_oracle_conversion004_SAK-10512.sql

    SAK-10512 - Abiliy to lock profiles Closed : updates existing entries in SAKAI_PERSON_T setting the field locked to false if currently NULL.

    2.6.0 to 2.6.1

    sakai_2_6_0-2_6_1_mysql_conversion.sql

    sakai_2_6_0-2_6_1_oracle_conversion.sql

    Rollup of 2.6.0-2.6.x conversion scripts 001-004 above.

    2.6.1 to 2.6.2

     

     

    no schema changes

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion005_SAK-14482.sql

    sakai_2_6_0-2_6_x_oracle_conversion005_SAK-14482.sql

    SAK-14482 - Mercury site has old assignments tool Closed : replace the "mercury" site's sakai.assignment tool (deprecated since 2.5.0) with the sakai.assignment.grades tool.

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion006_SAK-8421.sql

    sakai_2_6_0-2_6_x_oracle_conversion006_SAK-8421.sql

    SAK-8421 - Statistics page is very slow Closed add indexes for Forums Statistics page

    2.6.0 to 2.6.x

    sakai_2_6_0-2_6_x_mysql_conversion007_SAK-5742.sql

    sakai_2_6_0-2_6_x_oracle_conversion007_SAK-5742.sql

    SAK-5742 - SAKAI_PERSON_T indexes not created correctly on mysql Closed create missing indexes on SAKAI_PERSON_T

    2.6.2 to 2.6.3

    sakai_2_6_2-2_6_3_mysql_conversion.sql

    sakai_2_6_2-2_6_3_oracle_conversion.sql

    Rollup of 2.6.0-2.6.x conversion scripts 005-007 above.

    • No labels