[Fmsystem-commits] [13922] API: alter column log_severity

[Sigurd Nes]

Revision: 13922
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=13922
Author:   sigurdne
Date:     2015-09-15 19:58:10 +0000 (Tue, 15 Sep 2015)
Log Message:
-----------
API: alter column log_severity

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

Modified: trunk/phpgwapi/setup/setup.inc.php
===================================================================
--- trunk/phpgwapi/setup/setup.inc.php  2015-09-15 19:52:32 UTC (rev 13921)
+++ trunk/phpgwapi/setup/setup.inc.php  2015-09-15 19:58:10 UTC (rev 13922)
@@ -12,7 +12,7 @@
        // Basic information about this app
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
-       $setup_info['phpgwapi']['version']   = '0.9.17.547';
+       $setup_info['phpgwapi']['version']   = '0.9.17.548';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '1.0';
        $setup_info['phpgwapi']['enable']    = 3;

Modified: trunk/phpgwapi/setup/tables_current.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_current.inc.php 2015-09-15 19:52:32 UTC (rev 
13921)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2015-09-15 19:58:10 UTC (rev 
13922)
@@ -241,7 +241,7 @@
                                'log_account_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
                                'log_account_lid' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
                                'log_app' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
-                               'log_severity' => array('type' => 
'char','precision' => 1,'nullable' => False),
+                               'log_severity' => array('type' => 
'char','precision' => 2,'nullable' => False),
                                'log_file' => array('type' => 
'varchar','precision' => 255,'nullable' => False,'default' => ''),
                                'log_line' => array('type' => 'int','precision' 
=> 4,'nullable' => False,'default' => '0'),
                                'log_msg' => array('type' => 'text','nullable' 
=> False)

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2015-09-15 19:52:32 UTC (rev 
13921)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2015-09-15 19:58:10 UTC (rev 
13922)
@@ -3278,3 +3278,25 @@
                }
        }
 
+       $test[] = '0.9.17.547';
+       /**
+       *
+       * @return string the new version number
+       */
+       function phpgwapi_upgrade0_9_17_547()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_log','log_severity',array(
+                       'type' => 'char',
+                       'precision' => 2,
+                       'nullable' => false,
+               ));
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.548';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }
+