Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d6-0.22d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d6-0.22d7.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d6-0.22d7.sql 7 Sep 2008 19:38:13 -0000 1.2 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d6-0.22d7.sql 9 Sep 2008 17:28:22 -0000 1.3 @@ -53,3 +53,12 @@ / show errors; +alter table as_assessment_section_map rename column points to points_int; +alter table as_assessment_section_map add points type float; +update as_assessment_section_map set points=points_int; +alter table as_assessment_section_map drop column points_int; +alter table as_item_section_map alter points type float; +alter table as_item_section_map add points type float; +update as_item_section_map set points=points_int; +alter table as_item_section_map drop column points_int; +