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

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/03/02 13:11:29

Modified files:
        setup          : tables_update.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_update.inc.php.diff?tr1=1.32&tr2=1.33&r1=text&r2=text

Patches:
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.32 
property/setup/tables_update.inc.php:1.33
--- property/setup/tables_update.inc.php:1.32   Thu Mar  2 12:46:10 2006
+++ property/setup/tables_update.inc.php        Thu Mar  2 13:11:29 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.32 2006/03/02 12:46:10 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.33 2006/03/02 13:11:29 
sigurdne Exp $
        */
 
        /**
@@ -1022,29 +1022,34 @@
        $test[] = '0.9.17.513';
        function property_upgrade0_9_17_513()
        {
+               $sql = "SELECT app_version from phpgw_applications WHERE 
app_name = 'property'";
+               $GLOBALS['phpgw_setup']->oProc->query($sql,__LINE__,__FILE__);
+               $GLOBALS['phpgw_setup']->oProc->next_record();
+               $version = $GLOBALS['phpgw_setup']->oProc->f('score');
 
-
-               $soadmin_location       = 
CreateObject('property.soadmin_location','property');
-               
-               for ($i=1; $i<=4; $i++)
+               if($version =='0.9.17.513')
                {
-                       $attrib= array(
-                               'column_name' => 'rental_area',
-                               'input_text' => 'Rental area',
-                               'statustext' => 'Rental area',
-                               'type_id' => $i,
-                               'lookup_form' => False,
-                               'list' => False,
-                               'column_info' => array('type' =>'N',
-                                                       'precision' => 20,
-                                                       'scale' => 2,
-                                                       'default' => '0.00',
-                                                       'nullable' => 'True')
-                               );
-                       $soadmin_location->add_attrib($attrib);
-               }               
-
-
+                       $soadmin_location       = 
CreateObject('property.soadmin_location','property');
+               
+                       for ($i=1; $i<=4; $i++)
+                       {
+                               $attrib= array(
+                                       'column_name' => 'rental_area',
+                                       'input_text' => 'Rental area',
+                                       'statustext' => 'Rental area',
+                                       'type_id' => $i,
+                                       'lookup_form' => False,
+                                       'list' => False,
+                                       'column_info' => array('type' =>'N',
+                                                               'precision' => 
20,
+                                                               'scale' => 2,
+                                                               'default' => 
'0.00',
+                                                               'nullable' => 
'True')
+                                       );
+                               $soadmin_location->add_attrib($attrib);
+                       }               
+               }
+               
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.514';
                return $GLOBALS['setup_info']['property']['currentver'];
        }