Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d11-5.0d12.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d11-5.0d12.sql	6 Oct 2003 13:16:11 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d11-5.0d12.sql	22 Oct 2003 13:51:51 -0000	1.2
@@ -3,6 +3,14 @@
 --
 -- @author Peter Marklund
 
+-- Should have been added earlier, at least now we save the 4.6.3 - 5.0 upgrade
+create 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;
+
 drop function acs__remove_user (integer);
 create function acs__remove_user (integer)
 returns integer as '
