[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [16282] API: make room for email as username
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [16282] API: make room for email as username |
Date: |
Wed, 8 Feb 2017 13:17:13 -0500 (EST) |
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'];
+ }
+ }
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [16282] API: make room for email as username,
sigurdne <=