Skip to end of metadata
Go to start of metadata

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