[Fmsystem-commits] [7556] property: add column missing from fresh install

[Sigurd Nes]

Revision: 7556
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7556
Author:   sigurdne
Date:     2011-09-05 09:38:52 +0000 (Mon, 05 Sep 2011)
Log Message:
-----------
property: add column missing from fresh install

Modified Paths:
--------------
    trunk/property/setup/setup.inc.php
    trunk/property/setup/tables_current.inc.php
    trunk/property/setup/tables_update.inc.php

Modified: trunk/property/setup/setup.inc.php
===================================================================
--- trunk/property/setup/setup.inc.php  2011-09-05 07:08:01 UTC (rev 7555)
+++ trunk/property/setup/setup.inc.php  2011-09-05 09:38:52 UTC (rev 7556)
@@ -12,7 +12,7 @@
        */
 
        $setup_info['property']['name']                 = 'property';
-       $setup_info['property']['version']              = '0.9.17.623';
+       $setup_info['property']['version']              = '0.9.17.624';
        $setup_info['property']['app_order']    = 8;
        $setup_info['property']['enable']               = 1;
        $setup_info['property']['app_group']    = 'office';

Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2011-09-05 07:08:01 UTC (rev 
7555)
+++ trunk/property/setup/tables_current.inc.php 2011-09-05 09:38:52 UTC (rev 
7556)
@@ -1347,7 +1347,8 @@
                                'planned_cost' => array('type' => 
'int','precision' => '4','nullable' => True, 'default' => '0'),
                                'account_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'ecodimb' => array('type' => 'int','precision' 
=> 4,'nullable' => True),
-                               'contact_id' => array('type' => 
'int','precision' => 4,'nullable' => True)
+                               'contact_id' => array('type' => 
'int','precision' => 4,'nullable' => True),
+                               'account_group' => array('type' => 
'int','precision' => 4,'nullable' => True),
                        ),
                        'pk' => array('id'),
                        'fk' => array(),

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2011-09-05 07:08:01 UTC (rev 
7555)
+++ trunk/property/setup/tables_update.inc.php  2011-09-05 09:38:52 UTC (rev 
7556)
@@ -5431,6 +5431,32 @@
 
 
        /**
+       * Update property version from 0.9.17.623 to 0.9.17.624
+       * Add column missing from fresh install.
+       * 
+       */
+
+       $test[] = '0.9.17.623';
+       function property_upgrade0_9_17_623()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               $metadata = 
$GLOBALS['phpgw_setup']->oProc->m_odb->metadata('fm_project');
+
+               if(!isset($metadata['account_group']))
+               {
+                       
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_project','account_group',array('type'
 => 'int','precision' => '4','nullable' => True));
+               }
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.624';
+                       return $GLOBALS['setup_info']['property']['currentver'];
+               }
+       }
+
+
+       /**
        * Update property version from 0.9.17.607 to 0.9.17.608
        * Add more room for address at tickets
        *