[Fmsystem-commits] [15368] alter column

[sigurdne]

Revision: 15368
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15368
Author:   sigurdne
Date:     2016-07-25 12:05:32 +0000 (Mon, 25 Jul 2016)
Log Message:
-----------
alter column

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  2016-07-25 12:04:49 UTC (rev 15367)
+++ trunk/phpgwapi/setup/setup.inc.php  2016-07-25 12:05:32 UTC (rev 15368)
@@ -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.551';
+       $setup_info['phpgwapi']['version']   = '0.9.17.552';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '2.0';
        $setup_info['phpgwapi']['enable']    = 3;

Modified: trunk/phpgwapi/setup/tables_current.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_current.inc.php 2016-07-25 12:04:49 UTC (rev 
15367)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2016-07-25 12:05:32 UTC (rev 
15368)
@@ -178,7 +178,7 @@
                'phpgw_lang' => array(
                        'fd' => array(
                                'message_id' => array('type' => 
'varchar','precision' => 255,'nullable' => False,'default' => ''),
-                               'app_name' => array('type' => 
'varchar','precision' => 25,'nullable' => False,'default' => 'common'),
+                               'app_name' => array('type' => 
'varchar','precision' => 30,'nullable' => False,'default' => 'common'),
                                'lang' => array('type' => 'varchar','precision' 
=> 5,'nullable' => False,'default' => ''),
                                'content' => array('type' => 'text')
                        ),
@@ -334,7 +334,7 @@
                                'history_status' => array('type' => 
'char','precision' => 2,'nullable' => False),
                                'history_new_value' => array('type' => 
'text','nullable' => False),
                                'history_timestamp' => array('type' => 
'timestamp','nullable' => False),
-                               'history_old_value' => array('type' => 
'text','nullable' => False),
+                               'history_old_value' => array('type' => 
'text','nullable' => true),
                                'location_id'   => array('type' => 'int', 
'precision' => 4, 'nullable' => true)
                        ),
                        'pk' => array('history_id'),

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2016-07-25 12:04:49 UTC (rev 
15367)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2016-07-25 12:05:32 UTC (rev 
15368)
@@ -3398,3 +3398,33 @@
                        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
                }
        }
+
+       $test[] = '0.9.17.551';
+       /**
+       * Alter column definition
+       * @return string the new version number
+       */
+       function phpgwapi_upgrade0_9_17_551()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_lang','app_name',array(
+                       'type' => 'varchar',
+                       'precision' => 30,
+                       'nullable' => False,
+                       'default' => 'common'
+                       )
+               );
+
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_history_log','history_old_value',array(
+                       'type' => 'text',
+                       'nullable' => true
+                       )
+               );
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.552';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }