[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.12 tables_cur
From: |
sigurdne |
Subject: |
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.12 tables_current.inc.php, 1.33 setup.inc.php, 1.21 |
Date: |
Tue, 13 Sep 2005 15:33:00 +0200 |
Update of property/setup
Modified Files:
Branch: MAIN
tables_update.inc.php lines: +34 -1
tables_current.inc.php lines: +21 -21
setup.inc.php lines: +2 -2
Log Message:
no message
====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.11
property/setup/tables_update.inc.php:1.12
--- property/setup/tables_update.inc.php:1.11 Fri Sep 9 10:52:13 2005
+++ property/setup/tables_update.inc.php Tue Sep 13 13:33:37 2005
@@ -501,4 +501,37 @@
$GLOBALS['setup_info']['property']['currentver'] = '0.9.17.506';
return $GLOBALS['setup_info']['property']['currentver'];
}
+ /**
+ * Update property version from 0.9.17.506 to 0.9.17.507
+ */
+
+ $test[] = '0.9.17.506';
+ function property_upgrade0_9_17_506()
+ {
+ $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 ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
d_consequential_damage = 0 WHERE d_consequential_damage IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
d_user_gratification = 0 WHERE d_user_gratification IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
d_residential_environment = 0 WHERE d_residential_environment IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_safety = 0 WHERE p_safety IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_aesthetics = 0 WHERE p_aesthetics IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_indoor_climate = 0 WHERE p_indoor_climate IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_consequential_damage = 0 WHERE p_consequential_damage IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_user_gratification = 0 WHERE p_user_gratification IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
p_residential_environment = 0 WHERE p_residential_environment IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_safety = 0 WHERE c_safety IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_aesthetics = 0 WHERE c_aesthetics IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_indoor_climate = 0 WHERE c_indoor_climate IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_consequential_damage = 0 WHERE c_consequential_damage IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_user_gratification = 0 WHERE c_user_gratification IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
c_residential_environment = 0 WHERE c_residential_environment IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
authorities_demands = 0 WHERE authorities_demands IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_request SET
score = 0 WHERE score IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_workorder SET
act_mtrl_cost = 0 WHERE act_mtrl_cost IS NULL ");
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_workorder SET
act_vendor_cost = 0 WHERE act_vendor_cost IS NULL ");
+
+ $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.507';
+ return $GLOBALS['setup_info']['property']['currentver'];
+ }
?>
====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.32
property/setup/tables_current.inc.php:1.33
--- property/setup/tables_current.inc.php:1.32 Fri Sep 9 10:52:13 2005
+++ property/setup/tables_current.inc.php Tue Sep 13 13:33:37 2005
@@ -850,26 +850,26 @@
'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'd_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'd_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'd_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'd_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'd_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'd_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'p_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'p_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'p_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'p_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'p_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'p_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'c_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'c_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'c_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'c_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'c_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'c_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'authorities_demands' => array('type' =>
'int','precision' => '2','nullable' => True),
- 'score' => array('type' => 'int','precision' =>
'4','nullable' => True)
+ 'd_safety' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
+ 'd_aesthetics' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'd_indoor_climate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'd_consequential_damage' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'd_user_gratification' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'd_residential_environment' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'p_safety' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
+ 'p_aesthetics' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'p_indoor_climate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'p_consequential_damage' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'p_user_gratification' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'p_residential_environment' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'c_safety' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
+ 'c_aesthetics' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'c_indoor_climate' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'c_consequential_damage' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'c_user_gratification' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'c_residential_environment' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'authorities_demands' => array('type' =>
'int','precision' => '2','default' => '0','nullable' => True),
+ 'score' => array('type' => 'int','precision' =>
'4','default' => '0','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.20 property/setup/setup.inc.php:1.21
--- property/setup/setup.inc.php:1.20 Fri Sep 9 10:52:13 2005
+++ property/setup/setup.inc.php Tue Sep 13 13:33:37 2005
@@ -13,7 +13,7 @@
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
- $setup_info['property']['version'] = '0.9.17.506';
+ $setup_info['property']['version'] = '0.9.17.507';
$setup_info['property']['app_order'] = 8;
$setup_info['property']['enable'] = 1;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.12 tables_current.inc.php, 1.33 setup.inc.php, 1.21,
sigurdne <=