[Phpgroupware-cvs] property/setup tables_update.inc.php

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/02/10 09:10:42

Modified files:
        setup          : tables_update.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_update.inc.php.diff?tr1=1.21&tr2=1.22&r1=text&r2=text

Patches:
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.21 
property/setup/tables_update.inc.php:1.22
--- property/setup/tables_update.inc.php:1.21   Sun Feb  5 20:07:35 2006
+++ property/setup/tables_update.inc.php        Fri Feb 10 09:10:42 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.21 2006/02/05 20:07:35 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.22 2006/02/10 09:10:42 
sigurdne Exp $
        */
 
        /**
@@ -764,9 +764,30 @@
        $test[] = '0.9.17.510';
        function property_upgrade0_9_17_510()
        {
-               
$GLOBALS['phpgw_setup']->oProc->RenameColumn('fm_custom','sql','sql_text');
+               $table_def = array(
+                       'fm_custom' => array(
+                               'fd' => array(
+                                       'id' => array('type' => 
'int','precision' => '4','nullable' => False),
+                                       'name' => array('type' => 
'varchar','precision' => '100','nullable' => False),
+                                       'sql_text' => array('type' => 
'text','nullable' => False),
+                                       'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
+                                       'user_id' => array('type' => 
'int','precision' => '4','nullable' => True)
+                               ),
+                               'pk' => array('id'),
+                               'fk' => array(),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
 
+               $GLOBALS['phpgw_setup']->oProc->m_aTables = $table_def;
+
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+               
+               
$GLOBALS['phpgw_setup']->oProc->RenameColumn('fm_custom','sql','sql_text');
+               
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.511';
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();    
        
                return $GLOBALS['setup_info']['property']['currentver'];
        }
 
@@ -777,6 +798,8 @@
        $test[] = '0.9.17.511';
        function property_upgrade0_9_17_511()
        {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
                
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_entity_attribute','history',array('type'
 => 'int','precision' => 2,'nullable' => True));
 
                $GLOBALS['phpgw_setup']->oProc->CreateTable(
@@ -799,6 +822,7 @@
                );
 
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.512';
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit();
                return $GLOBALS['setup_info']['property']['currentver'];
        }