[Fmsystem-commits] [15985] add md5sum field

[sigurdne]

Revision: 15985
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15985
Author:   sigurdne
Date:     2016-11-10 16:10:18 +0000 (Thu, 10 Nov 2016)
Log Message:
-----------
add md5sum field

Modified Paths:
--------------
    branches/dev-syncromind-2/phpgwapi/setup/setup.inc.php
    branches/dev-syncromind-2/phpgwapi/setup/tables_current.inc.php
    branches/dev-syncromind-2/phpgwapi/setup/tables_update.inc.php

Modified: branches/dev-syncromind-2/phpgwapi/setup/setup.inc.php
===================================================================
--- branches/dev-syncromind-2/phpgwapi/setup/setup.inc.php      2016-11-10 
02:30:02 UTC (rev 15984)
+++ branches/dev-syncromind-2/phpgwapi/setup/setup.inc.php      2016-11-10 
16:10:18 UTC (rev 15985)
@@ -12,7 +12,7 @@
        // Basic information about this app
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
-       $setup_info['phpgwapi']['version']   = '0.9.17.552';
+       $setup_info['phpgwapi']['version']   = '0.9.17.553';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '2.0';
        $setup_info['phpgwapi']['enable']    = 3;

Modified: branches/dev-syncromind-2/phpgwapi/setup/tables_current.inc.php
===================================================================
--- branches/dev-syncromind-2/phpgwapi/setup/tables_current.inc.php     
2016-11-10 02:30:02 UTC (rev 15984)
+++ branches/dev-syncromind-2/phpgwapi/setup/tables_current.inc.php     
2016-11-10 16:10:18 UTC (rev 15985)
@@ -291,6 +291,7 @@
                                'version' => array('type' => 
'varchar','precision' => 30,'nullable' => False,'default' => '0.0.0.0'),
                                'content' => array('type' => 'text','nullable' 
=> True),
                                'external_id' => array('type' => 
'int','precision' => 8,'nullable' => True),
+                               'md5_sum' => array('type' => 
'varchar','precision' => '64','nullable' => True),
                        ),
                        'pk' => array('file_id'),
                        'fk' => array(),

Modified: branches/dev-syncromind-2/phpgwapi/setup/tables_update.inc.php
===================================================================
--- branches/dev-syncromind-2/phpgwapi/setup/tables_update.inc.php      
2016-11-10 02:30:02 UTC (rev 15984)
+++ branches/dev-syncromind-2/phpgwapi/setup/tables_update.inc.php      
2016-11-10 16:10:18 UTC (rev 15985)
@@ -3428,3 +3428,31 @@
                        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
                }
        }
+
+       $test[] = '0.9.17.552';
+       /**
+       * Alter column definition
+       * @return string the new version number
+       */
+       function phpgwapi_upgrade0_9_17_552()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               $metadata = 
$GLOBALS['phpgw_setup']->oProc->m_odb->metadata('phpgw_vfs');
+
+               if(empty($metadata['md5_sum']))
+               {
+                       
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_vfs','md5_sum', array(
+                               'type' => 'varchar',
+                               'precision' => 64,
+                               'nullable' => true
+                       ));
+
+               }
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.553';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }