1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
<?php
/**
* @version $Header$
*/
global $gBitInstaller;
$infoHash = array(
'package' => USERS_PKG_NAME,
'version' => str_replace( '.php', '', basename( __FILE__ )),
'description' => "Minor fix to ip columns to support IPv6",
'post_upgrade' => NULL,
);
// Increase the size of the IP column to cope with IPv6
$gBitInstaller->registerPackageUpgrade( $infoHash, array(
array( 'QUERY' =>
array(
'PGSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."users_cnxn` ALTER `ip` TYPE VARCHAR(39)" ,),
'OCI' => array( "ALTER TABLE `".BIT_DB_PREFIX."users_cnxn` MODIFY (`ip` TYPE VARCHAR2(39))" ,),
'MYSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."users_cnxn` MODIFY `ip` VARCHAR(39)" ,),
),
),
));
?>
|
