[Fmsystem-commits] [7941]

[Torstein]

Revision: 7941
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7941
Author:   vator
Date:     2011-10-26 07:24:58 +0000 (Wed, 26 Oct 2011)
Log Message:
-----------


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

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2011-10-26 07:24:42 UTC 
(rev 7940)
+++ trunk/controller/setup/tables_update.inc.php        2011-10-26 07:24:58 UTC 
(rev 7941)
@@ -1,7 +1,6 @@
 <?php
 
-        /* Update Controller from v 0.1 to 0.1.1
-        */
+        /* Update Controller from v 0.1 to 0.1.1 */
 
        $test[] = '0.1';
        function controller_upgrade0_1()
@@ -28,4 +27,47 @@
                return $GLOBALS['setup_info']['controller']['currentver'];
        }
        
+       $test[] = '0.1.1';
+       function controller_upgrade0_1_1()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('controller_control_group','order_nr',array(
+                       'type' => 'int',
+                       'precision' => 4,
+                       'nullable' => True
+               ));
+               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.2';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }
+       
+       $test[] = '0.1.2';
+       function controller_upgrade0_1_2()
+       {
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'controller_control_group_list', array(
+                               'fd' => array(
+                                       'id' => array('type' => 'auto', 
'nullable' => false),
+                                       'control_id' => array('type' => 'int', 
'precision' => '4', 'nullable' => false),
+                                       'control_group_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false),
+                                       'order_nr' => array('type' => 
'varchar', 'precision' => '3', 'nullable' => false)
+                               ),
+                               'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+                       )
+               );      
+               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.3';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }
+       
+       $test[] = '0.1.3';
+       function controller_upgrade0_1_3()
+       {
+               $GLOBALS['phpgw_setup']->oProc->query("ALTER TABLE 
controller_control_group DROP COLUMN order_nr");     
+                       
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.4';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }
 ?>
\ No newline at end of file