Index: openacs-4/packages/dotlrn/sql/oracle/classes-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/classes-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/dotlrn/sql/oracle/classes-create.sql 13 May 2002 19:46:18 -0000 1.2 +++ openacs-4/packages/dotlrn/sql/oracle/classes-create.sql 30 May 2002 22:04:58 -0000 1.3 @@ -15,12 +15,8 @@ -- -- --- The DotLRN basic system --- copyright 2001, OpenForce, inc. --- distributed under the GNU GPL v2 +-- create the dotLRN classes model -- --- for Oracle 8/8i. (We're guessing 9i works, too). --- -- @author Ben Adida (ben@openforce.net) -- @author yon (yon@openforce.net) -- @creation-date 2001-08-18 @@ -120,15 +116,7 @@ dotlrn_terms.term_year, dotlrn_terms.start_date, dotlrn_terms.end_date, - dotlrn_communities.community_type, - dotlrn_communities.community_key, - dotlrn_communities.pretty_name, - dotlrn_communities.description, - dotlrn_communities.active_start_date, - dotlrn_communities.active_end_date, - dotlrn_communities.portal_id, - dotlrn_communities.non_member_portal_id, - dotlrn_communities.package_id, + 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,