[Fmsystem-commits] [8439] api: alter to bigint on location_item_id

[Sigurd Nes]

Revision: 8439
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8439
Author:   sigurdne
Date:     2011-12-27 09:56:12 +0000 (Tue, 27 Dec 2011)
Log Message:
-----------
api: alter to bigint on location_item_id

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  2011-12-27 09:06:26 UTC (rev 8438)
+++ trunk/phpgwapi/setup/setup.inc.php  2011-12-27 09:56:12 UTC (rev 8439)
@@ -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.537';
+       $setup_info['phpgwapi']['version']   = '0.9.17.538';
        $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 2011-12-27 09:06:26 UTC (rev 
8438)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2011-12-27 09:56:12 UTC (rev 
8439)
@@ -703,7 +703,7 @@
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
                                'location_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
-                               'location_item_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                               'location_item_id' => array('type' => 
'int','precision' => 8,'nullable' => False),//bigint
                                'contact_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
                                'is_active' => array('type' => 'int', 
'precision' => 2,'nullable' => true),
                                'notification_method' => array('type' => 
'varchar', 'precision' => 20,'nullable' => true),

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2011-12-27 09:06:26 UTC (rev 
8438)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2011-12-27 09:56:12 UTC (rev 
8439)
@@ -3026,3 +3026,26 @@
                        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
                }
        }
+       $test[] = '0.9.17.537';
+       /**
+       * change datatype to bigint
+       *
+       * @return string the new version number
+       */
+
+       function phpgwapi_upgrade0_9_17_537()
+       {
+
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_notification','location_item_id',array(
+                       'type' => 'int',
+                       'precision' => '8',
+                       'nullable' => False
+               ));
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.538';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }