Changeset 6537 for trunk/workflow/setup/tables_update.inc.php

Timestamp:

06/18/12 16:24:43 (12 years ago)

Author:

leticiabohnert

Message:

Ticket #2851 - Inclusão dos campos função, data adm. e apelido no BD (setup).

File:

• trunk/workflow/setup/tables_update.inc.php (modified) (1 diff)

trunk/workflow/setup/tables_update.inc.php

@@ -330 +330 @@
                 return $GLOBALS['setup_info']['workflow']['currentver'];
         }
+        
+        function workflow_upgrade2_4_0()
+        {
+        
+                $workflowHostInfo = extractDatabaseParameters();
+
+                /* connect to workflow database */
+                $workflowDB = $GLOBALS['phpgw']->ADOdb;
+                if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow'))
+                {
+                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN funcao CHARACTER VARYING(200)');
+                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN data_admissao DATE');
+                        $workflowDB->query('ALTER TABLE ONLY public.funcionario ADD COLUMN apelido CHARACTER VARYING(20)');
+                }
+        
+                $GLOBALS['setup_info']['workflow']['currentver'] = '2.4.1';
+                return $GLOBALS['setup_info']['workflow']['currentver'];
+        }
 ?>