Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.117.2.6 -r1.117.2.7
--- openacs-4/packages/acs-content-repository/acs-content-repository.info	28 Apr 2020 13:29:41 -0000	1.117.2.6
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info	24 Mar 2021 10:09:58 -0000	1.117.2.7
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="5.10.0d12" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.0d12.apm">
+    <version name="5.10.0d13" url="http://openacs.org/repository/download/apm/acs-content-repository-5.10.0d13.apm">
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
         <owner url="http://openacs.org">OpenACS</owner>
@@ -21,7 +21,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-content-repository" version="5.10.0d12"/>
+        <provides url="acs-content-repository" version="5.10.0d13"/>
         <requires url="acs-kernel" version="5.9.1"/>
         <requires url="acs-service-contract" version="5.9.1"/>
         <requires url="acs-tcl" version="5.10.0d9"/>
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.31.2.1 -r1.31.2.2
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	14 Aug 2019 07:34:34 -0000	1.31.2.1
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	24 Mar 2021 10:09:58 -0000	1.31.2.2
@@ -191,8 +191,16 @@
                       constraint cr_items_storage_type_ck
                       check (storage_type in ('lob','file')),
   storage_area_key    varchar2(100) default 'CR_FILES' not null
-);  
+);
 
+--
+-- Avoid potential loops on parent_ids. An item must not be equal to
+-- its own parent.  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 cr_items ADD CONSTRAINT cr_items_parent_id_ck CHECK (item_id != parent_id);
+
 create index cr_items_by_locale on cr_items(locale);
 create index cr_items_by_content_type on cr_items(content_type);
 create unique index cr_items_by_live_revision on cr_items(live_revision);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.65.2.1 -r1.65.2.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	14 Aug 2019 07:34:35 -0000	1.65.2.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	24 Mar 2021 10:09:58 -0000	1.65.2.2
@@ -197,8 +197,16 @@
   storage_area_key    varchar(100) default 'CR_FILES' not null,
   tree_sortkey        varbit not null,
   max_child_sortkey   varbit
-);  
+);
 
+--
+-- Avoid potential loops on parent_ids. An item must not be equal to
+-- its own parent.  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 cr_items ADD CONSTRAINT cr_items_parent_id_ck CHECK (item_id != parent_id);
+
 create index cr_items_by_locale on cr_items(locale);
 create index cr_items_by_content_type on cr_items(content_type);
 create unique index cr_items_by_live_revision on cr_items(live_revision);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql'.
Fisheye: No comparison available.  Pass `N' to diff?