Database Conversion Scripts (2.6)

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 - Getting issue details... STATUS , SAK-16753 - Getting issue details... STATUS and SAK-16809 - Getting issue details... STATUS .
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 - Getting issue details... STATUS : 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 - Getting issue details... STATUS , SAK-16548 - Getting issue details... STATUS : 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 - Getting issue details... STATUS : 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 - Getting issue details... STATUS : 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 - Getting issue details... STATUS : 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 - Getting issue details... STATUS 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 - Getting issue details... STATUS 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.