[Fmsystem-commits] [17085] property::request: alter column for title

[sigurdne]

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