[Aplaws-commit] r974 - trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.1.1-6.2.0

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

Author: sskracic
Date: 2005-11-07 15:20:51 +0100 (Mon, 07 Nov 2005)
New Revision: 974

Modified:
   trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.1.1-6.2.0/fix-live-folder-security-context.sql
Log:
  The upgrade (actually the bug-fix script) should also delete all
permission records that were result of the 'use custom permissions'
bug that had been fixed at r954.


Modified: trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.1.1-6.2.0/fix-live-folder-security-context.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.1.1-6.2.0/fix-live-folder-security-context.sql	2005-11-07 09:27:08 UTC (rev 973)
+++ trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.1.1-6.2.0/fix-live-folder-security-context.sql	2005-11-07 14:20:51 UTC (rev 974)
@@ -5,3 +5,10 @@
       select f.folder_id from cms_folders f, cms_items ci
       where f.folder_id = ci.item_id  and ci.version = 'live'
   ) ;
+
+delete from acs_permissions
+  where object_id in (
+      select f.folder_id from cms_folders f, cms_items ci
+      where f.folder_id = ci.item_id  and ci.version = 'live'
+  ) ;
+