[Phpgroupware-cvs] CVS: projects/setup setup.inc.php,1.11.2.2.2.2,1.11.2.2.2.3 tables_current.inc.php,1.11.2.1.2.2,1.11.2.1.2.3 tables_update.inc.php,1.15.2.1.2.3,1.15.2.1.2.4

[Bettina Gille <address@hidden>]

Update of /cvsroot/phpgroupware/projects/setup
In directory subversions:/tmp/cvs-serv27764/setup

Modified Files:
      Tag: Version-0_9_16-branch
        setup.inc.php tables_current.inc.php tables_update.inc.php 
Log Message:
update

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/setup.inc.php,v
retrieving revision 1.11.2.2.2.2
retrieving revision 1.11.2.2.2.3
diff -C2 -r1.11.2.2.2.2 -r1.11.2.2.2.3
*** setup.inc.php       7 Jun 2003 00:21:39 -0000       1.11.2.2.2.2
--- setup.inc.php       7 Jun 2003 23:34:03 -0000       1.11.2.2.2.3
***************
*** 13,17 ****
        $setup_info['projects']['name']      = 'projects';
        $setup_info['projects']['title']     = 'Projects';
!       $setup_info['projects']['version']   = '0.8.6.003';
        $setup_info['projects']['app_order'] = 13;
        $setup_info['projects']['enable']    = 1;
--- 13,17 ----
        $setup_info['projects']['name']      = 'projects';
        $setup_info['projects']['title']     = 'Projects';
!       $setup_info['projects']['version']   = '0.8.6.004';
        $setup_info['projects']['app_order'] = 13;
        $setup_info['projects']['enable']    = 1;
***************
*** 33,37 ****
                'phpgw_p_invoicepos',
                'phpgw_p_delivery',
!               'phpgw_p_deliverypos'
        );
  
--- 33,38 ----
                'phpgw_p_invoicepos',
                'phpgw_p_delivery',
!               'phpgw_p_deliverypos',
!               'phpgw_p_pcosts'
        );
  

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_current.inc.php,v
retrieving revision 1.11.2.1.2.2
retrieving revision 1.11.2.1.2.3
diff -C2 -r1.11.2.1.2.2 -r1.11.2.1.2.3
*** tables_current.inc.php      7 Jun 2003 00:21:39 -0000       1.11.2.1.2.2
--- tables_current.inc.php      7 Jun 2003 23:34:03 -0000       1.11.2.1.2.3
***************
*** 154,157 ****
--- 154,168 ----
                        'ix' => array(),
                        'uc' => array()
+               ),
+               'phpgw_p_pcosts' => array(
+                       'fd' => array(
+                               'c_id' => array('type' => 'auto','nullable' => 
False),
+                               'project_id' => array('type' => 
'int','precision' => 4,'default' => 0,'nullable' => False),
+                               'month' => array('type' => 'int','precision' => 
4,'default' => 0,'nullable' => False)
+                       ),
+                       'pk' => array('c_id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
                )
        );

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_update.inc.php,v
retrieving revision 1.15.2.1.2.3
retrieving revision 1.15.2.1.2.4
diff -C2 -r1.15.2.1.2.3 -r1.15.2.1.2.4
*** tables_update.inc.php       7 Jun 2003 00:21:39 -0000       1.15.2.1.2.3
--- tables_update.inc.php       7 Jun 2003 23:34:03 -0000       1.15.2.1.2.4
***************
*** 359,361 ****
--- 359,382 ----
                return $GLOBALS['setup_info']['projects']['currentver'];
        }
+ 
+       $test[] = '0.8.6.003';
+       function projects_upgrade0_8_6_003()
+       {
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'phpgw_p_pcosts', array(
+                               'fd' => array(
+                                       'c_id' => array('type' => 
'auto','nullable' => False),
+                                       'project_id' => array('type' => 
'int','precision' => 4,'default' => 0,'nullable' => False),
+                                       'month' => array('type' => 
'int','precision' => 4,'default' => 0,'nullable' => False),
+                                       'pcosts' => array('type' => 
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => False)
+                               ),
+                               'pk' => array('c_id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+               $GLOBALS['setup_info']['projects']['currentver'] = '0.8.6.004';
+               return $GLOBALS['setup_info']['projects']['currentver'];
+       }
  ?>