Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -N -r1.150.2.21 -r1.150.2.22
--- openacs-4/packages/acs-kernel/acs-kernel.info	15 Nov 2019 14:43:09 -0000	1.150.2.21
+++ openacs-4/packages/acs-kernel/acs-kernel.info	4 Mar 2020 18:15:32 -0000	1.150.2.22
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.0d24" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d24.apm">
+    <version name="5.10.0d25" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d25.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2017-08-06</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.0d24"/>
+        <provides url="acs-kernel" version="5.10.0d25"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d24-5.10.0d25.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.10.0d24-5.10.0d25.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d24-5.10.0d25.sql	4 Mar 2020 18:15:32 -0000	1.1.2.1
@@ -0,0 +1,18 @@
+--
+-- Attribute datatype discrepancy fix for object_types in OpenACS:
+--
+-- Some attribute datatypes where modified in 2006, but an upgrade script
+-- adjusting the already existing ones was never done. This one tries to fix this.
+--
+-- Original datatype change:
+-- https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933
+-- https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb
+--
+
+begin;
+
+update acs_attributes set datatype='boolean' where object_type='apm_package_version' and attribute_name='enabled_p';
+update acs_attributes set datatype='date' where object_type='apm_package_version' and attribute_name='deactivation_date';
+update acs_attributes set datatype='date' where object_type='apm_parameter' and attribute_name='max_n_values';
+
+end;
Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -N -r1.117.2.2 -r1.117.2.3
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	13 Dec 2019 15:02:11 -0000	1.117.2.2
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	4 Mar 2020 18:23:41 -0000	1.117.2.3
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.10.0d8" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.0d8.apm">
+    <version name="5.10.0d9" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.0d9.apm">
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
         <owner url="http://openacs.org">OpenACS</owner>
@@ -21,7 +21,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-content-repository" version="5.10.0d8"/>
+        <provides url="acs-content-repository" version="5.10.0d9"/>
         <requires url="acs-kernel" version="5.9.1"/>
         <requires url="acs-service-contract" version="5.9.1"/>
         <requires url="acs-tcl" version="5.10.0d9"/>
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.10.0d8-5.10.0d9.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/Attic/upgrade-5.10.0d8-5.10.0d9.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.10.0d8-5.10.0d9.sql	4 Mar 2020 18:23:41 -0000	1.1.2.1
@@ -0,0 +1,21 @@
+--
+-- Attribute datatype discrepancy fix for object_types in OpenACS:
+--
+-- Some attribute datatypes where modified in 2006, but an upgrade script
+-- adjusting the already existing ones was never done. This one tries to fix this.
+--
+-- Original datatype change:
+-- https://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Avictorg%3A20060727200933
+-- https://github.com/openacs/openacs-core/commit/7e30fa270483dcbc866ffbf6f5cf4f30447987cb
+--
+
+begin;
+
+update acs_attributes set datatype='integer' where object_type='cr_item_child_rel' and attribute_name='parent_id';
+update acs_attributes set datatype='integer' where object_type='cr_item_child_rel' and attribute_name='child_id';
+update acs_attributes set datatype='integer' where object_type='cr_item_child_rel' and attribute_name='order_n';
+update acs_attributes set datatype='integer' where object_type='cr_item_rel' and attribute_name='item_id';
+update acs_attributes set datatype='integer' where object_type='cr_item_rel' and attribute_name='related_object_id';
+update acs_attributes set datatype='integer' where object_type='cr_item_rel' and attribute_name='order_n';
+
+end;