Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql	28 Aug 2003 09:41:39 -0000	1.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6.3-4.6.4.sql	21 Apr 2004 11:07:21 -0000	1.2.4.1
@@ -26,7 +26,7 @@
 
 -- recreate the registered_users view
 
-drop view registered_users;
+drop view registered_users CASCADE;
 
 create view registered_users
 as
@@ -41,10 +41,15 @@
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
+create view registered_users_of_package_id
+as
+SELECT u.*, au.package_id
+FROM application_users au, registered_users u
+WHERE (au.user_id = u.user_id);
 
 -- recreate the cc_users view
 
-drop view cc_users;
+drop view cc_users CASCADE;
 
 create view cc_users
 as
@@ -59,6 +64,13 @@
   and m.rel_id = mr.rel_id
   and m.container_id = m.group_id;
 
+create view cc_users_of_package_id
+as
+SELECT u.*, au.package_id
+FROM application_users au, cc_users u
+WHERE (au.user_id = u.user_id);
+
+
 -- Fixing a really lame = null bug in this proc that would cause default values
 -- of new parameters to not be propagated to package instances
 create or replace function apm__register_parameter (integer,varchar,varchar,varchar,varchar,varchar,varchar,integer,integer)
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql	26 Jan 2004 15:39:45 -0000	1.4
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql	21 Apr 2004 11:07:21 -0000	1.4.2.1
@@ -772,7 +772,7 @@
 
 ---- DRB: fixes bug 1144
 
-drop view registered_users;
+drop view registered_users CASCADE;
 create view registered_users
 as
   select p.email, p.url, pe.first_names, pe.last_name, u.*, mr.member_state
@@ -788,8 +788,13 @@
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
+create view registered_users_of_package_id
+as
+SELECT u.*, au.package_id
+FROM application_users au, registered_users u
+WHERE (au.user_id = u.user_id);
 
-drop view cc_users;
+drop view cc_users CASCADE;
 create view cc_users
 as
 select o.*, pa.*, pe.*, u.*, mr.member_state, mr.rel_id
@@ -804,6 +809,12 @@
   and m.container_id = m.group_id
   and m.rel_type = 'membership_rel';
 
+create view cc_users_of_package_id
+as
+SELECT u.*, au.package_id
+FROM application_users au, cc_users u
+WHERE (au.user_id = u.user_id);
+
 drop function acs__add_user(int4,varchar,timestamptz,int4,varchar,varchar,varchar,varchar,varchar,bpchar,bpchar,varchar,varchar,varchar,bool,varchar);
 
 create or replace function acs__add_user (
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql,v
diff -u -r1.11 -r1.11.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql	26 Jan 2004 15:39:45 -0000	1.11
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql	21 Apr 2004 11:07:21 -0000	1.11.2.1
@@ -237,7 +237,7 @@
 alter table users add constraint users_authority_username_un
                       unique (authority_id, username);
 
-drop view cc_users;
+drop view cc_users CASCADE;
 create view cc_users
 as
 select o.*, pa.*, pe.*, u.*, mr.member_state, mr.rel_id
@@ -250,3 +250,9 @@
   and m.group_id = amo.object_id
   and m.rel_id = mr.rel_id
   and m.container_id = m.group_id;
+
+create view cc_users_of_package_id
+as
+SELECT u.*, au.package_id
+FROM application_users au, cc_users u
+WHERE (au.user_id = u.user_id);