Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql 12 Jun 2006 02:49:50 -0000 1.2 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.17-0.18.sql 1 Jun 2008 13:35:39 -0000 1.2.4.1 @@ -1,7 +1,5 @@ -- upgrade the column size -drop view as_assessmentsx; -drop view as_assessmentsi; -alter table as_assessments alter column entry_page type varchar(4000); -alter table as_assessments alter column exit_page type varchar(4000); -alter table as_assessments alter column return_url type varchar(4000); -select content_type__refresh_view('as_assessments'); \ No newline at end of file +alter table as_assessments modify entry_page varchar(4000); +alter table as_assessments modify exit_page varchar(4000); +alter table as_assessments modify return_url varchar(4000); +select content_type.refresh_view('as_assessments');