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

[sigurdne]

Update of property/setup

Modified Files:
     Branch: MAIN
            tables_update.inc.php lines: +22 -1

Log Message:
no message

====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.12 
property/setup/tables_update.inc.php:1.13
--- property/setup/tables_update.inc.php:1.12   Tue Sep 13 13:33:37 2005
+++ property/setup/tables_update.inc.php        Tue Sep 13 14:11:52 2005
@@ -508,6 +508,27 @@
        $test[] = '0.9.17.506';
        function property_upgrade0_9_17_506()
        {
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_safety',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_aesthetics',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_indoor_climate',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_consequential_damage',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_user_gratification',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','d_residential_environment',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_safety',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_aesthetics',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_indoor_climate',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_consequential_damage',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_user_gratification',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','p_residential_environment',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_safety',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_aesthetics',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_indoor_climate',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_consequential_damage',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_user_gratification',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','c_residential_environment',array('type'
 => 'int','precision' => '4','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','authorities_demands',array('type'
 => 'int','precision' => '2','default' => '0','nullable' => True));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','score',array('type' 
=> 'int','precision' => '4','default' => '0','nullable' => True));
+
                $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET 
d_safety = 0 WHERE d_safety IS NULL ");
                $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET 
d_aesthetics = 0 WHERE d_aesthetics IS NULL ");
                $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET 
d_indoor_climate = 0 WHERE d_indoor_climate IS NULL ");