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.4 -r1.5
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql	6 Nov 2001 21:46:48 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-classes-create.sql	7 Nov 2001 20:20:55 -0000	1.5
@@ -17,6 +17,8 @@
 				    primary key
 );
 
+create view dotlrn_classes_full as select class_key, pretty_name, description, package_id, supertype from dotlrn_classes, dotlrn_community_types where dotlrn_community_types.community_type=dotlrn_classes.class_key;
+
 create table dotlrn_class_instances (
        class_instance_id	    constraint dotlrn_class_i_id_fk
 				    references dotlrn_communities(community_id)
@@ -28,8 +30,10 @@
        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;
 
 
+
 -- 
 -- PL/SQL stuff
 --