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 -r1.17 -r1.18
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	28 Aug 2003 09:41:38 -0000	1.17
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	4 Sep 2003 15:47:51 -0000	1.18
@@ -146,6 +146,16 @@
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
+-- faster simpler view
+-- does not check for registered user/banned etc
+create or replace view all_users
+as
+select pa.*, pe.*, u.*
+from  parties pa, persons pe, users u
+where  pa.party_id = pe.person_id
+and pe.person_id = u.user_id;
+
+
 create view cc_users
 as
 select o.*, pa.*, pe.*, u.*, mr.member_state, mr.rel_id
