[Aplaws-commit] r1014 - in trunk/ccm-cms: sql/ccm-cms/default/upgrade sql/ccm-cms/default/upgrade/6.3.0-6.3.1 sql/ccm-cms/upgrade src

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

Author: sskracic
Date: 2005-11-30 12:10:55 +0100 (Wed, 30 Nov 2005)
New Revision: 1014

Added:
   trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/
   trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql
   trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.3.0-6.3.1.sql
   trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.3.0-6.3.1.sql
Modified:
   trunk/ccm-cms/src/ccm-cms.upgrade
Log:
    Integrated patch [ 1368135 ] correction to privilege hierarchy
from sourceforge.


Added: trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql	2005-11-25 22:56:40 UTC (rev 1013)
+++ trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql	2005-11-30 11:10:55 UTC (rev 1014)
@@ -0,0 +1,26 @@
+--
+-- Copyright (C) 2005 Red Hat Inc. All Rights Reserved.
+--
+-- This library is free software; you can redistribute it and/or
+-- modify it under the terms of the GNU Lesser General Public License
+-- as published by the Free Software Foundation; either version 2.1 of
+-- the License, or (at your option) any later version.
+--
+-- This library is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+-- Lesser General Public License for more details.
+--
+-- You should have received a copy of the GNU Lesser General Public
+-- License along with this library; if not, write to the Free Software
+-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+--
+-- $Id$
+-- $DateTime: 2004/08/17 23:15:09 $
+
+-- set read as child of cms_read_item (so that a permission check
+-- on read will return objects with cms_read_item granted.
+-- all existing dnm... records are updated by trigger fired 
+-- by this insert
+insert into acs_privilege_hierarchy (privilege, child_privilege)
+values ('cms_read_item', 'read');


Property changes on: trunk/ccm-cms/sql/ccm-cms/default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL

Added: trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.3.0-6.3.1.sql	2005-11-25 22:56:40 UTC (rev 1013)
+++ trunk/ccm-cms/sql/ccm-cms/upgrade/oracle-se-6.3.0-6.3.1.sql	2005-11-30 11:10:55 UTC (rev 1014)
@@ -0,0 +1,24 @@
+--
+-- Copyright (C) 2005 Red Hat Inc. All Rights Reserved.
+--
+-- This library is free software; you can redistribute it and/or
+-- modify it under the terms of the GNU Lesser General Public License
+-- as published by the Free Software Foundation; either version 2.1 of
+-- the License, or (at your option) any later version.
+--
+-- This library is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+-- Lesser General Public License for more details.
+--
+-- You should have received a copy of the GNU Lesser General Public
+-- License along with this library; if not, write to the Free Software
+-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+--
+-- $Id$
+-- $DateTime: 2004/08/16 18:10:38 $
+
+PROMPT Red Hat Enterprise CMS 6.3.0 -> 6.3.1 Upgrade Script (Oracle)
+
+@@ ../default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql
+


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

Added: trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.3.0-6.3.1.sql	2005-11-25 22:56:40 UTC (rev 1013)
+++ trunk/ccm-cms/sql/ccm-cms/upgrade/postgres-6.3.0-6.3.1.sql	2005-11-30 11:10:55 UTC (rev 1014)
@@ -0,0 +1,27 @@
+--
+-- Copyright (C) 2005 Red Hat Inc. All Rights Reserved.
+--
+-- This library is free software; you can redistribute it and/or
+-- modify it under the terms of the GNU Lesser General Public License
+-- as published by the Free Software Foundation; either version 2.1 of
+-- the License, or (at your option) any later version.
+--
+-- This library is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+-- Lesser General Public License for more details.
+--
+-- You should have received a copy of the GNU Lesser General Public
+-- License along with this library; if not, write to the Free Software
+-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+--
+-- $Id$
+-- $DateTime: 2004/08/17 23:15:09 $
+
+\echo Red Hat Enterprise CMS 6.3.0 -> 6.3.1 Upgrade Script (PostgreSQL)
+
+begin;
+
+\i ../default/upgrade/6.3.0-6.3.1/update-privilege-hierarchy.sql
+
+commit;


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

Modified: trunk/ccm-cms/src/ccm-cms.upgrade
===================================================================
--- trunk/ccm-cms/src/ccm-cms.upgrade	2005-11-25 22:56:40 UTC (rev 1013)
+++ trunk/ccm-cms/src/ccm-cms.upgrade	2005-11-30 11:10:55 UTC (rev 1014)
@@ -8,4 +8,7 @@
   <version from="6.1.1" to="6.2.0">
     <script sql="ccm-cms/upgrade/::database::-6.1.1-6.2.0.sql"/>
   </version>
+  <version from="6.3.0" to="6.3.1">
+    <script sql="ccm-cms/upgrade/::database::-6.3.0-6.3.1.sql"/>
+  </version>
 </upgrade>