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.28 -r1.29
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql	16 Mar 2002 18:59:03 -0000	1.28
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-communities-create.sql	17 Mar 2002 19:54:18 -0000	1.29
@@ -60,16 +60,6 @@
     unique (community_key, parent_community_id)
 );
 
-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,
-         groups
-    where dotlrn_communities.community_id = groups.group_id;
-
 create or replace view dotlrn_communities_not_closed
 as
     select dotlrn_communities.*,
@@ -425,3 +415,14 @@
 end;
 /
 show errors
+
+
+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,
+         groups
+    where dotlrn_communities.community_id = groups.group_id;