Ignore:
Timestamp:
06/22/12 17:42:39 (12 years ago)
Author:
viani
Message:

Ticket #2851 - Atualização do organograma no branch 2.4

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.4/workflow/setup/tables_update.inc.php

    r5726 r6589  
    326326                        } 
    327327 
    328  
     328                /* reconnect to the previous database */ 
     329                $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); 
    329330                $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.0'; 
    330331                return $GLOBALS['setup_info']['workflow']['currentver']; 
    331332        } 
     333         
     334        $test[] = '2.4.0';       
     335        function workflow_upgrade2_4_0() 
     336        { 
     337         
     338                $workflowHostInfo = extractDatabaseParameters(); 
     339 
     340                /* connect to workflow database */ 
     341                $workflowDB = $GLOBALS['phpgw']->ADOdb; 
     342                if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow')) 
     343                { 
     344                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN funcao CHARACTER VARYING(200)'); 
     345                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN data_admissao DATE'); 
     346                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN apelido CHARACTER VARYING(20)'); 
     347                } 
     348 
     349                /* reconnect to the previous database */ 
     350                $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); 
     351                $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.1'; 
     352                return $GLOBALS['setup_info']['workflow']['currentver']; 
     353        } 
    332354?> 
Note: See TracChangeset for help on using the changeset viewer.