Changeset 3061 for sandbox/workflow/branches/1015/setup/tables_update.inc.php

Timestamp:

07/15/10 17:50:39 (14 years ago)

Author:

viani

Message:

Ticket #1015 - Merged 2466:3060 /sandbox/workflow/trunk/ em /sandbox/workflow/branches/1015

File:

• sandbox/workflow/branches/1015/setup/tables_update.inc.php (modified) (3 diffs)

sandbox/workflow/branches/1015/setup/tables_update.inc.php

@@ -1216 +1216 @@
         {
                 #updating the current version
+                $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.003';
+                return $GLOBALS['setup_info']['workflow']['currentver'];
+        }
+        $test[] = '2.0.003';
+        function workflow_upgrade2_0_003()
+        {
+                #updating the current version
+                $GLOBALS['setup_info']['workflow']['currentver'] = '2.0.004';
+                return $GLOBALS['setup_info']['workflow']['currentver'];
+        }
+        $test[] = '2.0.004';
+        function workflow_upgrade2_0_004()
+        {
+                #updating the current version
                 $GLOBALS['setup_info']['workflow']['currentver'] = '2.1.000';
                 return $GLOBALS['setup_info']['workflow']['currentver'];
@@ -1224 +1238 @@
                 if (!$GLOBALS['phpgw_setup']->oProc->m_bDeltaOnly)
                 {
+                        /* updating log level */
+                        $values = array('0', 'workflow', 'log_level');
+                        $GLOBALS['phpgw']->ADOdb->query('UPDATE phpgw_config SET config_value=? WHERE config_app=? AND config_name=?', $values);
+
                         $workflowHostInfo = extractDatabaseParameters();
 
@@ -1260 +1278 @@
                         /* reconnect to the previous database */
                         $GLOBALS['phpgw']->ADOdb->connect($workflowHostInfo['host'], $workflowHostInfo['user'], $workflowHostInfo['password'], $workflowHostInfo['dbname']);
+
+                        /* removing primary key of egw_wf_interinstance_relations */
+                        $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations DROP CONSTRAINT egw_wf_interinstance_relations_pkey');
+
+                        /* removing wf_parent_activity_id column from egw_wf_interinstance_relations table */
+                        $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations DROP COLUMN wf_parent_activity_id');
+
+                        /* adding primary key without the column removed */
+                        $GLOBALS['phpgw']->ADOdb->query('ALTER TABLE egw_wf_interinstance_relations ADD CONSTRAINT egw_wf_interinstance_relations_pkey PRIMARY KEY (wf_parent_instance_id, wf_child_instance_id)');
                 }