[Fmsystem-commits] [10362] booking: alter size on building_name

[Sigurd Nes]

Revision: 10362
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10362
Author:   sigurdne
Date:     2012-10-29 08:11:44 +0000 (Mon, 29 Oct 2012)
Log Message:
-----------
booking: alter size on building_name

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

Modified: trunk/booking/setup/setup.inc.php
===================================================================
--- trunk/booking/setup/setup.inc.php   2012-10-28 17:01:48 UTC (rev 10361)
+++ trunk/booking/setup/setup.inc.php   2012-10-29 08:11:44 UTC (rev 10362)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['booking']['name'] = 'booking';
-       $setup_info['booking']['version'] = '0.2.10';
+       $setup_info['booking']['version'] = '0.2.11';
        $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-10-28 17:01:48 UTC (rev 
10361)
+++ trunk/booking/setup/tables_current.inc.php  2012-10-29 08:11:44 UTC (rev 
10362)
@@ -175,7 +175,7 @@
                                'created' => array('type' => 'timestamp', 
'nullable'=> False, 'default' => 'current_timestamp'),
                                'modified' => array('type' => 'timestamp', 
'nullable'=> False),
                                'frontend_modified' => array('type' => 
'timestamp', 'nullable'=> True),
-                               'building_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
+                               'building_name' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False, 'default' => 'changeme'),
                                'activity_id' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'description' => array('type' => 'text', 
'nullable' => False),
                                'contact_name' => array('type' => 'text', 
'nullable' => False),
@@ -203,7 +203,7 @@
                                'id' => array('type' => 'auto', 'nullable' => 
False),
                                'id_string' => array('type' => 
'varchar','precision' => '20', 'nullable' => False, 'default' => '0'),
                                'active' => array('type' => 'int', 'nullable' 
=> False,'precision' => '4', 'default' => 1),
-                               'building_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
+                               'building_name' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False, 'default' => 'changeme'),
                                'application_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'organization_id' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'from_' => array('type' => 
'timestamp','nullable' => False),
@@ -226,7 +226,7 @@
                                'group_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'from_' => array('type' => 
'timestamp','nullable' => False),
                                'to_' => array('type' => 'timestamp','nullable' 
=> False),
-                               'building_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
+                               'building_name' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False, 'default' => 'changeme'),
                                'allocation_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'season_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'active' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False,'default' => '1'),
@@ -523,7 +523,7 @@
                                'from_' => array('type' => 
'timestamp','nullable' => False),
                                'to_' => array('type' => 'timestamp','nullable' 
=> False),
                                'cost' => array('type' => 'decimal', 
'precision' => 10, 'scale' => 2,'nullable' => True,'default' => '0.0'),
-                               'building_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
+                               'building_name' => array('type' => 'varchar', 
'precision' => 100,'nullable' => False, 'default' => 'changeme'),
                                'contact_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
                                'contact_email' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
                                'contact_phone' => array('type' => 'varchar', 
'precision' => 50,'nullable' => False),
@@ -757,7 +757,7 @@
                                'created' => array('type' => 'timestamp', 
'nullable' => False,'default' => 'current_timestamp'),
                                'display_in_dashboard' => array('type' => 
'int', 'nullable' => False, 'precision' => '4', 'default' => 1),
                                'building_id' => array('type' => 'int', 
'precision' => '4'),
-                               'building_name' => array('type' => 'varchar', 
'precision' => '50','nullable' => False),
+                               'building_name' => array('type' => 'varchar', 
'precision' => '100','nullable' => False),
                                'name' => array('type' => 'varchar','precision' 
=> '50','nullable' => False),
                                'phone' => array('type' => 
'varchar','precision' => '50','nullable' => true),
                                'email' => array('type' => 
'varchar','precision' => '50','nullable' => true),

Modified: trunk/booking/setup/tables_update.inc.php
===================================================================
--- trunk/booking/setup/tables_update.inc.php   2012-10-28 17:01:48 UTC (rev 
10361)
+++ trunk/booking/setup/tables_update.inc.php   2012-10-29 08:11:44 UTC (rev 
10362)
@@ -2657,4 +2657,56 @@
                }
        }
 
+       $test[] = '0.2.10';
+       /**
+       * Update booking version from 0.2.10 to 0.2.11
+       * add description to bb_office
+       * 
+       */
+       function booking_upgrade0_2_10()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
 
+
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('bb_application','building_name',array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => False,
+                       'default' => 'changeme'
+                       )
+               );
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('bb_allocation','building_name',array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => False,
+                       'default' => 'changeme'
+                       )
+               );
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('bb_booking','building_name',array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => False,
+                       'default' => 'changeme'
+                       )
+               );
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('bb_event','building_name',array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => False,
+                       'default' => 'changeme'
+                       )
+               );
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('bb_system_message','building_name',array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => False,
+                       'default' => 'changeme'
+                       )
+               );
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['booking']['currentver'] = 
'0.2.11';
+                       return $GLOBALS['setup_info']['booking']['currentver'];
+               }
+       }