[Phpgroupware-cvs] property/setup tables_current.inc.php, 1.32 setup.inc.php, 1.20 tables_update.inc.php, 1.11

[sigurdne]

Update of property/setup

Modified Files:
     Branch: MAIN
            tables_current.inc.php lines: +13 -2
            setup.inc.php lines: +3 -2
            tables_update.inc.php lines: +26 -1

Log Message:
no message

====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.31 
property/setup/tables_current.inc.php:1.32
--- property/setup/tables_current.inc.php:1.31  Wed May 18 16:05:54 2005
+++ property/setup/tables_current.inc.php       Fri Sep  9 10:52:13 2005
@@ -729,7 +729,18 @@
                                'building_part' => array('type' => 
'varchar','precision' => '4','nullable' => True),
                                'quantity' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True),
                                'cost' => array('type' => 'decimal','precision' 
=> '20','scale' => '2','nullable' => True),
-                               'dim_d' => array('type' => 'int','precision' => 
'4','nullable' => True)
+                               'dim_d' => array('type' => 'int','precision' => 
'4','nullable' => True),
+                               'category' => array('type' => 'int','precision' 
=> '4','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+               'fm_wo_hours_category' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => False)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),

====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.19 property/setup/setup.inc.php:1.20
--- property/setup/setup.inc.php:1.19   Wed May 18 16:05:54 2005
+++ property/setup/setup.inc.php        Fri Sep  9 10:52:13 2005
@@ -13,7 +13,7 @@

        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']         = 'Property';
-       $setup_info['property']['version']   = '0.9.17.505';
+       $setup_info['property']['version']   = '0.9.17.506';
        $setup_info['property']['app_order'] = 8;
        $setup_info['property']['enable']    = 1;

@@ -115,6 +115,7 @@
                'fm_activity_price_index',
                'fm_branch',
                'fm_wo_hours',
+               'fm_wo_hours_category',
                'fm_wo_h_deviation',
                'fm_key_loc',
                'fm_request',

====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.10 
property/setup/tables_update.inc.php:1.11
--- property/setup/tables_update.inc.php:1.10   Wed May 18 16:05:54 2005
+++ property/setup/tables_update.inc.php        Fri Sep  9 10:52:13 2005
@@ -476,4 +476,29 @@
                return $GLOBALS['setup_info']['property']['currentver'];
        }

+       /**
+       * Update property version from 0.9.17.505 to 0.9.17.506
+       */
+
+       $test[] = '0.9.17.505';
+       function property_upgrade0_9_17_505()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_wo_hours','category',array('type' 
=> 'int','precision' => 4,'nullable' => True));
+
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'fm_wo_hours_category', array(
+                               'fd' => array(
+                                       'id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                                       'descr' => array('type' => 
'varchar','precision' => '255','nullable' => False)
+                               ),
+                               'pk' => array('id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+
+               $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.506';
+               return $GLOBALS['setup_info']['property']['currentver'];
+       }
 ?>