Index: openacs-4/packages/calendar/sql/oracle/cal-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/cal-item-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/calendar/sql/oracle/cal-item-create.sql	16 Mar 2002 21:06:44 -0000	1.6
+++ openacs-4/packages/calendar/sql/oracle/cal-item-create.sql	17 Mar 2002 19:54:04 -0000	1.7
@@ -56,7 +56,7 @@
         on_which_calendar       integer
                                 constraint cal_item_which_cal_fk
                                 references calendars
-                                on delete cascade
+                                on delete cascade,
         item_type_id            integer,
         constraint cal_items_type_fk
         foreign key (on_which_calendar, item_type_id)
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;