[21214] preparing the 016 release, modify the phpgw_access_log table so we use a 100 chars precision for ipv6 stuff , will bump the version when all tests have been done

Revision: 21214
          http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=21214
Author:   Caeies
Date:     2010-05-05 14:05:10 +0000 (Wed, 05 May 2010)
Log Message:
-----------
preparing the 016 release, modify the phpgw_access_log table so we use a 100 chars precision for ipv6 stuff, will bump the version when all tests have been done

Modified Paths:
--------------
    modules/phpgwapi/branches/branch_0_9_16/doc/CHANGELOG
    modules/phpgwapi/branches/branch_0_9_16/setup/tables_current.inc.php
    modules/phpgwapi/branches/branch_0_9_16/setup/tables_update.inc.php

Modified: modules/phpgwapi/branches/branch_0_9_16/doc/CHANGELOG
===================================================================
--- modules/phpgwapi/branches/branch_0_9_16/doc/CHANGELOG	2010-05-05 10:49:53 UTC (rev 21213)
+++ modules/phpgwapi/branches/branch_0_9_16/doc/CHANGELOG	2010-05-05 14:05:10 UTC (rev 21214)
@@ -2,6 +2,7 @@
 	phpgwapi :
 		- fix the session not listed in case of using php4 session (which is recommanded). Fixing #23386
 		- fix the Port for postgresql in case of not using the default one.
+		- fix the ipv6 logging behing a problem.
 
 	etemplate :
 		- PHP5 bug fix (avoid php crashing without notices)

Modified: modules/phpgwapi/branches/branch_0_9_16/setup/tables_current.inc.php
===================================================================
--- modules/phpgwapi/branches/branch_0_9_16/setup/tables_current.inc.php	2010-05-05 10:49:53 UTC (rev 21213)
+++ modules/phpgwapi/branches/branch_0_9_16/setup/tables_current.inc.php	2010-05-05 14:05:10 UTC (rev 21214)
@@ -117,7 +117,7 @@
 			'fd' => array(
 				'sessionid' => array('type' => 'char','precision' => '32','nullable' => False),
 				'loginid' => array('type' => 'varchar','precision' => '30','nullable' => False),
-				'ip' => array('type' => 'varchar','precision' => '30','nullable' => False),
+				'ip' => array('type' => 'varchar','precision' => '100','nullable' => False),
 				'li' => array('type' => 'int','precision' => '4','nullable' => False),
 				'lo' => array('type' => 'int','precision' => '4','nullable' => True,'default' => '0'),
 				'account_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')

Modified: modules/phpgwapi/branches/branch_0_9_16/setup/tables_update.inc.php
===================================================================
--- modules/phpgwapi/branches/branch_0_9_16/setup/tables_update.inc.php	2010-05-05 10:49:53 UTC (rev 21213)
+++ modules/phpgwapi/branches/branch_0_9_16/setup/tables_update.inc.php	2010-05-05 14:05:10 UTC (rev 21214)
@@ -1850,3 +1850,12 @@
 	{
 		return $GLOBALS['phpgw_info']['phpgwapi']['currentver'] = '0.9.16.015';
 	}
+
+	$test[] = '0.9.16.015';
+	function phpgwapi_upgrade0_9_16_015()
+	{
+		//Fix the ipv6 issue
+		$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_access_log','ip',array('type' => 'char', 'precision' => 100));
+
+		return $GLOBALS['phpgw_info']['phpgwapi']['currentver'] = '0.9.16.016';
+	}