[Phpgroupware-cvs] phpgwapi/setup tables_update.inc.php

[Sigurd Nes]

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/03/13 13:46:48

Modified files:
        setup          : tables_update.inc.php 

Log message:
        Introducing ACL2

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/phpgwapi/setup/tables_update.inc.php.diff?tr1=1.85&tr2=1.86&r1=text&r2=text

Patches:
Index: phpgwapi/setup/tables_update.inc.php
diff -u phpgwapi/setup/tables_update.inc.php:1.85 
phpgwapi/setup/tables_update.inc.php:1.86
--- phpgwapi/setup/tables_update.inc.php:1.85   Mon Mar  6 14:21:10 2006
+++ phpgwapi/setup/tables_update.inc.php        Mon Mar 13 13:46:47 2006
@@ -5,7 +5,7 @@
        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
        * @package phpgwapi
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.85 2006/03/06 14:21:10 
skwashd Exp $
+       * @version $Id: tables_update.inc.php,v 1.86 2006/03/13 13:46:47 
sigurdne Exp $
        * @internal $Source: 
/sources/phpgwapi/phpgwapi/setup/tables_update.inc.php,v $
        */
 
@@ -1214,4 +1214,46 @@
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.17.501';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
+
+       $test[] = '0.9.17.501';
+       function phpgwapi_upgrade0_9_17_501()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_acl','acl_grantor',array(
+                       'type' => 'int',
+                       'precision' => '4',
+                       'nullable' => True
+               ));
+
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_acl','acl_type',array(
+                       'type' => 'int',
+                       'precision' => '2',
+                       'nullable' => True
+               ));
+
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'phpgw_acl_location', array(
+                               'fd' => array(
+                                       'appname' => array('type' => 
'varchar','precision' => '25','nullable' => False),
+                                       'id' => array('type' => 
'varchar','precision' => '50','nullable' => False),
+                                       'descr' => array('type' => 
'varchar','precision' => '50','nullable' => False),
+                                       'allow_grant' => array('type' => 
'int','precision' => '4','nullable' => True)
+                               ),
+                               'pk' => array('appname','id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_acl_location (appname,id, descr) VALUES ('hrm', '.', 'Top')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_acl_location (appname,id, descr, allow_grant) VALUES ('hrm', '.user', 
'User',1)");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_acl_location (appname,id, descr) VALUES ('hrm', '.job', 'Job 
description')");
+               
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.17.502';
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }
+
 ?>