[Phpgroupware-cvs] ged/setup tables_update.inc.php

[Pascal Vilarem]

CVSROOT:        /sources/phpgroupware
Module name:    ged
Changes by:     Pascal Vilarem <maat>   07/07/17 14:08:09

Modified files:
        setup          : tables_update.inc.php 

Log message:
        fix : better update of history table when moving from 0.9.18.002 to 
0.9.18.003

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/ged/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.7&r2=1.8

Patches:
Index: tables_update.inc.php
===================================================================
RCS file: /sources/phpgroupware/ged/setup/tables_update.inc.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -b -r1.7 -r1.8
--- tables_update.inc.php       17 Jul 2007 11:13:06 -0000      1.7
+++ tables_update.inc.php       17 Jul 2007 14:08:09 -0000      1.8
@@ -146,7 +146,9 @@
        function ged_upgrade0_9_18_002()
        {       
                $GLOBALS['phpgw_setup']->oProc->query ("UPDATE ged_versions SET 
status='refused' WHERE status='rejected'" );
-               $GLOBALS['phpgw_setup']->oProc->query ("UPDATE ged_history SET 
status='refused' WHERE status='rejected'" );
+               $GLOBALS['phpgw_setup']->oProc->query ("UPDATE ged_history SET 
status='refused', action='refused', comment='refused WHERE status='rejected'" );
+               $GLOBALS['phpgw_setup']->oProc->query ("UPDATE ged_history SET 
action='approved', comment='approved' WHERE action='accepted'" );
+               $GLOBALS['phpgw_setup']->oProc->query ("UPDATE ged_history SET 
action='accepted', comment='accepted' WHERE status='current'" );
                
                $GLOBALS['setup_info']['ged']['currentver']='0.9.18.003';
                return $GLOBALS['setup_info']['ged']['currentver'];