[Fmsystem-commits] [9149] changed datatype on controller_control::description fron varchar(255 ) to text

[Erik Holm-Larsen]

Revision: 9149
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9149
Author:   erikhl
Date:     2012-04-13 11:47:39 +0000 (Fri, 13 Apr 2012)
Log Message:
-----------
changed datatype on controller_control::description fron varchar(255) to text

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

Modified: trunk/controller/setup/setup.inc.php
===================================================================
--- trunk/controller/setup/setup.inc.php        2012-04-13 11:36:24 UTC (rev 
9148)
+++ trunk/controller/setup/setup.inc.php        2012-04-13 11:47:39 UTC (rev 
9149)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.30';
+       $setup_info['controller']['version'] = '0.1.31';
        $setup_info['controller']['app_order'] = 100;
        $setup_info['controller']['enable'] = 1;
        $setup_info['controller']['app_group']  = 'office';

Modified: trunk/controller/setup/tables_current.inc.php
===================================================================
--- trunk/controller/setup/tables_current.inc.php       2012-04-13 11:36:24 UTC 
(rev 9148)
+++ trunk/controller/setup/tables_current.inc.php       2012-04-13 11:47:39 UTC 
(rev 9149)
@@ -4,7 +4,7 @@
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
                                'title' => array('type' => 
'varchar','precision' => '100', 'nullable' => False),
-                               'description' => array('type' => 'varchar', 
'precision' => '255', 'nullable' => True),
+                               'description' => array('type' => 'text', 
'nullable' => True),
                                'start_date' => array('type' => 'int', 
'precision' => 8, 'nullable' => True),
                                'end_date' => array('type' => 'int', 
'precision' => 8, 'nullable' => True),
                                'procedure_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2012-04-13 11:36:24 UTC 
(rev 9148)
+++ trunk/controller/setup/tables_update.inc.php        2012-04-13 11:47:39 UTC 
(rev 9149)
@@ -621,4 +621,16 @@
                                
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.30';
                return $GLOBALS['setup_info']['controller']['currentver'];
+       }
+       
+       $test[] = '0.1.30';
+       function controller_upgrade0_1_30()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('controller_control','description',array(
+                       'type' => 'text', 
+                       'nullable' => true
+               ));
+               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.31';
+               return $GLOBALS['setup_info']['controller']['currentver'];
        }
\ No newline at end of file