Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-communities-create.sql,v
diff -u -r1.27 -r1.28
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql	16 Mar 2002 02:02:07 -0000	1.27
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql	16 Mar 2002 18:59:03 -0000	1.28
@@ -63,6 +63,7 @@
 create or replace view dotlrn_communities_full
 as
     select dotlrn_communities.*,
+           dotlrn_community.url(dotlrn_communities.community_id) as url,
            groups.group_name,
            groups.join_policy
     from dotlrn_communities,
