Index: openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql	28 Aug 2003 09:41:38 -0000	1.2
+++ openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql	27 Jul 2006 20:09:33 -0000	1.3
@@ -306,15 +306,15 @@
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_child_rel',
    attribute_name => 'parent_id',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Parent ID',
    pretty_plural => 'Parent IDs'
  );
 
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_child_rel',
    attribute_name => 'child_id',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Child ID',
    pretty_plural => 'Child IDs'
  );
@@ -330,7 +330,7 @@
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_child_rel',
    attribute_name => 'order_n',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Sort Order',
    pretty_plural => 'Sort Orders'
  );
@@ -348,15 +348,15 @@
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_rel',
    attribute_name => 'item_id',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Item ID',
    pretty_plural => 'Item IDs'
  );
 
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_rel',
    attribute_name => 'related_object_id',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Related Object ID',
    pretty_plural => 'Related Object IDs'
  );
@@ -372,7 +372,7 @@
  attr_id := acs_attribute.create_attribute (
    object_type => 'cr_item_rel',
    attribute_name => 'order_n',
-   datatype => 'text',
+   datatype => 'integer',
    pretty_name => 'Sort Order',
    pretty_plural => 'Sort Orders'
  );