diff options
| author | Daniel Sutcliffe <dansut@users.sourceforge.net> | 2009-04-01 15:10:37 +0000 |
|---|---|---|
| committer | Daniel Sutcliffe <dansut@users.sourceforge.net> | 2009-04-01 15:10:37 +0000 |
| commit | 74698147aae30dad4cb4f8fd531a5b6dbbd33bcc (patch) | |
| tree | 9661a803cba61afdc65f89b3d19758a102d15897 | |
| parent | bfb76b94fcc900637a03230885e947da6cf7132e (diff) | |
| download | newsletters-74698147aae30dad4cb4f8fd531a5b6dbbd33bcc.tar.gz newsletters-74698147aae30dad4cb4f8fd531a5b6dbbd33bcc.tar.bz2 newsletters-74698147aae30dad4cb4f8fd531a5b6dbbd33bcc.zip | |
Fix MySQL upgrades for ip/IPv6 column upgrades
| -rw-r--r-- | admin/upgrades/1.0.1.php | 10 |
1 files changed, 3 insertions, 7 deletions
diff --git a/admin/upgrades/1.0.1.php b/admin/upgrades/1.0.1.php index e4c188f..72200c6 100644 --- a/admin/upgrades/1.0.1.php +++ b/admin/upgrades/1.0.1.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_newsletters/admin/upgrades/1.0.1.php,v 1.2 2009/03/25 08:28:11 squareing Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_newsletters/admin/upgrades/1.0.1.php,v 1.3 2009/04/01 15:10:37 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."mail_queue` ALTER `last_read_ip` TYPE VARCHAR(39)" ,), 'OCI' => array( "ALTER TABLE `".BIT_DB_PREFIX."mail_queue` MODIFY (`last_read_ip` TYPE VARCHAR2(39))" ,), - 'MYSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."mail_queue` MODIFY `last_read_ip` TYPE VARCHAR(39)" ,), + 'MYSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."mail_queue` MODIFY `last_read_ip` VARCHAR(39)" ,), ), ), |