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 -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 -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 -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