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 -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
 --
