[Aplaws-commit] r968 - in trunk/ccm-cms/sql/ccm-cms: default/upgrade default/upgrade/6.2.0-6.2.1 upgrade

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

Author: sskracic
Date: 2005-10-28 21:20:29 +0200 (Fri, 28 Oct 2005)
New Revision: 968

Added:
   trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/
   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/upgrade/oracle-se-6.2.0-6.2.1.sql
   trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.2.0-6.2.1.sql
Log:
  The SQL script that fixes all inconsistencies in security context
of items originating from the copy operation.


Added: 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-28 18:13:43 UTC (rev 967)
+++ trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql	2005-10-28 19:20:29 UTC (rev 968)
@@ -0,0 +1,10 @@
+
+update object_context set
+    context_id = (select ci.parent_id from cms_items ci
+                  where ci.item_id = object_context.object_id)
+    where
+      object_id in (select i2.item_id from cms_items i2
+                    where i2.parent_id in (select bundle_id from cms_bundles))
+      and context_id <> (select i3.parent_id from cms_items i3
+                         where i3.item_id = object_context.object_id) ;
+


Property changes on: trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL

Added: trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.2.0-6.2.1.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.2.0-6.2.1.sql	2005-10-28 18:13:43 UTC (rev 967)
+++ trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.2.0-6.2.1.sql	2005-10-28 19:20:29 UTC (rev 968)
@@ -0,0 +1,3 @@
+
+@@ ../default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql
+


Property changes on: trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.2.0-6.2.1.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL

Added: trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.2.0-6.2.1.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.2.0-6.2.1.sql	2005-10-28 18:13:43 UTC (rev 967)
+++ trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.2.0-6.2.1.sql	2005-10-28 19:20:29 UTC (rev 968)
@@ -0,0 +1,5 @@
+begin;
+
+\i ../default/upgrade/6.2.0-6.2.1/fix-article-security-context.sql
+
+commit;


Property changes on: trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.2.0-6.2.1.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL