Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.150.2.28 -r1.150.2.29
--- openacs-4/packages/acs-kernel/acs-kernel.info	24 Mar 2021 09:51:12 -0000	1.150.2.28
+++ openacs-4/packages/acs-kernel/acs-kernel.info	24 Mar 2021 17:00:08 -0000	1.150.2.29
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.0d31" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d31.apm">
+    <version name="5.10.0d32" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d32.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2017-08-06</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.0d31"/>
+        <provides url="acs-kernel" version="5.10.0d32"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql,v
diff -u -r1.11.2.1 -r1.11.2.2
--- openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	14 Aug 2019 07:31:43 -0000	1.11.2.1
+++ openacs-4/packages/acs-kernel/sql/oracle/site-nodes-create.sql	24 Mar 2021 17:00:08 -0000	1.11.2.2
@@ -46,6 +46,15 @@
                         references acs_objects (object_id)
 );
 
+--
+-- Avoid potential loops on site_node parent_ids. A parent_id must be
+-- different from the node_id. 
+-- Note that this constraint is not guaranteed to avoid all loops; 
+-- it is still possible to create indirect recursive
+-- loops but excludes some real-world problems.
+--
+ALTER TABLE site_nodes ADD CONSTRAINT site_nodes_parent_id_ck CHECK (node_id <> parent_id);
+
 create index site_nodes_object_id_idx on site_nodes (object_id);
 create index site_nodes_parent_obj_node_idx on site_nodes(parent_id, object_id, node_id);
 create index site_nodes_parent_id_idx on site_nodes(parent_id);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.0d31-5.10.0d32.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql,v
diff -u -r1.30.2.4 -r1.30.2.5
--- openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	14 Mar 2020 19:06:24 -0000	1.30.2.4
+++ openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql	24 Mar 2021 17:00:08 -0000	1.30.2.5
@@ -61,6 +61,15 @@
                         references acs_objects (object_id)
 );
 
+--
+-- Avoid potential loops on site_node parent_ids. A parent_id must be
+-- different from the node_id. 
+-- Note that this constraint is not guaranteed to avoid all loops; 
+-- it is still possible to create indirect recursive
+-- loops but excludes some real-world problems.
+--
+ALTER TABLE site_nodes ADD CONSTRAINT site_nodes_parent_id_ck CHECK (node_id <> parent_id);
+
 create index site_nodes_object_id_idx on site_nodes (object_id);
 create index site_nodes_parent_object_node_id_idx on site_nodes(parent_id, object_id, node_id);
 create index site_nodes_parent_id_idx on site_nodes(parent_id);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d31-5.10.0d32.sql'.
Fisheye: No comparison available.  Pass `N' to diff?