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