[Aplaws-commit] r970 - trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1

[<ssk...@vh...>]

Author: sskracic
Date: 2005-11-04 14:12:16 +0100 (Fri, 04 Nov 2005)
New Revision: 970

Modified:
   trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql
Log:
  Because of bug SF #1338725, deleting the original article would also delete
a row from object_context table belonging to the copy.  This fix re-creates
missing rows in object_context.


Modified: trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql	2005-10-31 15:27:52 UTC (rev 969)
+++ trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql	2005-11-04 13:12:16 UTC (rev 970)
@@ -8,3 +8,8 @@
       and context_id <> (select i3.parent_id from cms_items i3
                          where i3.item_id = object_context.object_id) ;
 
+insert into object_context (object_id, context_id)
+        select ci.item_id, ci.parent_id from cms_items ci
+            where ci.parent_id in (select bundle_id from cms_bundles)
+              and ci.item_id not in (select object_id from object_context) ;
+