[Fmsystem-commits] [7942] added control_area_id to procedure

[Erik Holm-Larsen]

Revision: 7942
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7942
Author:   erikhl
Date:     2011-10-26 07:34:08 +0000 (Wed, 26 Oct 2011)
Log Message:
-----------
added control_area_id to procedure

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        2011-10-26 07:24:58 UTC (rev 
7941)
+++ trunk/controller/setup/setup.inc.php        2011-10-26 07:34:08 UTC (rev 
7942)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.3';
+       $setup_info['controller']['version'] = '0.1.5';
        $setup_info['controller']['app_order'] = 100;
        $setup_info['controller']['enable'] = 1;
        $setup_info['controller']['app_group']  = 'office';

Modified: trunk/controller/setup/tables_current.inc.php
===================================================================
--- trunk/controller/setup/tables_current.inc.php       2011-10-26 07:24:58 UTC 
(rev 7941)
+++ trunk/controller/setup/tables_current.inc.php       2011-10-26 07:34:08 UTC 
(rev 7942)
@@ -91,7 +91,8 @@
                                'end_date' => array('type' => 'int', 
'precision' => 8, 'nullable' => True),
                                'procedure_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
                                'revision_no' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
-                               'revision_date' => array('type' => 'int', 
'precision' => 8, 'nullable' => True)
+                               'revision_date' => array('type' => 'int', 
'precision' => 8, 'nullable' => True),
+                               'control_area_id' => array('type' => 'int', 
'presicion' => 4, 'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2011-10-26 07:24:58 UTC 
(rev 7941)
+++ trunk/controller/setup/tables_update.inc.php        2011-10-26 07:34:08 UTC 
(rev 7942)
@@ -26,7 +26,7 @@
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.1';
                return $GLOBALS['setup_info']['controller']['currentver'];
        }
-       
+
        $test[] = '0.1.1';
        function controller_upgrade0_1_1()
        {
@@ -70,4 +70,20 @@
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.4';
                return $GLOBALS['setup_info']['controller']['currentver'];
        }
+       
+       /* Update Controller from v 0.1.4 to 0.1.5
+        */
+
+       $test[] = '0.1.4';
+       function controller_upgrade0_1_4()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('controller_procedure','control_area_id',array(
+                       'type' => 'int',
+                       'precision' => 4,
+                       'nullable' => True
+               ));
+               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.5';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }
 ?>
\ No newline at end of file