[Fmsystem-commits] [7266] added update script

[Erik Holm-Larsen]

Revision: 7266
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7266
Author:   erikhl
Date:     2011-05-09 05:20:52 +0000 (Mon, 09 May 2011)
Log Message:
-----------
added update script
changed column in activity

Modified Paths:
--------------
    trunk/activitycalendar/setup/setup.inc.php
    trunk/activitycalendar/setup/tables_current.inc.php

Added Paths:
-----------
    trunk/activitycalendar/setup/tables_update.inc.php

Modified: trunk/activitycalendar/setup/setup.inc.php
===================================================================
--- trunk/activitycalendar/setup/setup.inc.php  2011-05-06 13:12:02 UTC (rev 
7265)
+++ trunk/activitycalendar/setup/setup.inc.php  2011-05-09 05:20:52 UTC (rev 
7266)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['activitycalendar']['name'] = 'activitycalendar';
-       $setup_info['activitycalendar']['version'] = '0.1';
+       $setup_info['activitycalendar']['version'] = '0.1.1';
        $setup_info['activitycalendar']['app_order'] = 60;
        $setup_info['activitycalendar']['enable'] = 1;
        $setup_info['activitycalendar']['app_group']    = 'office';

Modified: trunk/activitycalendar/setup/tables_current.inc.php
===================================================================
--- trunk/activitycalendar/setup/tables_current.inc.php 2011-05-06 13:12:02 UTC 
(rev 7265)
+++ trunk/activitycalendar/setup/tables_current.inc.php 2011-05-09 05:20:52 UTC 
(rev 7266)
@@ -8,7 +8,7 @@
                                'group_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
                                'district' => array('type' => 
'varchar','precision' => '255'),
                                'category' => array('type' => 'int', 
'precision' => 4, 'nullable' => True),
-                               'target' => array('type' => 'int', 'precision' 
=> 4, 'nullable' => True),
+                               'target' => array('type' => 'varchar', 
'precision' => '255'),
                                'office' => array('type' => 'int', 'precision' 
=> 4, 'nullable' => True),
                                'state' => array('type' => 'int', 'precision' 
=> 4, 'nullable' => True),
                                'description' => array('type' => 
'varchar','precision' => '255'),

Added: trunk/activitycalendar/setup/tables_update.inc.php
===================================================================
--- trunk/activitycalendar/setup/tables_update.inc.php                          
(rev 0)
+++ trunk/activitycalendar/setup/tables_update.inc.php  2011-05-09 05:20:52 UTC 
(rev 7266)
@@ -0,0 +1,18 @@
+<?php
+
+       /**
+        * Update Activitycalendar from v 0.1 to 0.1.1
+        */
+
+       $test[] = '0.1';
+       function activitycalendar_upgrade0_1()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('activity_activity','target',array(
+                       'type' => 'varchar', 
+                       'precision' => '255'
+               ));
+               
+               $GLOBALS['setup_info']['activitycalendar']['currentver'] = 
'0.1.1';
+               return $GLOBALS['setup_info']['activitycalendar']['currentver'];
+       }
+?>
\ No newline at end of file