[Fmsystem-commits] [8894] changed datatype of responsibility on controller_procedure to text

[Erik Holm-Larsen]

Revision: 8894
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8894
Author:   erikhl
Date:     2012-02-16 11:00:55 +0000 (Thu, 16 Feb 2012)
Log Message:
-----------
changed datatype of responsibility on controller_procedure to text
added record procedure on table controller_document_types

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-02-16 10:50:18 UTC (rev 
8893)
+++ trunk/controller/setup/setup.inc.php        2012-02-16 11:00:55 UTC (rev 
8894)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.29';
+       $setup_info['controller']['version'] = '0.1.30';
        $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-02-16 10:50:18 UTC 
(rev 8893)
+++ trunk/controller/setup/tables_current.inc.php       2012-02-16 11:00:55 UTC 
(rev 8894)
@@ -90,7 +90,7 @@
                                'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
                                'title' => array('type' => 'varchar', 
'precision' => 255, 'nullable' => False),
                                'purpose' => array('type' => 'text', 'nullable' 
=> True),
-                               'responsibility' => array('type' => 'varchar', 
'precision' => 255, 'nullable' => True),
+                               'responsibility' => array('type' => 'text', 
'nullable' => True),
                                'description' => array('type' => 'text', 
'nullable' => True),
                                'reference' => array('type' => 'text', 
'nullable' => True),
                                'attachment' => array('type' => 'varchar', 
'precision' => 255, 'nullable' => True),

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2012-02-16 10:50:18 UTC 
(rev 8893)
+++ trunk/controller/setup/tables_update.inc.php        2012-02-16 11:00:55 UTC 
(rev 8894)
@@ -605,4 +605,20 @@
                
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.29';
                return $GLOBALS['setup_info']['controller']['currentver'];
+       }
+       
+       $test[] = '0.1.29';
+       function controller_upgrade0_1_29()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('controller_procedure','responsibility',array(
+                       'type' => 'text', 
+                       'nullable' => true
+               ));
+               
+               $sql = "INSERT INTO controller_document_types (title) 
values('procedures')";
+               $db = clone $GLOBALS['phpgw']->db;
+               $result = $db->query($sql, __LINE__, __FILE__);
+                               
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.30';
+               return $GLOBALS['setup_info']['controller']['currentver'];
        }
\ No newline at end of file