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

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Changes by:     Sigurd Nes <sigurdne>   06/11/02 09:53:30

Modified files:
        setup          : tables_update.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/property/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.60&r2=1.61

Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgroupware/property/setup/tables_update.inc.php,v
retrieving revision 1.60
retrieving revision 1.61
diff -u -b -r1.60 -r1.61
--- tables_update.inc.php       31 Oct 2006 19:13:11 -0000      1.60
+++ tables_update.inc.php       2 Nov 2006 09:53:30 -0000       1.61
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.60 2006/10/31 19:13:11 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.61 2006/11/02 09:53:30 
sigurdne Exp $
        */
 
        /**
@@ -1636,6 +1636,18 @@
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_owner','owner_id', array('type' 
=> 'int','precision' => '4','nullable' => True));
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_vendor','owner_id', array('type' 
=> 'int','precision' => '4','nullable' => True));
 
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_tenant set 
owner_id = 6");
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_owner set 
owner_id = 6");
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_vendor set 
owner_id = 6");
+               
+               $GLOBALS['phpgw_setup']->oProc->query("DELETE FROM fm_cache");
+               $GLOBALS['phpgw_setup']->oProc->query("DELETE FROM phpgw_acl 
WHERE acl_appname = 'property' AND acl_location = '.tenant' AND acl_grantor IS 
NOT NULL");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl 
(acl_appname, acl_location, acl_account, acl_rights, acl_grantor, acl_type) 
VALUES ('property', '.tenant', '1', '1', '6', '0')");
+               $GLOBALS['phpgw_setup']->oProc->query("DELETE FROM phpgw_acl 
WHERE acl_appname = 'property' AND acl_location = '.owner' AND acl_grantor IS 
NOT NULL");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl 
(acl_appname, acl_location, acl_account, acl_rights, acl_grantor, acl_type) 
VALUES ('property', '.owner', '1', '1','6', '0')");
+               $GLOBALS['phpgw_setup']->oProc->query("DELETE FROM phpgw_acl 
WHERE acl_appname = 'property' AND acl_location = '.vendor' AND acl_grantor IS 
NOT NULL");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO phpgw_acl 
(acl_appname, acl_location, acl_account, acl_rights, acl_grantor, acl_type) 
VALUES ('property', '.vendor', '1', '1', '6', '0')");
+
                $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.532';
                return $GLOBALS['setup_info']['property']['currentver'];