[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup tables_update.inc.php
From: |
Sigurd Nes |
Subject: |
[Phpgroupware-cvs] property/setup tables_update.inc.php |
Date: |
Thu, 02 Nov 2006 09:53:30 +0000 |
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'];
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup tables_update.inc.php,
Sigurd Nes <=