Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.10.0d8-5.10.0d9.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/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/oracle/upgrade/upgrade-5.10.0d8-5.10.0d9.sql	4 Mar 2020 18:50:50 -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';
+
+commit;