[Fmsystem-commits] [10814] Added new field, location_code, in case table.

[Torstein]

Revision: 10814
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10814
Author:   vator
Date:     2013-02-14 09:45:16 +0000 (Thu, 14 Feb 2013)
Log Message:
-----------
Added new field, location_code, in case table. 

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

Modified: trunk/controller/setup/setup.inc.php
===================================================================
--- trunk/controller/setup/setup.inc.php        2013-02-14 08:55:18 UTC (rev 
10813)
+++ trunk/controller/setup/setup.inc.php        2013-02-14 09:45:16 UTC (rev 
10814)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.41';
+       $setup_info['controller']['version'] = '0.1.42';
        $setup_info['controller']['app_order'] = 100;
        $setup_info['controller']['enable'] = 1;
        $setup_info['controller']['app_group']  = 'office';
@@ -29,12 +29,12 @@
        (
                'menu'                                  => 
'controller.menu.get_menu',
                'config',
-               'home'                                  => 
'controller.hook_helper.home_backend',
+               'home'                => 'controller.hook_helper.home_backend',
                'home_mobilefrontend'   => 
'controller.hook_helper.home_mobilefrontend',
                'settings',
                'cat_add'                               => 
'controller.cat_hooks.cat_add',
-               'cat_delete'                    => 
'controller.cat_hooks.cat_delete',
-               'cat_edit'                              => 
'controller.cat_hooks.cat_edit'
+               'cat_delete'            => 'controller.cat_hooks.cat_delete',
+               'cat_edit'                      => 
'controller.cat_hooks.cat_edit'
        );
        
        $setup_info['controller']['tables'] = array 

Modified: trunk/controller/setup/tables_current.inc.php
===================================================================
--- trunk/controller/setup/tables_current.inc.php       2013-02-14 08:55:18 UTC 
(rev 10813)
+++ trunk/controller/setup/tables_current.inc.php       2013-02-14 09:45:16 UTC 
(rev 10814)
@@ -200,6 +200,7 @@
         'entry_date'                           => array('type' => 'int', 
'precision' => 8,'nullable' => false),
         'modified_date'                        => array('type' => 'int', 
'precision' => 8,'nullable' => True),
         'modified_by'                  => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
+                               'location_code'                 => array('type' 
=> 'varchar', 'precision' => 30, 'nullable' => True)
       ),
       'pk' => array('id'),
       'fk' => array('controller_check_item' => array('check_item_id' => 'id')),
@@ -208,10 +209,10 @@
                ),
                'controller_check_item_status' => array(
                        'fd' => array(
-                               'id' => array('type' => 'auto','nullable' => 
False),
-                               'name' => array('type' => 'varchar','precision' 
=> '50','nullable' => False),
-                               'open' => array('type' => 'int','precision' => 
'2','nullable' => True),
-                               'closed' => array('type' => 'int','precision' 
=> '2','nullable' => True),
+                               'id'                    => array('type' => 
'auto','nullable' => False),
+                               'name'          => array('type' => 
'varchar','precision' => '50','nullable' => False),
+                               'open'          => array('type' => 
'int','precision' => '2','nullable' => True),
+                               'closed'        => array('type' => 
'int','precision' => '2','nullable' => True),
                                'pending' => array('type' => 'int','precision' 
=> '2','nullable' => True),
                                'sorting' => array('type' => 'int','precision' 
=> '4','nullable' => True)
                        ),
@@ -222,8 +223,8 @@
                ),
                'controller_control_item_option' => array(
                        'fd' => array(
-                               'id' => array('type' => 'auto', 'precision' =>  
4, 'nullable' => false),
-                               'option_value' =>  array('type' =>  
'varchar','precision' =>  '255','nullable' =>  False),
+                               'id'                                            
        => array('type' => 'auto', 'precision' =>  4, 'nullable' => false),
+                               'option_value'          =>  array('type' =>  
'varchar','precision' =>  '255','nullable' =>  False),
                                'control_item_id' =>  array('type' =>  'int', 
'precision' =>  4, 'nullable' =>  True)
                        ),
                        'pk' => array('id'),

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2013-02-14 08:55:18 UTC 
(rev 10813)
+++ trunk/controller/setup/tables_update.inc.php        2013-02-14 09:45:16 UTC 
(rev 10814)
@@ -821,3 +821,21 @@
                        return 
$GLOBALS['setup_info']['controller']['currentver'];
                }
        }
+       
+       $test[] = '0.1.41';
+       function controller_upgrade0_1_41()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+               
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('controller_check_item_case','location_code',array(
+                       'type' => 'varchar', 
+                       'precision' => '30',
+                       'nullable' => true
+               ));
+               
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['controller']['currentver'] = 
'0.1.42';
+                       return 
$GLOBALS['setup_info']['controller']['currentver'];
+               }
+       }