Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d6-0.22d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d6-0.22d7.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d6-0.22d7.sql 2 Sep 2008 01:21:08 -0000 1.1 +++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d6-0.22d7.sql 7 Sep 2008 19:38:13 -0000 1.2 @@ -1,3 +1,8 @@ +drop view as_itemsx; +drop view as_itemsi cascade; +alter table as_items alter points type float; +select content_type__refresh_view('as_items'); + drop view as_item_datax; drop view as_item_datai cascade; alter table as_item_data alter points type float; @@ -7,3 +12,13 @@ drop view as_session_resultsi cascade; alter table as_session_results alter points type float; select content_type__refresh_view('as_session_results'); + +drop view as_sectionsx; +drop view as_sectionsi cascade; +alter table as_sections alter points type float; +select content_type__refresh_view('as_sections'); + +drop view as_section_datax; +drop view as_section_datai cascade; +alter table as_section_data alter points type float; +select content_type__refresh_view('as_section_data');