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 , and . |
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 |
: 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 |
, : 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 |
: 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 |
: 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 |
: 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 |
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 |
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. |