Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.26 -r1.27
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	26 Sep 2006 14:55:28 -0000	1.26
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	29 Aug 2007 18:28:15 -0000	1.27
@@ -273,7 +273,8 @@
 
 create index cr_child_rels_by_parent on cr_child_rels(parent_id);
 create unique index cr_child_rels_unq_id on cr_child_rels(parent_id, child_id);
-
+CREATE UNIQUE INDEX CR_CHILD_RELS_kids_IDx ON CR_CHILD_RELS(CHILD_ID);
+    
 comment on table cr_child_rels is '
   Provides for richer parent-child relationships than the simple
   link encapsulated in the primary table.  May be subclassed to provide
