Changeset 6589 for branches/2.4/workflow/setup/tables_update.inc.php
- Timestamp:
- 06/22/12 17:42:39 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.4/workflow/setup/tables_update.inc.php
r5726 r6589 326 326 } 327 327 328 328 /* reconnect to the previous database */ 329 $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']); 329 330 $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.0'; 330 331 return $GLOBALS['setup_info']['workflow']['currentver']; 331 332 } 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 } 332 354 ?>
Note: See TracChangeset
for help on using the changeset viewer.