Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql	28 Sep 2021 12:46:49 -0000	1.1.2.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql	27 Oct 2021 12:47:54 -0000	1.1.2.2
@@ -11,6 +11,7 @@
 
 DROP VIEW acs_users_all;
 DROP VIEW cc_users;
+DROP VIEW registered_users_of_package_id;
 DROP VIEW registered_users;
 
 ALTER TABLE users ALTER COLUMN password TYPE character varying(128);
@@ -45,3 +46,12 @@
   and m.rel_type = 'membership_rel'
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
+
+--
+-- actually from acs-subsite (which is mandatory in acs-core)
+--
+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;