Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-communities-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-create.sql	2 Jul 2002 19:53:51 -0000	1.6
+++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-communities-create.sql	3 Jul 2002 19:58:07 -0000	1.7
@@ -99,7 +99,7 @@
     max_child_sortkey		varbit
 );
 
-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 view dotlrn_communities
@@ -157,7 +157,7 @@
                                 constraint dotlrn_ca_community_id_nn
                                 not null
                                 constraint dotlrn_ca_community_id_fk
-                                references dotlrn_communities (community_id),
+                                references dotlrn_communities_all (community_id),
     applet_id                   integer
                                 constraint dotlrn_ca_applet_key_nn
                                 not null