Index: openacs-4/packages/dotlrn/sql/oracle/communities-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/communities-create.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql 7 Jun 2002 04:45:44 -0000 1.7 +++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql 20 Jun 2002 20:33:34 -0000 1.8 @@ -89,7 +89,7 @@ max_child_sortkey raw(3) ); -create index dtlrn_com_all_com_parent_id_idx on dotlrn_communities_all (community_id, parent_community_id; +create index dtlrn_com_all_com_par_id_idx on dotlrn_communities_all (community_id, parent_community_id; create index dtlrn_com_all_archived_p_idx on dotlrn_communities_all (archived_p); create or replace view dotlrn_communities