Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-community-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/Attic/dotlrn-community-memberships-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-community-memberships-create.sql	7 Mar 2002 22:22:44 -0000	1.7
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-community-memberships-create.sql	13 Mar 2002 00:11:35 -0000	1.8
@@ -107,6 +107,23 @@
          acs_rels
     where dotlrn_ca_rels.rel_id = acs_rels.rel_id;
 
+create table dotlrn_cadmin_rels (
+    rel_id                      constraint dotlrn_cadmin_rels_rel_id_fk
+                                references dotlrn_admin_rels (rel_id)
+                                constraint dotlrn_cadmin_rels_rel_id_pk
+                                primary key
+);
+
+create or replace view dotlrn_cadmin_rels_full
+as
+    select acs_rels.rel_id,
+           acs_rels.object_id_one as community_id,
+           acs_rels.object_id_two as user_id,
+           acs_rels.rel_type
+    from dotlrn_cadmin_rels,
+         acs_rels
+    where dotlrn_cadmin_rels.rel_id = acs_rels.rel_id;
+
 create table dotlrn_instructor_rels (
     rel_id                      constraint dotlrn_instructor_rels_rel_fk
                                 references dotlrn_admin_rels(rel_id)
