[Fmsystem-commits] [14934] API: Add table for file relation to multiple items

[Sigurd Nes]

Revision: 14934
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=14934
Author:   sigurdne
Date:     2016-04-25 14:17:03 +0000 (Mon, 25 Apr 2016)
Log Message:
-----------
API: Add table for file relation to multiple items

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

Modified: trunk/phpgwapi/setup/setup.inc.php
===================================================================
--- trunk/phpgwapi/setup/setup.inc.php  2016-04-25 13:34:40 UTC (rev 14933)
+++ trunk/phpgwapi/setup/setup.inc.php  2016-04-25 14:17:03 UTC (rev 14934)
@@ -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.549';
+       $setup_info['phpgwapi']['version']   = '0.9.17.550';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '2.0';
        $setup_info['phpgwapi']['enable']    = 3;
@@ -64,6 +64,7 @@
                'phpgw_sessions',
                'phpgw_vfs',
                'phpgw_vfs_filedata',
+               'phpgw_vfs_file_relation',
                'phpgw_config2_section',
                'phpgw_config2_attrib',
                'phpgw_config2_choice',

Modified: trunk/phpgwapi/setup/tables_current.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_current.inc.php 2016-04-25 13:34:40 UTC (rev 
14933)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2016-04-25 14:17:03 UTC (rev 
14934)
@@ -309,7 +309,23 @@
                        'ix' => array(),
                        'uc' => array()
                ),
-
+               'phpgw_vfs_file_relation' => array(
+                       'fd' => array(
+                               'relation_id'           => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'file_id'                       => array('type' 
=> 'int','precision' => '4','nullable' => False),
+                               'location_id'           => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'location_item_id'      => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'is_private'            => array('type' => 
'int','precision' => '2','nullable' => False),
+                               'account_id'            => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'entry_date'            => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'start_date'            => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'end_date'                      => array('type' 
=> 'int','precision' => '8 ','nullable' => False),
+                       ),
+                       'pk' => array('relation_id'),
+                       'fk' => array('phpgw_vfs' => array('file_id' => 
'file_id')),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
                'phpgw_history_log' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => 4,'nullable' => False),

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2016-04-25 13:34:40 UTC (rev 
14933)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2016-04-25 14:17:03 UTC (rev 
14934)
@@ -3324,3 +3324,38 @@
                }
        }
 
+       $test[] = '0.9.17.549';
+       /**
+       * Add table for file relation to multiple items
+       * @return string the new version number
+       */
+       function phpgwapi_upgrade0_9_17_549()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_vfs_file_relation',array(
+                       'fd' => array(
+                               'relation_id'           => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'file_id'                       => array('type' 
=> 'int','precision' => '4','nullable' => False),
+                               'location_id'           => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'location_item_id'      => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'is_private'            => array('type' => 
'int','precision' => '2','nullable' => False),
+                               'account_id'            => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'entry_date'            => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'start_date'            => array('type' => 
'int','precision' => '8','nullable' => False),
+                               'end_date'                      => array('type' 
=> 'int','precision' => '8 ','nullable' => False),
+                       ),
+                       'pk' => array('relation_id'),
+                       'fk' => array('phpgw_vfs' => array('file_id' => 
'file_id')),
+                       'ix' => array(),
+                       'uc' => array()
+                       )
+               );
+
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.550';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }