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.34 -r1.35
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	9 Dec 2001 04:21:58 -0000	1.34
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	16 Jan 2002 20:07:23 -0000	1.35
@@ -205,6 +205,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_sortkey_idx on cr_items(tree_sortkey);
 
 -- content-create.sql patch
 --