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.21 -r1.22
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	30 Sep 2003 12:10:01 -0000	1.21
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	13 Jan 2005 13:55:07 -0000	1.22
@@ -219,6 +219,7 @@
 create unique index cr_items_unique_name on cr_items(parent_id, name);
 create unique index cr_items_unique_id on cr_items(parent_id, item_id);
 create index cr_items_by_parent_id on cr_items(parent_id);
+create index cr_items_name on cr_items(name);
 
 comment on table cr_items is '
   Each content item has a row in this table, as well as a row in
