Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v
diff -u -N -r1.23 -r1.24
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	26 Nov 2003 22:47:11 -0000	1.23
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	3 Dec 2003 23:38:27 -0000	1.24
@@ -155,6 +155,7 @@
   and amo.name = 'registered_users'
   and m.group_id = amo.object_id
   and m.container_id = m.group_id
+  and m.rel_type = 'membership_rel'
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
@@ -179,6 +180,7 @@
   and amo.name = 'registered_users'
   and m.group_id = amo.object_id
   and m.rel_id = mr.rel_id
+  and m.rel_type = 'membership_rel'
   and m.container_id = m.group_id;