[Fmsystem-commits] [8018] Added new fields: completed_date and planned_date to table check_list and deleted field check_list_id .

[Torstein]

Revision: 8018
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8018
Author:   vator
Date:     2011-11-04 12:04:56 +0000 (Fri, 04 Nov 2011)
Log Message:
-----------
Added new fields: completed_date and planned_date to table check_list and 
deleted field check_list_id. 

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-11-04 10:48:25 UTC (rev 
8017)
+++ trunk/controller/setup/setup.inc.php        2011-11-04 12:04:56 UTC (rev 
8018)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.5';
+       $setup_info['controller']['version'] = '0.1.6';
        $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-11-04 10:48:25 UTC 
(rev 8017)
+++ trunk/controller/setup/tables_current.inc.php       2011-11-04 12:04:56 UTC 
(rev 8018)
@@ -68,7 +68,6 @@
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
                                'control_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
-                               'check_list_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
                                'status' => array('type' => 
'varchar','precision' => '255','nullable' => false),
                                'comment' => array('type' => 
'varchar','precision' => '255','nullable' => false),
                                'deadline' => array('type' => 'int', 
'precision' => 8, 'nullable' => True)

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2011-11-04 10:48:25 UTC 
(rev 8017)
+++ trunk/controller/setup/tables_update.inc.php        2011-11-04 12:04:56 UTC 
(rev 8018)
@@ -86,4 +86,28 @@
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.5';
                return $GLOBALS['setup_info']['controller']['currentver'];
        }
+       
+       /* Update Controller from v 0.1.5 to 0.1.6
+        */
+       
+       $test[] = '0.1.5';
+       function controller_upgrade0_1_5()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->DropColumn('controller_check_list', array(), 
'check_list_id');
+               
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('controller_check_list','planned_date',array(
+                       'type' => 'int',
+                       'precision' => 8,
+                       'nullable' => True
+               ));
+               
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('controller_check_list','completed_date',array(
+                       'type' => 'int',
+                       'precision' => 8,
+                       'nullable' => True
+               ));
+               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.6';
+               return $GLOBALS['setup_info']['controller']['currentver'];
+       }
 ?>
\ No newline at end of file