Index: openacs-4/packages/acs-admin/www/users/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v
diff -u -N -r1.6 -r1.6.2.1
--- openacs-4/packages/acs-admin/www/users/one.xql	21 Feb 2002 17:13:17 -0000	1.6
+++ openacs-4/packages/acs-admin/www/users/one.xql	20 Apr 2002 22:23:44 -0000	1.6.2.1
@@ -26,7 +26,7 @@
 
 <fullquery name="all_group_membership">
   <querytext>
-    select groups.group_id, groups.group_name
+    select distinct lower(groups.group_name) as group_name
       from groups, group_member_map gm
      where groups.group_id = gm.group_id and gm.member_id=:user_id
   order by lower(groups.group_name)
Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql,v
diff -u -N -r1.12 -r1.12.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql	1 Dec 2001 17:55:16 -0000	1.12
+++ openacs-4/packages/acs-kernel/sql/postgresql/rel-constraints-create.sql	20 Apr 2002 22:23:44 -0000	1.12.2.1
@@ -269,44 +269,6 @@
 --             and rel_type = :rel_type
 --
 
--- create view rc_parties_in_required_segs as
--- select parties_in_required_segs.group_id,
---        parties_in_required_segs.rel_type,
---        parties_in_required_segs.party_id
--- from
---    (select required_segs.group_id, 
---            required_segs.rel_type, 
---            seg_parties.party_id,
---            count(*) as num_matching_segs
---     from rc_required_rel_segments required_segs,
---          rel_segment_party_map seg_parties
---     where required_segs.required_rel_segment = seg_parties.segment_id
---     group by required_segs.group_id, 
---              required_segs.rel_type, 
---              seg_parties.party_id) parties_in_required_segs,
---    (select group_id, rel_type, count(*) as total
---     from rc_required_rel_segments
---     group by group_id, rel_type) total_num_required_segs
--- where
---       parties_in_required_segs.group_id = total_num_required_segs.group_id
---   and parties_in_required_segs.rel_type = total_num_required_segs.rel_type
---   and parties_in_required_segs.num_matching_segs = total_num_required_segs.total
--- UNION ALL
--- select group_rel_type_combos.group_id,
---        group_rel_type_combos.rel_type,
---        parties.party_id
--- from rc_required_rel_segments, 
---     (select groups.group_id, comp_or_member_rel_types.rel_type
---       from groups,
---            (select object_type as rel_type from acs_object_types
---             start with object_type = 'membership_rel'
---                     or object_type = 'composition_rel'
--- --             connect by supertype = prior object_type) comp_or_member_rel_types
---      ) group_rel_type_combos,
---      parties
--- where rc_required_rel_segments.group_id(+) = group_rel_type_combos.group_id
---   and rc_required_rel_segments.rel_type(+) = group_rel_type_combos.rel_type
---   and rc_required_rel_segments.group_id is null;
 
 create view comp_or_member_rel_types as 
 select o.object_type as rel_type 
@@ -318,18 +280,19 @@
 select groups.group_id, comp_or_member_rel_types.rel_type
        from groups, comp_or_member_rel_types;
 
-
-create view parties_in_required_segs as 
-select required_segs.group_id, 
-           required_segs.rel_type, 
+create view parties_in_required_segs as
+select required_segs.group_id,
+           required_segs.rel_type,
            seg_parties.party_id,
+           seg_parties.segment_id,
            count(*) as num_matching_segs
     from rc_required_rel_segments required_segs,
          rel_segment_party_map seg_parties
     where required_segs.required_rel_segment = seg_parties.segment_id
-    group by required_segs.group_id, 
-             required_segs.rel_type, 
-             seg_parties.party_id;
+    group by required_segs.group_id,
+             required_segs.rel_type,
+             seg_parties.party_id,
+             seg_parties.segment_id;
 
 create view total_num_required_segs as 
 select group_id, rel_type, count(*) as total
Index: openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql,v
diff -u -N -r1.3 -r1.3.2.1
--- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	10 Oct 2001 18:06:15 -0000	1.3
+++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql	20 Apr 2002 22:23:44 -0000	1.3.2.1
@@ -10,10 +10,13 @@
 \i attribute.sql
 \i portraits.sql
 \i application-groups-create.sql
-\i user-profiles-create.sql
 \i subsite-callbacks-create.sql
 \i host-node-map-create.sql
 
+-- DRB: user profiles are fundamentally broken, which is probably why they
+-- weren't created in the original ACS 4.2 Oracle sources. 
+-- \i user-profiles-create.sql
+
 -- This view lets us avoid using acs_object.name to get party_names.
 -- 
 -- create or replace view party_names