diff options
| author | Daniel Sutcliffe <dansut@users.sourceforge.net> | 2009-03-31 16:05:43 +0000 |
|---|---|---|
| committer | Daniel Sutcliffe <dansut@users.sourceforge.net> | 2009-03-31 16:05:43 +0000 |
| commit | 9fbad0031823908c036d77370d5c0e0e62fbb454 (patch) | |
| tree | 28108e884808b8bfbf85df8819ae65e76f239b80 /admin | |
| parent | 88eff73c1197f4ca84efb32f960cfe4459be5ca0 (diff) | |
| download | users-9fbad0031823908c036d77370d5c0e0e62fbb454.tar.gz users-9fbad0031823908c036d77370d5c0e0e62fbb454.tar.bz2 users-9fbad0031823908c036d77370d5c0e0e62fbb454.zip | |
Fix MySQL upgrades for ip/IPv6 column upgrades
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/upgrades/2.1.1.php | 10 |
1 files changed, 3 insertions, 7 deletions
diff --git a/admin/upgrades/2.1.1.php b/admin/upgrades/2.1.1.php index f61a6b8..742af07 100644 --- a/admin/upgrades/2.1.1.php +++ b/admin/upgrades/2.1.1.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_users/admin/upgrades/2.1.1.php,v 1.2 2009/03/25 08:28:11 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_users/admin/upgrades/2.1.1.php,v 1.3 2009/03/31 16:05:43 dansut Exp $ */ global $gBitInstaller; @@ -11,18 +11,14 @@ $infoHash = array( 'post_upgrade' => NULL, ); -// all we are doing is change the column type of user_id for liberty_content_history. -// postgresql < 8.2 doesn't allow easy column type changing -// and therefore we need to undergo this annoying dance. +// Increase the size of the IP column to cope with IPv6 $gBitInstaller->registerPackageUpgrade( $infoHash, array( -// copy data into new column array( 'QUERY' => - // postgres > 8.2 needs to have the type cast 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` TYPE VARCHAR(39)" ,), + 'MYSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."users_cnxn` MODIFY `ip` VARCHAR(39)" ,), ), ), |