[Fmsystem-commits] [11229] property: alter datatype

[Sigurd Nes]

Revision: 11229
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11229
Author:   sigurdne
Date:     2013-07-02 20:18:48 +0000 (Tue, 02 Jul 2013)
Log Message:
-----------
property: alter datatype

Modified Paths:
--------------
    trunk/property/setup/tables_current.inc.php
    trunk/property/setup/tables_update.inc.php

Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2013-07-02 20:14:02 UTC (rev 
11228)
+++ trunk/property/setup/tables_current.inc.php 2013-07-02 20:18:48 UTC (rev 
11229)
@@ -1684,7 +1684,7 @@
                                'title' => array('type' => 
'varchar','precision' => '100','nullable' => True),
                                'document_name' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'link' => array('type' => 'text','nullable' => 
True),
-                               'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
+                               'descr' => array('type' => 'text','nullable' => 
True),
                                'version' => array('type' => 
'varchar','precision' => '10','nullable' => True),
                                'document_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2013-07-02 20:14:02 UTC (rev 
11228)
+++ trunk/property/setup/tables_update.inc.php  2013-07-02 20:18:48 UTC (rev 
11229)
@@ -7577,6 +7577,12 @@
                        )
                );
 
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_document','descr',array(
+                       'type'          => 'text',
+                       'nullable'      => True
+                       )
+               );
+
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
                {
                        $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.669';