[Fmsystem-commits] [8791] Added table controller_control_group_component_list

[Erik Holm-Larsen]

Revision: 8791
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8791
Author:   erikhl
Date:     2012-02-06 08:37:18 +0000 (Mon, 06 Feb 2012)
Log Message:
-----------
Added table controller_control_group_component_list

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        2012-02-06 07:42:35 UTC (rev 
8790)
+++ trunk/controller/setup/setup.inc.php        2012-02-06 08:37:18 UTC (rev 
8791)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.25';
+       $setup_info['controller']['version'] = '0.1.26';
        $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       2012-02-06 07:42:35 UTC 
(rev 8790)
+++ trunk/controller/setup/tables_current.inc.php       2012-02-06 08:37:18 UTC 
(rev 8791)
@@ -162,6 +162,17 @@
                        'ix' => array(),
                        'uc' => array()
                ),
+               'controller_control_group_component_list' => array(
+                               'fd' => array(
+                                       'id' => array('type' => 'auto', 
'nullable' => false),
+                                       'control_group_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false),
+                                       'component_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false)
+                               ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
                'controller_document_types' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto', 'nullable' => 
false),

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2012-02-06 07:42:35 UTC 
(rev 8790)
+++ trunk/controller/setup/tables_update.inc.php        2012-02-06 08:37:18 UTC 
(rev 8791)
@@ -529,3 +529,28 @@
                        return 
$GLOBALS['setup_info']['controller']['currentver'];
                }               
        }
+       
+       /* Update Controller from v 0.1.25 to 0.1.26
+        * Added table for connecting gontrol groups to components  
+       */
+       
+       $test[] = '0.1.25';
+       function controller_upgrade0_1_25()
+       {
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'controller_control_group_component_list', array(
+                               'fd' => array(
+                                       'id' => array('type' => 'auto', 
'nullable' => false),
+                                       'control_group_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false),
+                                       'component_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false)
+                               ),
+                               'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+                       )
+               );                      
+
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.26';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }