[Fmsystem-commits] [15158] Syncromind: Merge 14936:15027 from trunk

[sigurdne]

Revision: 15158
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15158
Author:   sigurdne
Date:     2016-05-13 12:26:13 +0000 (Fri, 13 May 2016)
Log Message:
-----------
Syncromind: Merge 14936:15027 from trunk

Modified Paths:
--------------
    branches/dev-syncromind-2/sms/setup/tables_update.inc.php

Modified: branches/dev-syncromind-2/sms/setup/tables_update.inc.php
===================================================================
--- branches/dev-syncromind-2/sms/setup/tables_update.inc.php   2016-05-13 
12:26:10 UTC (rev 15157)
+++ branches/dev-syncromind-2/sms/setup/tables_update.inc.php   2016-05-13 
12:26:13 UTC (rev 15158)
@@ -558,3 +558,48 @@
                        return $GLOBALS['setup_info']['sms']['currentver'];
                }
        }
+       /**
+        * Update sms version from 0.9.17.512 to 0.9.17.513
+        *
+        */
+       $test[] = '0.9.17.512';
+
+       function sms_upgrade0_9_17_512()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_sms_received_data', 
'external_id', array(
+                       'type' => 'int',
+                       'precision' => 4,
+                       'nullable' => True
+                       )
+               );
+
+               $custom_config = CreateObject('admin.soconfig', 
$GLOBALS['phpgw']->locations->get_id('sms', 'run'));
+
+               $sections = $custom_config->read_section(array('allrows'=> 
true));
+               foreach ($sections as $section)
+               {
+                       if($section['name'] == 'common')
+                       {
+                               $section_id = $section['id'];
+                               break;
+                       }
+               }
+       
+               $receipt = $custom_config->add_attrib(array(
+                       'section_id' => $section_id,
+                       'input_type' => 'text',
+                       'name' => 'gateway_codeword',
+                       'descr' => 'Gateway codeword'
+                       )
+               );
+
+               if ($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['sms']['currentver'] = 
'0.9.17.513';
+                       return $GLOBALS['setup_info']['sms']['currentver'];
+               }
+       }
+