Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql	15 Aug 2006 01:44:05 -0000	1.2
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql	26 Sep 2006 00:22:45 -0000	1.3
@@ -7,4 +7,12 @@
 --
 
 update cr_revisions set content=title where item_id in (select item_id from cr_items where content_type='as_items');
-update cr_items set storage_type='lob' where content_type='as_items';
\ No newline at end of file
+update cr_items set storage_type='lob' where content_type='as_items';
+
+alter table as_assessments rename type to type_int;
+alter table as_assessments add type varchar2(1000);
+update as_assessments set type='survey' where type_int = 1;
+update as_assessments set type='test' where type_int = 2;
+alter table as_assessments drop type_int;
+update acs_attributes set datatype='string' where attribute_name='type' and object_type='as_assessments';
+