diff options
| author | Lester Caine <lester@lsces.co.uk> | 2009-11-11 22:47:03 +0000 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2009-11-11 22:47:03 +0000 |
| commit | 2fd6fc45715051e2b612c037bdb8d66c41052820 (patch) | |
| tree | df5fabd024746c980bf08aa68a1e53bef6f2ac57 /admin | |
| parent | 1c59f79506e026cc49773b000ee813389965ca92 (diff) | |
| download | newsletters-2fd6fc45715051e2b612c037bdb8d66c41052820.tar.gz newsletters-2fd6fc45715051e2b612c037bdb8d66c41052820.tar.bz2 newsletters-2fd6fc45715051e2b612c037bdb8d66c41052820.zip | |
Replace reserved word 'reads' by 'hits' in line with other contentpre_deprecate_bit_setup_incR270PRE_BIT_SETUP_CHANGE
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 2 | ||||
| -rw-r--r-- | admin/upgrades/1.0.2.php | 26 |
2 files changed, 27 insertions, 1 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index a91987d..aadc5ce 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -68,7 +68,7 @@ $tables = array( sent_date I8, last_read_date I8, last_read_ip C(39), - `reads` I2 NOTNULL DEFAULT '0', + hits I2 NOTNULL DEFAULT '0', mail_error X CONSTRAINT ', CONSTRAINT `mailq_content_ref` FOREIGN KEY (`nl_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ) , CONSTRAINT `mailq_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `user_id` )' diff --git a/admin/upgrades/1.0.2.php b/admin/upgrades/1.0.2.php new file mode 100644 index 0000000..9b564e8 --- /dev/null +++ b/admin/upgrades/1.0.2.php @@ -0,0 +1,26 @@ +<?php +/** + * @version $Header: /cvsroot/bitweaver/_bit_newsletters/admin/upgrades/1.0.2.php,v 1.1 2009/11/11 22:47:03 lsces Exp $ + */ +global $gBitInstaller; + +$infoHash = array( + 'package' => NEWSLETTERS_PKG_NAME, + 'version' => str_replace( '.php', '', basename( __FILE__ )), + 'description' => "Replace reserved name reads with hits", + 'post_upgrade' => NULL, +); + +// Increase the size of the IP column to cope with IPv6 +$gBitInstaller->registerPackageUpgrade( $infoHash, array( + +array( 'DATADICT' => array( + array( 'RENAMECOLUMN' => array( + 'mail_queue' => array( + '`reads`' => '`hits` I2 NOTNULL DEFAULT 0' + ), + )), +)), + +)); +?> |