[Fmsystem-commits] [10608] property: table for tracing funding to and from buffer-projects

[Sigurd Nes]

Revision: 10608
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10608
Author:   sigurdne
Date:     2012-12-17 15:27:03 +0000 (Mon, 17 Dec 2012)
Log Message:
-----------
property: table for tracing funding to and from buffer-projects

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

Modified: trunk/property/setup/setup.inc.php
===================================================================
--- trunk/property/setup/setup.inc.php  2012-12-17 14:04:13 UTC (rev 10607)
+++ trunk/property/setup/setup.inc.php  2012-12-17 15:27:03 UTC (rev 10608)
@@ -12,7 +12,7 @@
        */
 
        $setup_info['property']['name']                 = 'property';
-       $setup_info['property']['version']              = '0.9.17.657';
+       $setup_info['property']['version']              = '0.9.17.658';
        $setup_info['property']['app_order']    = 8;
        $setup_info['property']['enable']               = 1;
        $setup_info['property']['app_group']    = 'office';

Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2012-12-17 14:04:13 UTC (rev 
10607)
+++ trunk/property/setup/tables_current.inc.php 2012-12-17 15:27:03 UTC (rev 
10608)
@@ -1542,6 +1542,24 @@
                        'ix' => array(),
                        'uc' => array()
                ),
+               'fm_project_buffer_budget' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
+                               'buffer_project_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'entry_date' => array('type' => 
'int','precision' => '4','nullable' => False),
+                               'amount_in' => array('type' => 
'int','precision' => '4','nullable' => true),
+                               'amount_in' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
+                               'from_project' => array('type' => 
'int','precision' => '4','nullable' => true),
+                               'amount_out' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
+                               'to_project' => array('type' => 
'int','precision' => '4','nullable' => true),
+                               'user_id' => array('type' => 'int','precision' 
=> '4','nullable' => False),
+                               'remark' => array('type' => 'text','nullable' 
=> true),
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
                'fm_project_group' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2012-12-17 14:04:13 UTC (rev 
10607)
+++ trunk/property/setup/tables_update.inc.php  2012-12-17 15:27:03 UTC (rev 
10608)
@@ -7042,12 +7042,30 @@
                        )
                );
 
-// tabell for fm_project_buffer_budget
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'fm_project_buffer_budget', array(
+                               'fd' => array(
+                                       'id' => array('type' => 
'auto','precision' => '4','nullable' => False),
+                                       'buffer_project_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                                       'entry_date' => array('type' => 
'int','precision' => '4','nullable' => False),
+                                       'amount_in' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
+                                       'from_project' => array('type' => 
'int','precision' => '4','nullable' => true),
+                                       'amount_out' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
+                                       'to_project' => array('type' => 
'int','precision' => '4','nullable' => true),
+                                       'user_id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                                       'remark' => array('type' => 
'text','nullable' => true),
+                               ),
+                               'pk' => array('id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
 
+
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
                {
                        $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.658';
                        return $GLOBALS['setup_info']['property']['currentver'];
                }
        }
-