[Fmsystem-commits] [16282] API: make room for email as username

[sigurdne]

Revision: 16282
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=16282
Author:   sigurdne
Date:     2017-02-08 13:17:12 -0500 (Wed, 08 Feb 2017)
Log Message:
-----------
API: make room for email as username

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

Modified: trunk/phpgwapi/setup/setup.inc.php
===================================================================
--- trunk/phpgwapi/setup/setup.inc.php  2017-02-08 18:16:10 UTC (rev 16281)
+++ trunk/phpgwapi/setup/setup.inc.php  2017-02-08 18:17:12 UTC (rev 16282)
@@ -12,7 +12,7 @@
        // Basic information about this app
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
-       $setup_info['phpgwapi']['version']   = '0.9.17.554';
+       $setup_info['phpgwapi']['version']   = '0.9.17.555';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '2.0';
        $setup_info['phpgwapi']['enable']    = 3;

Modified: trunk/phpgwapi/setup/tables_current.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_current.inc.php 2017-02-08 18:16:10 UTC (rev 
16281)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2017-02-08 18:17:12 UTC (rev 
16282)
@@ -53,7 +53,7 @@
                'phpgw_accounts' => array(
                        'fd' => array(
                                'account_id' => array('type' => 
'auto','nullable' => False),
-                               'account_lid' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
+                               'account_lid' => array('type' => 
'varchar','precision' => 100,'nullable' => False),
                                'account_pwd' => array('type' => 
'varchar','precision' => 115,'nullable' => False),
                                'account_firstname' => array('type' => 
'varchar','precision' => 50,'nullable' => False),
                                'account_lastname' => array('type' => 
'varchar','precision' => 50,'nullable' => False),
@@ -251,7 +251,7 @@
                                'log_id' => array('type' => 'auto','precision' 
=> 4,'nullable' => False),
                                'log_date' => array('type' => 
'timestamp','nullable' => False),
                                'log_account_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
-                               'log_account_lid' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
+                               'log_account_lid' => array('type' => 
'varchar','precision' => 100,'nullable' => False),
                                'log_app' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
                                'log_severity' => array('type' => 
'char','precision' => 2,'nullable' => False),
                                'log_file' => array('type' => 
'varchar','precision' => 255,'nullable' => False,'default' => ''),
@@ -677,7 +677,7 @@
                                'auth_type' => array('type' => 
'varchar','precision' => 25,'nullable' => False),
                                'status' => array('type' => 'char','precision' 
=> 1,'nullable' => False,'default' => 'A'),
                                'location' => array('type' => 
'varchar','precision' => 200,'nullable' => False),
-                               'account_lid' => array('type' => 
'varchar','precision' => 25,'nullable' => False)
+                               'account_lid' => array('type' => 
'varchar','precision' => 100,'nullable' => False)
                        ),
                        'pk' => array('ext_user','location','auth_type'),
                        'fk' => array(),

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2017-02-08 18:16:10 UTC (rev 
16281)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2017-02-08 18:17:12 UTC (rev 
16282)
@@ -3487,3 +3487,36 @@
                        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
                }
        }
+
+       $test[] = '0.9.17.554';
+       /**
+       * Make room for email as account_lid
+       * @return string the new version number
+       */
+       function phpgwapi_upgrade0_9_17_554()
+       {
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+
+               $GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_mapping', 
'account_lid', array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => false
+               ));
+
+               $GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_accounts', 
'account_lid', array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => false
+               ));
+               $GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_log', 
'log_account_lid', array(
+                       'type' => 'varchar',
+                       'precision' => 100,
+                       'nullable' => false
+               ));
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.555';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }