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

Timestamp:

08/05/09 16:46:05 (15 years ago)

Author:

viani

Message:

Ticket #589 - Atualizacao de tabelas no organograma do workflow

File:

• trunk/workflow/setup/tables_update.inc.php (modified) (3 diffs)

trunk/workflow/setup/tables_update.inc.php

@@ -1132 +1132 @@
                 return $GLOBALS['setup_info']['workflow']['currentver'];
         }
-        
+
         $test[] = '1.8.04.000';
         function workflow_upgrade1_8_04_000()
@@ -1139 +1139 @@
                 if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)
                 {
-                        $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)');                        
+                        $GLOBALS['phpgw']->ADOdb->query('CREATE INDEX egw_wf_workitems_wf_instance_id_idx ON egw_wf_workitems(wf_instance_id)');
                 }
 
@@ -1146 +1146 @@
                 return $GLOBALS['setup_info']['workflow']['currentver'];
         }
+
+        $test[] = '1.8.05.000';
+        function workflow_upgrade1_8_05_000()
+        {
+                /* Alter tables of orgchart */
+                if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)
+                {
+                        $workflowHostInfo = extractDatabaseParameters();
+
+                        /* connect to workflow database */
+                        $workflowDB = $GLOBALS['phpgw']->ADOdb;
+                        if ($workflowDB->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], 'workflow'))
+                        {
+                                /* add the new columns */
+                                $workflowDB->query('ALTER TABLE public.funcionario ADD COLUMN titulo CHARACTER VARYING(30)');
+                                $workflowDB->query('ALTER TABLE public.organizacao ADD COLUMN sitio CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN empresa CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN endereco CHARACTER VARYING(100)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN complemento CHARACTER VARYING(50)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cep CHARACTER VARYING(9)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN bairro CHARACTER VARYING(30)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN cidade CHARACTER VARYING(50)');
+                                $workflowDB->query('ALTER TABLE public.localidade ADD COLUMN uf CHARACTER(2)');
+
+                                /* create table telefone */
+                                $workflowDB->query('CREATE TABLE public.telefone (telefone_id serial NOT NULL, descricao character varying(50) NOT NULL, numero character varying(50) NOT NULL, organizacao_id integer NOT NULL)');
+                                $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT telefone_pkey PRIMARY KEY (telefone_id)');
+                                $workflowDB->query('ALTER TABLE ONLY public.telefone ADD CONSTRAINT "$1" FOREIGN KEY (organizacao_id) REFERENCES organizacao(organizacao_id)');
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone TO admin_workflow");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone TO postgres");
+                                $workflowDB->query("GRANT SELECT ON TABLE public.telefone TO public");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO admin_workflow");
+                                $workflowDB->query("GRANT ALL ON TABLE public.telefone_telefone_id_seq TO postgres");
+                                $workflowDB->query("GRANT SELECT ON TABLE public.telefone_telefone_id_seq TO public");
+                        }
+
+                        /* reconnect to the previous database */
+                        $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']);
+                }
+                #updating the current version
+                $GLOBALS['setup_info']['workflow']['currentver'] = '1.8.06.000';
+                return $GLOBALS['setup_info']['workflow']['currentver'];
+        }
 ?>