Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-classes-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql	9 Nov 2001 15:24:57 -0000	1.6
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql	20 Nov 2001 20:21:50 -0000	1.7
@@ -30,7 +30,7 @@
        term			    varchar(20)
 );
 
-create view dotlrn_class_instances_full as select class_instance_id, class_key, year, term, community_key, pretty_name, description, package_id from dotlrn_class_instances, dotlrn_communities where dotlrn_class_instances.class_instance_id = dotlrn_communities.community_id;
+create view dotlrn_class_instances_full as select class_instance_id, class_key, year, term, community_key, pretty_name, description, portal_template_id package_id from dotlrn_class_instances, dotlrn_communities where dotlrn_class_instances.class_instance_id = dotlrn_communities.community_id;
 
 
 
