Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -N -r1.44 -r1.44.2.1
--- openacs-4/packages/assessment/assessment.info	27 Jun 2007 22:45:26 -0000	1.44
+++ openacs-4/packages/assessment/assessment.info	1 Jun 2008 13:35:39 -0000	1.44.2.1
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="0.22d5" url="http://openacs.org/repository/download/apm/assessment-0.22d5.apm">
+    <version name="0.22d6" url="http://openacs.org/repository/download/apm/assessment-0.22d6.apm">
         <owner url="mailto:eperez@it.uc3m.es">Eduardo Perez Ureta</owner>
         <summary>Assessment package that will replace the survey,
     quizz, complex survey, poll and other data collection packages
@@ -18,7 +18,7 @@
         <maturity>0</maturity>
         <package_instance_name>#assessment.Assessment#</package_instance_name>
 
-        <provides url="assessment" version="0.22d5"/>
+        <provides url="assessment" version="0.22d6"/>
         <requires url="acs-content-repository" version="5.3.1a1"/>
         <requires url="acs-kernel" version="5.3.1a1"/>
         <requires url="acs-templating" version="5.3.1a1"/>
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 -N -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');
Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d5-0.22d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d5-0.22d6.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.22d5-0.22d6.sql	1 Jun 2008 13:35:39 -0000	1.1.2.1
@@ -0,0 +1,5 @@
+-- upgrade the column size
+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');
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql,v
diff -u -N -r1.2 -r1.2.4.1
--- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	12 Jun 2006 02:49:50 -0000	1.2
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	1 Jun 2008 13:35:39 -0000	1.2.4.1
@@ -1,20 +1,18 @@
 -- upgrade the column size
-drop view as_assessmentsx;
-drop view as_assessmentsi;
 
 alter table as_assessments rename entry_page to entry_page_old;
 alter table as_assessments add entry_page varchar(4000);
 update as_assessments set entry_page = entry_page_old;
-alter table as_assessments drop entry_page_old;
+alter table as_assessments drop entry_page_old cascade;
 
 alter table as_assessments rename exit_page to exit_page_old;
 alter table as_assessments add exit_page varchar(4000);
 update as_assessments set exit_page = exit_page_old;
-alter table as_assessments drop exit_page_old;
+alter table as_assessments drop exit_page_old cascade;
 
 alter table as_assessments rename return_url to return_url_old;
 alter table as_assessments add return_url varchar(4000);
 update as_assessments set return_url = return_url_old;
-alter table as_assessments drop return_url_old;
+alter table as_assessments drop return_url_old cascade;
 
-select content_type__refresh_view('as_assessments');
\ No newline at end of file
+select content_type__refresh_view('as_assessments');
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql	1 Jun 2008 13:35:39 -0000	1.1.2.1
@@ -0,0 +1,18 @@
+-- upgrade the column size
+
+alter table as_assessments rename entry_page to entry_page_old;
+alter table as_assessments add entry_page varchar(4000);
+update as_assessments set entry_page = entry_page_old;
+alter table as_assessments drop entry_page_old cascade;
+
+alter table as_assessments rename exit_page to exit_page_old;
+alter table as_assessments add exit_page varchar(4000);
+update as_assessments set exit_page = exit_page_old;
+alter table as_assessments drop exit_page_old cascade;
+
+alter table as_assessments rename return_url to return_url_old;
+alter table as_assessments add return_url varchar(4000);
+update as_assessments set return_url = return_url_old;
+alter table as_assessments drop return_url_old cascade;
+
+select content_type__refresh_view('as_assessments');