[Phpgroupware-cvs] CVS: projects/setup phpgw_de.lang, 1.17.2.4.2.11, 1.17.2.4.2.12 setup.inc.php, 1.11.2.2.2.3, 1.11.2.2.2.4 tables_current.inc.php, 1.11.2.1.2.4, 1.11.2.1.2.5 tables_update.inc.php, 1.15.2.1.2.4, 1.15.2.1.2.5

[Bettina Gille <address@hidden>]

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

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

Index: phpgw_de.lang
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/phpgw_de.lang,v
retrieving revision 1.17.2.4.2.11
retrieving revision 1.17.2.4.2.12
diff -C2 -r1.17.2.4.2.11 -r1.17.2.4.2.12
*** phpgw_de.lang       20 Jun 2003 22:04:33 -0000      1.17.2.4.2.11
--- phpgw_de.lang       25 Jul 2003 01:09:40 -0000      1.17.2.4.2.12
***************
*** 60,63 ****
--- 60,64 ----
  generate delivery id ?        projects        de      Lieferungs ID 
generieren ?
  generate invoice id ? projects        de      Rechnungs ID generieren ?
+ generate job id ?     projects        de      Job ID generieren ?
  generate project id ? projects        de      Projekt ID generieren ?
  georgia       projects        de      Georgia

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/setup.inc.php,v
retrieving revision 1.11.2.2.2.3
retrieving revision 1.11.2.2.2.4
diff -C2 -r1.11.2.2.2.3 -r1.11.2.2.2.4
*** setup.inc.php       7 Jun 2003 23:34:03 -0000       1.11.2.2.2.3
--- setup.inc.php       25 Jul 2003 01:09:40 -0000      1.11.2.2.2.4
***************
*** 13,25 ****
        $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;
  
!       $setup_info['backup']['author'] = 'Bettina Gille';
!       $setup_info['backup']['license']  = 'GPL';
!       $setup_info['backup']['description'] = 'Advanced project management';
!       $setup_info['backup']['maintainer'] = $setup_info['backup']['author'];
!       $setup_info['backup']['maintainer_email'] = 'address@hidden';
  
        $setup_info['projects']['tables'] = array
--- 13,25 ----
        $setup_info['projects']['name']      = 'projects';
        $setup_info['projects']['title']     = 'Projects';
!       $setup_info['projects']['version']   = '0.8.6.005';
        $setup_info['projects']['app_order'] = 13;
        $setup_info['projects']['enable']    = 1;
  
!       $setup_info['projects']['author'] = 'Bettina Gille';
!       $setup_info['projects']['license']  = 'GPL';
!       $setup_info['projects']['description'] = 'Advanced project management';
!       $setup_info['projects']['maintainer'] = 
$setup_info['projects']['author'];
!       $setup_info['projects']['maintainer_email'] = 'address@hidden';
  
        $setup_info['projects']['tables'] = array

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_current.inc.php,v
retrieving revision 1.11.2.1.2.4
retrieving revision 1.11.2.1.2.5
diff -C2 -r1.11.2.1.2.4 -r1.11.2.1.2.5
*** tables_current.inc.php      11 Jun 2003 21:35:57 -0000      1.11.2.1.2.4
--- tables_current.inc.php      25 Jul 2003 01:09:40 -0000      1.11.2.1.2.5
***************
*** 19,23 ****
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
!                               'num' => array('type' => 'varchar','precision' 
=> 25,'nullable' => False),
                                'owner' => array('type' => 'int','precision' => 
4,'default' => 0,'nullable' => False),
                                'access' => array('type' => 
'varchar','precision' => 7,'nullable' => True),
--- 19,23 ----
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
!                               'num' => array('type' => 'varchar','precision' 
=> 255,'nullable' => False),
                                'owner' => array('type' => 'int','precision' => 
4,'default' => 0,'nullable' => False),
                                'access' => array('type' => 
'varchar','precision' => 7,'nullable' => True),
***************
*** 37,41 ****
                                'processor' => array('type' => 
'int','precision' => 4,'default' => 0,'nullable' => False),
                                'investment_nr' => array('type' => 
'varchar','precision' => 50,'nullable' => False),
!                               'pcosts' => array('type' => 
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => False)
                        ),
                        'pk' => array('id'),
--- 37,43 ----
                                'processor' => array('type' => 
'int','precision' => 4,'default' => 0,'nullable' => False),
                                'investment_nr' => array('type' => 
'varchar','precision' => 50,'nullable' => False),
!                               'pcosts' => array('type' => 
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => False),
!                               'main' => array('type' => 'int','precision' => 
4,'default' => 0,'nullable' => False),
!                               'level' => array('type' => 'int','precision' => 
4,'default' => 0,'nullable' => False)
                        ),
                        'pk' => array('id'),

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/setup/tables_update.inc.php,v
retrieving revision 1.15.2.1.2.4
retrieving revision 1.15.2.1.2.5
diff -C2 -r1.15.2.1.2.4 -r1.15.2.1.2.5
*** tables_update.inc.php       7 Jun 2003 23:34:03 -0000       1.15.2.1.2.4
--- tables_update.inc.php       25 Jul 2003 01:09:40 -0000      1.15.2.1.2.5
***************
*** 380,382 ****
--- 380,393 ----
                return $GLOBALS['setup_info']['projects']['currentver'];
        }
+ 
+       $test[] = '0.8.6.004';
+       function projects_upgrade0_8_6_004()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_p_projects','main',array('type'
 => 'int','precision' => 4,'default' => 0,'nullable' => False));
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_p_projects','level',array('type'
 => 'int','precision' => 4,'default' => 0,'nullable' => False));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_p_projects','num',array('type'
 => 'varchar','precision' => 255,'nullable' => False));
+ 
+               $GLOBALS['setup_info']['projects']['currentver'] = '0.8.6.005';
+               return $GLOBALS['setup_info']['projects']['currentver'];
+       }
  ?>