[Fmsystem-commits] [8995] catch: old values in history table

[Sigurd Nes]

Revision: 8995
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8995
Author:   sigurdne
Date:     2012-03-20 14:38:18 +0000 (Tue, 20 Mar 2012)
Log Message:
-----------
catch: old values in history table

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

Modified: trunk/catch/setup/setup.inc.php
===================================================================
--- trunk/catch/setup/setup.inc.php     2012-03-20 12:10:42 UTC (rev 8994)
+++ trunk/catch/setup/setup.inc.php     2012-03-20 14:38:18 UTC (rev 8995)
@@ -27,7 +27,7 @@
         */
 
        $setup_info['catch']['name']                    = 'catch';
-       $setup_info['catch']['version']                 = '0.9.17.512';
+       $setup_info['catch']['version']                 = '0.9.17.513';
        $setup_info['catch']['app_order']               = 20;
        $setup_info['catch']['enable']                  = 1;
        $setup_info['catch']['globals_checked'] = True;

Modified: trunk/catch/setup/tables_current.inc.php
===================================================================
--- trunk/catch/setup/tables_current.inc.php    2012-03-20 12:10:42 UTC (rev 
8994)
+++ trunk/catch/setup/tables_current.inc.php    2012-03-20 14:38:18 UTC (rev 
8995)
@@ -86,6 +86,7 @@
                                'history_owner' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'history_status' => array('type' => 
'char','precision' => '2','nullable' => False),
                                'history_new_value' => array('type' => 
'text','nullable' => False),
+                               'history_old_value' => array('type' => 
'text','nullable' => true),
                                'history_timestamp' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp')
                        ),
                        'pk' => array('history_id'),

Modified: trunk/catch/setup/tables_update.inc.php
===================================================================
--- trunk/catch/setup/tables_update.inc.php     2012-03-20 12:10:42 UTC (rev 
8994)
+++ trunk/catch/setup/tables_update.inc.php     2012-03-20 14:38:18 UTC (rev 
8995)
@@ -364,3 +364,23 @@
                }
        }
 
+       /**
+       * Update catch version from 0.9.17.512 to 0.9.17.513
+       * Add history_old_value
+       */
+
+       $test[] = '0.9.17.512';
+       function catch_upgrade0_9_17_512()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_catch_history','history_old_value',array('type'
 => 'text','nullable' => true));
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['catch']['currentver'] = 
'0.9.17.513';
+                       return $GLOBALS['setup_info']['catch']['currentver'];
+               }
+       }
+
+