Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-classes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-classes-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-classes-create.sql	2 Jul 2002 18:40:08 -0000	1.3
+++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-classes-create.sql	3 Jul 2002 19:58:07 -0000	1.4
@@ -103,7 +103,7 @@
 create table dotlrn_class_instances (
     class_instance_id           integer 
 				constraint dotlrn_ci_class_instance_id_fk
-                                references dotlrn_communities (community_id)
+                                references dotlrn_communities_all (community_id)
                                 constraint dotlrn_class_instances_pk
                                 primary key,
     class_key                   varchar(100) 
@@ -127,7 +127,7 @@
            dotlrn_terms.term_year,
            dotlrn_terms.start_date,
            dotlrn_terms.end_date,
-           dotlrn_communities.*
+           dotlrn_communities.*,
            dotlrn_community__url(dotlrn_communities.community_id) as url,
            dotlrn_classes_full.pretty_name as class_name,
            dotlrn_classes_full.url as class_url,