Index: docs/conversion/sakai_2_7_2-2_7_3_oracle_conversion.sql =================================================================== --- docs/conversion/sakai_2_7_2-2_7_3_oracle_conversion.sql (revision 0) +++ docs/conversion/sakai_2_7_2-2_7_3_oracle_conversion.sql (revision 0) @@ -0,0 +1,26 @@ +-- This is the Oracle Sakai 2.7.2 -> 2.7.3 conversion script +-- -------------------------------------------------------------------------------------------------------------------------------------- +-- +-- use this to convert a Sakai database from 2.7.2 to 2.7.3. Run this before you run your first app server. +-- auto.ddl does not need to be enabled in your app server - this script takes care of all new TABLEs, changed TABLEs, and changed data. +-- +-- Script insertion format +-- -- [TICKET] [short comment] +-- -- [comment continued] (repeat as necessary) +-- SQL statement +-- -------------------------------------------------------------------------------------------------------------------------------------- + +-- This file contains SQL to fix SAK-22700 ("The citations importer in Resources doesn't always correctly import RIS- formatted files") +update citation_schema_field set PROPERTY_VALUE='A1,AU' where FIELD_ID='creator' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='BT,T1,TI' where SCHEMA_ID='book' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='CT,T1,TI' where SCHEMA_ID='chapter' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='ED,A2,A3' where FIELD_ID='editor' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='JF,JO,JA,J1,J2,BT' where SCHEMA_ID='article' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N1,AB' where FIELD_ID='note' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N2,AB' where FIELD_ID='abstract' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='SP' where FIELD_ID='pages' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT,BT' where SCHEMA_ID='unknown' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT' where SCHEMA_ID='article' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI' where SCHEMA_ID='report' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='year' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='date' and PROPERTY_NAME='sakai:ris_identifier'; Property changes on: docs/conversion/sakai_2_7_2-2_7_3_oracle_conversion.sql ___________________________________________________________________ Added: svn:eol-style + native Index: docs/conversion/sakai_2_8_2-2_8_3_oracle_conversion.sql =================================================================== --- docs/conversion/sakai_2_8_2-2_8_3_oracle_conversion.sql (revision 114084) +++ docs/conversion/sakai_2_8_2-2_8_3_oracle_conversion.sql (working copy) @@ -1,7 +1,7 @@ -- This is the Oracle Sakai 2.8.2 -> 2.8.3 conversion script -- -------------------------------------------------------------------------------------------------------------------------------------- -- --- use this to convert a Sakai database from 2.8.2 to 2.8.3. Run this before you run your first app server. +-- use this to convert a Sakai database from 2.7.2 to 2.7.3. Run this before you run your first app server. -- auto.ddl does not need to be enabled in your app server - this script takes care of all new TABLEs, changed TABLEs, and changed data. -- -- Script insertion format @@ -12,5 +12,19 @@ -- POLL-172 -- Hibernate error in 2.8.2 Oracle after running conversion scripts still present (polls) +update poll_poll set poll_is_public = 0 where poll_is_public is null; -update poll_poll set poll_is_public = 0 where poll_is_public is null; +-- This file contains SQL to fix SAK-22700 ("The citations importer in Resources doesn't always correctly import RIS- formatted files") +update citation_schema_field set PROPERTY_VALUE='A1,AU' where FIELD_ID='creator' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='BT,T1,TI' where SCHEMA_ID='book' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='CT,T1,TI' where SCHEMA_ID='chapter' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='ED,A2,A3' where FIELD_ID='editor' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='JF,JO,JA,J1,J2,BT' where SCHEMA_ID='article' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N1,AB' where FIELD_ID='note' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N2,AB' where FIELD_ID='abstract' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='SP' where FIELD_ID='pages' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT,BT' where SCHEMA_ID='unknown' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT' where SCHEMA_ID='article' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI' where SCHEMA_ID='report' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='year' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='date' and PROPERTY_NAME='sakai:ris_identifier'; Index: docs/conversion/sakai_2_7_2-2_7_3_mysql_conversion.sql =================================================================== --- docs/conversion/sakai_2_7_2-2_7_3_mysql_conversion.sql (revision 0) +++ docs/conversion/sakai_2_7_2-2_7_3_mysql_conversion.sql (revision 0) @@ -0,0 +1,26 @@ +-- This is the MYSQL Sakai 2.7.2 -> 2.7.3 conversion script +-- -------------------------------------------------------------------------------------------------------------------------------------- +-- +-- use this to convert a Sakai database from 2.7.2 to 2.7.3. Run this before you run your first app server. +-- auto.ddl does not need to be enabled in your app server - this script takes care of all new TABLEs, changed TABLEs, and changed data. +-- +-- Script insertion format +-- -- [TICKET] [short comment] +-- -- [comment continued] (repeat as necessary) +-- SQL statement +-- -------------------------------------------------------------------------------------------------------------------------------------- + +-- This file contains SQL to fix SAK-22700 ("The citations importer in Resources doesn't always correctly import RIS- formatted files") +update citation_schema_field set PROPERTY_VALUE='A1,AU' where FIELD_ID='creator' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='BT,T1,TI' where SCHEMA_ID='book' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='CT,T1,TI' where SCHEMA_ID='chapter' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='ED,A2,A3' where FIELD_ID='editor' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='JF,JO,JA,J1,J2,BT' where SCHEMA_ID='article' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N1,AB' where FIELD_ID='note' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N2,AB' where FIELD_ID='abstract' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='SP' where FIELD_ID='pages' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT,BT' where SCHEMA_ID='unknown' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT' where SCHEMA_ID='article' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI' where SCHEMA_ID='report' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='year' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='date' and PROPERTY_NAME='sakai:ris_identifier'; Property changes on: docs/conversion/sakai_2_7_2-2_7_3_mysql_conversion.sql ___________________________________________________________________ Added: svn:eol-style + native Index: docs/conversion/sakai_2_8_2-2_8_3_mysql_conversion.sql =================================================================== --- docs/conversion/sakai_2_8_2-2_8_3_mysql_conversion.sql (revision 0) +++ docs/conversion/sakai_2_8_2-2_8_3_mysql_conversion.sql (revision 0) @@ -0,0 +1,26 @@ +-- This is the MYSQL Sakai 2.8.2 -> 2.8.3 conversion script +-- -------------------------------------------------------------------------------------------------------------------------------------- +-- +-- use this to convert a Sakai database from 2.7.2 to 2.7.3. Run this before you run your first app server. +-- auto.ddl does not need to be enabled in your app server - this script takes care of all new TABLEs, changed TABLEs, and changed data. +-- +-- Script insertion format +-- -- [TICKET] [short comment] +-- -- [comment continued] (repeat as necessary) +-- SQL statement +-- -------------------------------------------------------------------------------------------------------------------------------------- + +-- This file contains SQL to fix SAK-22700 ("The citations importer in Resources doesn't always correctly import RIS- formatted files") +update citation_schema_field set PROPERTY_VALUE='A1,AU' where FIELD_ID='creator' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='BT,T1,TI' where SCHEMA_ID='book' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='CT,T1,TI' where SCHEMA_ID='chapter' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='ED,A2,A3' where FIELD_ID='editor' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='JF,JO,JA,J1,J2,BT' where SCHEMA_ID='article' and FIELD_ID='sourceTitle' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N1,AB' where FIELD_ID='note' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='N2,AB' where FIELD_ID='abstract' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='SP' where FIELD_ID='pages' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT,BT' where SCHEMA_ID='unknown' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI,CT' where SCHEMA_ID='article' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='T1,TI' where SCHEMA_ID='report' and FIELD_ID='title' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='year' and PROPERTY_NAME='sakai:ris_identifier'; +update citation_schema_field set PROPERTY_VALUE='Y1,PY' where FIELD_ID='date' and PROPERTY_NAME='sakai:ris_identifier'; Property changes on: docs/conversion/sakai_2_8_2-2_8_3_mysql_conversion.sql ___________________________________________________________________ Added: svn:eol-style + native