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 -N -r1.21 -r1.21.4.1
--- 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	6 Sep 2004 16:43:47 -0000	1.21.4.1
@@ -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
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -N -r1.43.2.1 -r1.43.2.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	6 May 2004 00:12:43 -0000	1.43.2.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	6 Sep 2004 16:43:48 -0000	1.43.2.2
@@ -231,6 +231,7 @@
 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_sortkey_idx on cr_items(tree_sortkey);
+create index cr_items_name on cr_items(name);
 
 -- content-create.sql patch
 --