[Fmsystem-commits] [10139] added new column on requirement value table

[Erik Holm-Larsen]

Revision: 10139
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10139
Author:   erikhl
Date:     2012-10-08 08:19:52 +0000 (Mon, 08 Oct 2012)
Log Message:
-----------
added new column on requirement value table

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

Modified: trunk/logistic/inc/model/class.requirement_value.inc.php
===================================================================
--- trunk/logistic/inc/model/class.requirement_value.inc.php    2012-10-08 
08:02:19 UTC (rev 10138)
+++ trunk/logistic/inc/model/class.requirement_value.inc.php    2012-10-08 
08:19:52 UTC (rev 10139)
@@ -35,6 +35,7 @@
 
                protected static $id;
                protected static $requirement_id;
+               protected $bim_type_requirement_id;
                protected $location_id;
                protected $cust_attribute_id;
                protected static $value;
@@ -70,6 +71,16 @@
                        return $this->requirement_id;
                }
 
+               public function 
set_bim_type_requirement_id($bim_type_requirement_id)
+               {
+                       $this->bim_type_requirement_id = 
$bim_type_requirement_id;
+               }
+
+               public function get_bim_type_requirement_id()
+               {
+                       return $this->bim_type_requirement_id;
+               }
+
                public function set_location_id($location_id)
                {
                        $this->location_id = $location_id;

Modified: trunk/logistic/setup/setup.inc.php
===================================================================
--- trunk/logistic/setup/setup.inc.php  2012-10-08 08:02:19 UTC (rev 10138)
+++ trunk/logistic/setup/setup.inc.php  2012-10-08 08:19:52 UTC (rev 10139)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['logistic']['name'] = 'logistic';
-       $setup_info['logistic']['version'] = '0.0.4';
+       $setup_info['logistic']['version'] = '0.0.5';
        $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-08 08:02:19 UTC (rev 
10138)
+++ trunk/logistic/setup/tables_current.inc.php 2012-10-08 08:19:52 UTC (rev 
10139)
@@ -119,6 +119,7 @@
                                '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),
                                                'cust_attribute_id' => 
array('type' => 'int', 'precision' => 4, 'nullable' => false),
                                                'location_id' => array('type' 
=> 'int', 'precision' => 4, 'nullable' => false),
                                                'value' => array('type' => 
'varchar', 'precision' => '255', 'nullable' => true),

Modified: trunk/logistic/setup/tables_update.inc.php
===================================================================
--- trunk/logistic/setup/tables_update.inc.php  2012-10-08 08:02:19 UTC (rev 
10138)
+++ trunk/logistic/setup/tables_update.inc.php  2012-10-08 08:19:52 UTC (rev 
10139)
@@ -62,4 +62,17 @@
 
                $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.4';
                return $GLOBALS['setup_info']['logistic']['currentver'];
+       }
+
+       $test[] = '0.0.4';
+       function logistic_upgrade0_0_4()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_requirement_value','requirement_id',array(
+                       'type' => 'int',
+                       'precision' => 4,
+                       'nullable' => True
+               ));
+
+               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.5';
+               return $GLOBALS['setup_info']['logistic']['currentver'];
        }
\ No newline at end of file