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.9 -r1.10
--- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	25 Jun 2002 22:21:16 -0000	1.9
+++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	28 Jun 2002 19:50:44 -0000	1.10
@@ -83,7 +83,7 @@
     max_child_sortkey           raw(3)
 );
 
-create index dtlrn_com_all_com_par_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