[Phpgroupware-cvs] property/setup tables_update.inc.php setup.inc....

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/04/19 08:35:18

Modified files:
        setup          : tables_update.inc.php setup.inc.php 
                         tables_current.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_update.inc.php.diff?tr1=1.42&tr2=1.43&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/setup.inc.php.diff?tr1=1.39&tr2=1.40&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_current.inc.php.diff?tr1=1.57&tr2=1.58&r1=text&r2=text

Patches:
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.39 property/setup/setup.inc.php:1.40
--- property/setup/setup.inc.php:1.39   Mon Apr 17 21:11:53 2006
+++ property/setup/setup.inc.php        Wed Apr 19 08:35:18 2006
@@ -8,12 +8,12 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: setup.inc.php,v 1.39 2006/04/17 21:11:53 sigurdne Exp $
+       * @version $Id: setup.inc.php,v 1.40 2006/04/19 08:35:18 sigurdne Exp $
        */
 
        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']         = 'Property';
-       $setup_info['property']['version']   = '0.9.17.519';
+       $setup_info['property']['version']   = '0.9.17.520';
        $setup_info['property']['app_order'] = 8;
        $setup_info['property']['enable']    = 1;
        $setup_info['property']['app_group']    = 'office';
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.57 
property/setup/tables_current.inc.php:1.58
--- property/setup/tables_current.inc.php:1.57  Mon Apr 17 11:36:05 2006
+++ property/setup/tables_current.inc.php       Wed Apr 19 08:35:18 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_current.inc.php,v 1.57 2006/04/17 11:36:05 
sigurdne Exp $
+       * @version $Id: tables_current.inc.php,v 1.58 2006/04/19 08:35:18 
sigurdne Exp $
        */
 
        $phpgw_baseline = array(
@@ -870,7 +870,9 @@
                                'branch_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'coordinator' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'authorities_demands' => array('type' => 
'int','precision' => '2','default' => '0','nullable' => True),
-                               'score' => array('type' => 'int','precision' => 
'4','default' => '0','nullable' => True)
+                               'score' => array('type' => 'int','precision' => 
'4','default' => '0','nullable' => True),
+                               'start_date' => array('type' => 
'int','precision' => '4','default' => '0','nullable' => True),
+                               'end_date' => array('type' => 'int','precision' 
=> '4','default' => '0','nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.42 
property/setup/tables_update.inc.php:1.43
--- property/setup/tables_update.inc.php:1.42   Mon Apr 17 11:36:05 2006
+++ property/setup/tables_update.inc.php        Wed Apr 19 08:35:17 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.42 2006/04/17 11:36:05 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.43 2006/04/19 08:35:17 
sigurdne Exp $
        */
 
        /**
@@ -1251,9 +1251,27 @@
                $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
 
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_template_hours','entry_date',array('type'
 => 'int','precision' => 4,'nullable' => True));
-               
$GLOBALS['phpgw_setup']->oProc->DropColumn('fm_template_hours',null,'workorder_id');
+//             
$GLOBALS['phpgw_setup']->oProc->DropColumn('fm_template_hours',null,'workorder_id');
                
                $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.519';
                return $GLOBALS['setup_info']['property']['currentver'];
        }
+
+
+       /**
+       * Update property version from 0.9.17.518 to 0.9.17.519
+       */
+
+       $test[] = '0.9.17.519';
+       function property_upgrade0_9_17_519()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_request','start_date',array('type'
 => 'int','precision' => 4,'nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_request','end_date',array('type' 
=> 'int','precision' => 4,'nullable' => True));
+               
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
+               $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.520';
+               return $GLOBALS['setup_info']['property']['currentver'];
+       }