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 -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d6-0.22d7.sql	2 Sep 2008 01:21:08 -0000	1.1
@@ -0,0 +1,22 @@
+
+alter table as_item_data rename column points to points_int;
+alter table as_item_data add points float;
+update as_item_data set points=points_int;
+alter table as_item_data drop column points_int;
+
+begin
+content_type.refresh_view('as_item_data');
+end;
+/
+show errors;
+
+alter table as_session_results rename column points to points_int;
+alter table as_session_results add points float;
+update as_session_results set points=points_int;
+alter table as_session_results drop column points_int;
+
+begin
+content_type.refresh_view('as_session_results');
+end;
+/
+show errors;
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
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d6-0.22d7.sql	2 Sep 2008 01:21:08 -0000	1.1
@@ -0,0 +1,9 @@
+drop view as_item_datax;
+drop view as_item_datai cascade;
+alter table as_item_data alter points type float;
+select content_type__refresh_view('as_item_data');
+
+drop view as_session_resultsx;
+drop view as_session_resultsi cascade;
+alter table as_session_results alter points type float;
+select content_type__refresh_view('as_session_results');