[Fmsystem-commits] [9863] booking: add description to table bb_office

[Sigurd Nes]

Revision: 9863
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9863
Author:   sigurdne
Date:     2012-08-15 16:15:40 +0000 (Wed, 15 Aug 2012)
Log Message:
-----------
booking: add description to table bb_office

Modified Paths:
--------------
    trunk/booking/setup/setup.inc.php
    trunk/booking/setup/tables_current.inc.php
    trunk/booking/setup/tables_update.inc.php
    trunk/property/inc/class.sogeneric.inc.php

Modified: trunk/booking/setup/setup.inc.php
===================================================================
--- trunk/booking/setup/setup.inc.php   2012-08-15 12:24:20 UTC (rev 9862)
+++ trunk/booking/setup/setup.inc.php   2012-08-15 16:15:40 UTC (rev 9863)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['booking']['name'] = 'booking';
-       $setup_info['booking']['version'] = '0.2.09';
+       $setup_info['booking']['version'] = '0.2.10';
        $setup_info['booking']['app_order'] = 9;
        $setup_info['booking']['enable'] = 1;
        $setup_info['booking']['app_group'] = 'office';

Modified: trunk/booking/setup/tables_current.inc.php
===================================================================
--- trunk/booking/setup/tables_current.inc.php  2012-08-15 12:24:20 UTC (rev 
9862)
+++ trunk/booking/setup/tables_current.inc.php  2012-08-15 16:15:40 UTC (rev 
9863)
@@ -774,6 +774,7 @@
                        'fd' => array(
                                'id' => array('type' => 'auto', 'precision' => 
4,'nullable' => False),
                                'name' => array('type' => 'varchar', 
'precision' => 200,'nullable' => False),
+                               'description' => array('type' => 'text', 
'nullable' => true),
                                'user_id' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
                                'entry_date' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'modified_date' => array('type' => 'int', 
'precision' => 4,'nullable' => True),

Modified: trunk/booking/setup/tables_update.inc.php
===================================================================
--- trunk/booking/setup/tables_update.inc.php   2012-08-15 12:24:20 UTC (rev 
9862)
+++ trunk/booking/setup/tables_update.inc.php   2012-08-15 16:15:40 UTC (rev 
9863)
@@ -2634,4 +2634,27 @@
                }
        }
 
+       $test[] = '0.2.09';
+       /**
+       * Update booking version from 0.2.09 to 0.2.10
+       * add description to bb_office
+       * 
+       */
+       function booking_upgrade0_2_09()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
 
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('bb_office','description',array(
+                       'type'          => 'text',
+                       'nullable'      => true
+                       )
+               );
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['booking']['currentver'] = 
'0.2.10';
+                       return $GLOBALS['setup_info']['booking']['currentver'];
+               }
+       }
+
+

Modified: trunk/property/inc/class.sogeneric.inc.php
===================================================================
--- trunk/property/inc/class.sogeneric.inc.php  2012-08-15 12:24:20 UTC (rev 
9862)
+++ trunk/property/inc/class.sogeneric.inc.php  2012-08-15 16:15:40 UTC (rev 
9863)
@@ -2395,6 +2395,12 @@
                                                                'name' => 
'name',
                                                                'descr' => 
lang('name'),
                                                                'type' => 
'varchar'
+                                                       ),
+                                                       array
+                                                       (
+                                                               'name' => 
'description',
+                                                               'descr' => 
lang('description'),
+                                                               'type' => 'text'
                                                        )
                                                ),
                                                'edit_msg'                      
=> lang('edit'),