[Fmsystem-commits] [10207] Logistic: Added column cust_attrib_id to lg_requirement_value and removed type_requirement_id

[Torstein]

Revision: 10207
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10207
Author:   vator
Date:     2012-10-15 07:58:09 +0000 (Mon, 15 Oct 2012)
Log Message:
-----------
Logistic: Added column cust_attrib_id to lg_requirement_value and removed 
type_requirement_id

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

Modified: trunk/logistic/setup/setup.inc.php
===================================================================
--- trunk/logistic/setup/setup.inc.php  2012-10-15 05:49:38 UTC (rev 10206)
+++ trunk/logistic/setup/setup.inc.php  2012-10-15 07:58:09 UTC (rev 10207)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['logistic']['name'] = 'logistic';
-       $setup_info['logistic']['version'] = '0.0.2';
+       $setup_info['logistic']['version'] = '0.0.3';
        $setup_info['logistic']['app_order'] = 70;
        $setup_info['logistic']['enable'] = 1;
        $setup_info['logistic']['app_group']    = 'office';

Modified: trunk/logistic/setup/tables_current.inc.php
===================================================================
--- trunk/logistic/setup/tables_current.inc.php 2012-10-15 05:49:38 UTC (rev 
10206)
+++ trunk/logistic/setup/tables_current.inc.php 2012-10-15 07:58:09 UTC (rev 
10207)
@@ -106,12 +106,12 @@
                'lg_requirement_value' => array(
                                'fd' => array(
                                                'id' => array('type' => 'auto', 
'precision' => 4, 'nullable' => false),
-                                               'type_requirement_id' => 
array('type' => 'int', 'precision' => 4, 'nullable' => false),
                                                'requirement_id' => 
array('type' => 'int', 'precision' => 4, 'nullable' => false),
                                                'operator' => array('type' => 
'varchar', 'precision' => '255', 'nullable' => false),
                                                'value' => array('type' => 
'varchar', 'precision' => '255', 'nullable' => false),
                                                'create_user' => array('type' 
=> 'int', 'precision' => 4, 'nullable' => false),
                                                'create_date' => array('type' 
=> 'int', 'precision' => 4, 'nullable' => false),
+                                               'cust_attribute_id' => 
array('type' => 'int', 'precision' => 4, 'nullable' => false),
                                ),
                                'pk' => array('id'),
                                'fk' => array(

Modified: trunk/logistic/setup/tables_update.inc.php
===================================================================
--- trunk/logistic/setup/tables_update.inc.php  2012-10-15 05:49:38 UTC (rev 
10206)
+++ trunk/logistic/setup/tables_update.inc.php  2012-10-15 07:58:09 UTC (rev 
10207)
@@ -14,4 +14,24 @@
                        return $GLOBALS['setup_info']['logistic']['currentver'];
                }
        }
+       
+       $test[] = '0.0.2';
+       function logistic_upgrade0_0_2()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->DropColumn('lg_requirement_value', array(), 
'type_requirement_id');
+               
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_requirement_value','cust_attribute_id',array(
+                       'type' => 'int',
+                       'precision' => 4,
+                       'nullable' => False
+               ));
+       
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['logistic']['currentver'] = 
'0.0.3';
+                       return $GLOBALS['setup_info']['logistic']['currentver'];
+               }
+       }
        
\ No newline at end of file