[Fmsystem-commits] [6530] bkbooking: added missing sql update in setup

[Kjell Arne Espedal]

Revision: 6530
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6530
Author:   kjell
Date:     2010-11-02 07:24:51 +0000 (Tue, 02 Nov 2010)
Log Message:
-----------
bkbooking: added missing sql update in setup

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

Modified: trunk/booking/setup/tables_update.inc.php
===================================================================
--- trunk/booking/setup/tables_update.inc.php   2010-11-01 18:05:52 UTC (rev 
6529)
+++ trunk/booking/setup/tables_update.inc.php   2010-11-02 07:24:51 UTC (rev 
6530)
@@ -2371,8 +2371,7 @@
        {
 
                $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
-
-               $GLOBALS['phpgw_setup']->oProc->m_odb->query("");
+               $GLOBALS['phpgw_setup']->oProc->m_odb->query("ALTER TABLE 
bb_application ADD COLUMN building_name varchar(50) NOT NULL DEFAULT 
'changeme'");
                $GLOBALS['phpgw_setup']->oProc->m_odb->query("UPDATE 
bb_application SET building_name = b2.name FROM bb_building b2 WHERE EXISTS 
(SELECT 1 FROM bb_building b, bb_application a, bb_application_resource 
ar,bb_resource r WHERE a.activity_id = ar.application_id AND ar.resource_id = 
r.id AND r.building_id = b.id AND b2.id=b.id AND bb_booking.id=bo.id)");
 
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())