[Fmsystem-commits] [14930] update script

[Sigurd Nes]

Revision: 14930
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=14930
Author:   sigurdne
Date:     2016-04-25 07:38:04 +0000 (Mon, 25 Apr 2016)
Log Message:
-----------
update script

Modified Paths:
--------------
    trunk/property/setup/tables_update.inc.php

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2016-04-22 14:29:43 UTC (rev 
14929)
+++ trunk/property/setup/tables_update.inc.php  2016-04-25 07:38:04 UTC (rev 
14930)
@@ -8935,7 +8935,6 @@
                        )
                );
 
-
                $GLOBALS['phpgw_setup']->oProc->AddColumn("fm_tts_tickets", 
'unspsc_code', array(
                        'type' => 'varchar',
                        'precision' => 15,
@@ -8954,6 +8953,28 @@
                $GLOBALS['phpgw_setup']->oProc->query("UPDATE fm_project SET 
external_project_id = project_group WHERE project_group IS NOT NULL");
 
                $GLOBALS['phpgw_setup']->oProc->DropColumn('fm_project', 
array(), 'project_group');
+
+               $GLOBALS['phpgw_setup']->oProc->query("SELECT * FROM  
fm_project_group");
+
+               $external_projects = array();
+               while($GLOBALS['phpgw_setup']->oProc->next_record())
+               {
+                       $external_projects[] = array
+                       (
+                               'id'            => 
$GLOBALS['phpgw_setup']->oProc->f('id'),
+                               'name'          => 
$GLOBALS['phpgw_setup']->oProc->f('descr'),
+                               'budget'        => 
$GLOBALS['phpgw_setup']->oProc->f('budget')
+                       );
+               }
+
+               foreach($external_projects as $external_project)
+               {
+                       $cols = implode(',', array_keys($external_project));
+                       $values = 
$GLOBALS['phpgw_setup']->oProc->validate_insert(array_values($external_project));
+                       $sql = "INSERT INTO fm_external_project ({$cols}) 
VALUES ({$values})";
+                       $GLOBALS['phpgw_setup']->oProc->query($sql, __LINE__, 
__FILE__);
+               }
+
                $GLOBALS['phpgw_setup']->oProc->DropTable('fm_project_group');
 
                $GLOBALS['phpgw_setup']->oProc->AddColumn("fm_workorder", 
'contract_id', array(
@@ -8963,6 +8984,13 @@
                        )
                );
 
+               $GLOBALS['phpgw_setup']->oProc->AddColumn("fm_agreement", 
'contract_id', array(
+                       'type' => 'varchar',
+                       'precision' => 30,
+                       'nullable' => True
+                       )
+               );
+
                $GLOBALS['phpgw_setup']->oProc->AddColumn("fm_workorder", 
'service_id', array(
                        'type' => 'int',
                        'precision' => 4,