[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [17085] property::request: alter column for title
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [17085] property::request: alter column for title |
Date: |
Sun, 17 Sep 2017 12:56:02 -0400 (EDT) |
Revision: 17085
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17085
Author: sigurdne
Date: 2017-09-17 12:56:02 -0400 (Sun, 17 Sep 2017)
Log Message:
-----------
property::request: alter column for title
Modified Paths:
--------------
trunk/property/setup/setup.inc.php
trunk/property/setup/tables_current.inc.php
trunk/property/setup/tables_update.inc.php
Modified: trunk/property/setup/setup.inc.php
===================================================================
--- trunk/property/setup/setup.inc.php 2017-09-17 16:34:39 UTC (rev 17084)
+++ trunk/property/setup/setup.inc.php 2017-09-17 16:56:02 UTC (rev 17085)
@@ -11,7 +11,7 @@
* @version $Id$
*/
$setup_info['property']['name'] = 'property';
- $setup_info['property']['version'] = '0.9.17.720';
+ $setup_info['property']['version'] = '0.9.17.721';
$setup_info['property']['app_order'] = 8;
$setup_info['property']['enable'] = 1;
$setup_info['property']['app_group'] = 'office';
Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2017-09-17 16:34:39 UTC (rev
17084)
+++ trunk/property/setup/tables_current.inc.php 2017-09-17 16:56:02 UTC (rev
17085)
@@ -951,7 +951,7 @@
'fd' => array(
'id' => array('type' => 'int', 'precision' =>
'4', 'nullable' => False),
'condition_survey_id' => array('type' => 'int',
'precision' => '4', 'nullable' => True),
- 'title' => array('type' => 'varchar',
'precision' => '100', 'nullable' => True),
+ 'title' => array('type' => 'text', 'nullable'
=> True),
'project_id' => array('type' => 'int',
'precision' => '4', 'nullable' => True),
'p_num' => array('type' => 'varchar',
'precision' => '15', 'nullable' => True),
'p_entity_id' => array('type' => 'int',
'precision' => '4', 'nullable' => True),
Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php 2017-09-17 16:34:39 UTC (rev
17084)
+++ trunk/property/setup/tables_update.inc.php 2017-09-17 16:56:02 UTC (rev
17085)
@@ -9826,4 +9826,24 @@
$GLOBALS['setup_info']['property']['currentver'] =
'0.9.17.720';
return $GLOBALS['setup_info']['property']['currentver'];
}
+ }
+
+ /**
+ * Update property version from 0.9.17.720 to 0.9.17.721
+ *
+ */
+ $test[] = '0.9.17.720';
+
+ function property_upgrade0_9_17_720()
+ {
+ $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+ $GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request',
'title', array('type' => 'text',
+ 'nullable' => True));
+
+ if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+ {
+ $GLOBALS['setup_info']['property']['currentver'] =
'0.9.17.721';
+ return $GLOBALS['setup_info']['property']['currentver'];
+ }
}
\ No newline at end of file
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [17085] property::request: alter column for title,
sigurdne <=