fmsystem-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Fmsystem-commits] [15621] sms: alter field


From: sigurdne
Subject: [Fmsystem-commits] [15621] sms: alter field
Date: Thu, 8 Sep 2016 10:55:50 +0000 (UTC)

Revision: 15621
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=15621
Author:   sigurdne
Date:     2016-09-08 10:55:50 +0000 (Thu, 08 Sep 2016)
Log Message:
-----------
sms: alter field

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

Modified: trunk/sms/setup/setup.inc.php
===================================================================
--- trunk/sms/setup/setup.inc.php       2016-09-08 09:25:49 UTC (rev 15620)
+++ trunk/sms/setup/setup.inc.php       2016-09-08 10:55:50 UTC (rev 15621)
@@ -9,7 +9,7 @@
         * @version $Id$
         */
        $setup_info['sms']['name'] = 'sms';
-       $setup_info['sms']['version'] = '0.9.17.513';
+       $setup_info['sms']['version'] = '0.9.17.514';
        $setup_info['sms']['app_order'] = 8;
        $setup_info['sms']['enable'] = 1;
        $setup_info['sms']['app_group'] = 'office';

Modified: trunk/sms/setup/tables_current.inc.php
===================================================================
--- trunk/sms/setup/tables_current.inc.php      2016-09-08 09:25:49 UTC (rev 
15620)
+++ trunk/sms/setup/tables_current.inc.php      2016-09-08 10:55:50 UTC (rev 
15621)
@@ -214,7 +214,7 @@
                                'in_sender' => array('type' => 'varchar', 
'precision' => 20, 'nullable' => False),
                                'in_masked' => array('type' => 'varchar', 
'precision' => 20, 'nullable' => False),
                                'in_code' => array('type' => 'varchar', 
'precision' => 20, 'nullable' => False),
-                               'in_msg' => array('type' => 'varchar', 
'precision' => 200, 'nullable' => False),
+                               'in_msg' => array('type' => 'text', 'nullable' 
=> False),
                                'in_datetime' => array('type' => 'timestamp', 
'nullable' => False, 'default' => 'current_timestamp')
                        ),
                        'pk' => array('in_id'),
@@ -287,7 +287,7 @@
                                'in_id' => array('type' => 'auto', 'nullable' 
=> False),
                                'in_sender' => array('type' => 'varchar', 
'precision' => 20, 'nullable' => False),
                                'in_uid' => array('type' => 'int', 'precision' 
=> 4, 'nullable' => False, 'default' => '0'),
-                               'in_msg' => array('type' => 'varchar', 
'precision' => 200, 'nullable' => False),
+                               'in_msg' => array('type' => 'text', 'nullable' 
=> False),
                                'in_datetime' => array('type' => 'timestamp', 
'nullable' => False, 'default' => 'current_timestamp'),
                                'in_hidden' => array('type' => 'int', 
'precision' => 2, 'nullable' => False,
                                        'default' => '0')

Modified: trunk/sms/setup/tables_update.inc.php
===================================================================
--- trunk/sms/setup/tables_update.inc.php       2016-09-08 09:25:49 UTC (rev 
15620)
+++ trunk/sms/setup/tables_update.inc.php       2016-09-08 10:55:50 UTC (rev 
15621)
@@ -587,7 +587,7 @@
                                break;
                        }
                }
-       
+
                $receipt = $custom_config->add_attrib(array(
                        'section_id' => $section_id,
                        'input_type' => 'text',
@@ -603,3 +603,29 @@
                }
        }
 
+       /**
+        * Update sms version from 0.9.17.513 to 0.9.17.514
+        *
+        */
+       $test[] = '0.9.17.513';
+
+       function sms_upgrade0_9_17_513()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_sms_tblsmsincoming', 
'in_msg', array(
+                       'type' => 'text',
+                       'nullable' => false
+               ));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_sms_tbluserinbox', 'in_msg', 
array(
+                       'type' => 'text',
+                       'nullable' => false
+               ));
+
+               if ($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['sms']['currentver'] = 
'0.9.17.514';
+                       return $GLOBALS['setup_info']['sms']['currentver'];
+               }
+       }
+




reply via email to

[Prev in Thread] Current Thread [Next in Thread]