Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/rel-segments/constraints/one-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/rel-segments/constraints/one-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/constraints/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/constraints/one.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/admin/rel-segments/constraints/one.xql	14 Jun 2018 15:29:07 -0000	1.1
@@ -0,0 +1,52 @@
+<?xml version="1.0"?>
+
+<queryset>
+  
+  <fullquery name="select_constraint_properties">      
+    <querytext>
+      
+    select c.constraint_id,
+           c.constraint_name,
+           c.rel_side, 
+           s.segment_id,
+           s.segment_name,
+           s.rel_type,
+           (select group_name from groups
+             where group_id = s.group_id) as group_name,
+           s2.segment_id as req_segment_id,
+           s2.segment_name as req_segment_name, 
+           s2.rel_type as req_rel_type,
+           (select group_name from groups
+             where group_id = s2.group_id) as group_name,           
+      from application_group_segments s,
+           application_group_segments s2,
+           rel_constraints c
+     where s.segment_id = c.rel_segment
+       and s2.segment_id = c.required_rel_segment
+       and c.constraint_id = :constraint_id
+       and s.package_id = :package_id
+
+    </querytext>
+  </fullquery>
+
+  
+  <fullquery name="select_rel_type_info">      
+    <querytext>
+
+    select role1.role as role_one, 
+           coalesce(role1.pretty_name,'Object on side one') as role_one_pretty_name,
+           coalesce(role1.pretty_plural,'Objects on side one') as role_one_pretty_plural,
+           role2.role as role_two, 
+           coalesce(role2.pretty_name,'Object on side two') as role_two_pretty_name,
+           coalesce(role2.pretty_plural,'Objects on side two') as role_two_pretty_plural,
+           (select pretty_name from acs_object_types
+             where object_type = rel.rel_type) as rel_type_pretty_name
+      from acs_rel_types rel
+	     left outer join  acs_rel_roles role1 on (rel.role_one = role1.role)
+	     left outer join  acs_rel_roles role2 on (rel.role_two = role2.role)
+     where rel.rel_type = :rel_type
+
+    </querytext>
+  </fullquery>
+  
+</queryset>