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.1 -r1.2 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql 6 Aug 2006 16:51:36 -0000 1.1 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.20-0.21.sql 15 Aug 2006 01:44:05 -0000 1.2 @@ -6,4 +6,5 @@ -- @cvs-id $Id$ -- -update cr_revisions set content=title where item_id in (select item_id from cr_items where content_type='as_items'); \ No newline at end of file +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 Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.20-0.21.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.20-0.21.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.20-0.21.sql 6 Aug 2006 16:51:36 -0000 1.1 +++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.20-0.21.sql 15 Aug 2006 01:44:05 -0000 1.2 @@ -6,4 +6,5 @@ -- @cvs-id $Id$ -- -update cr_revisions set content=title where item_id in (select item_id from cr_items where content_type='as_items'); \ No newline at end of file +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='text' where content_type='as_items'; \ No newline at end of file