diff options
| author | Christian Fowler <spider@viovio.com> | 2007-05-04 06:37:56 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-05-04 06:37:56 +0000 |
| commit | aa9078988ce3e39c70fa01b4392ad5d46a0bfd40 (patch) | |
| tree | ab49659c93f93e21f4286c98b0a569fe907618f0 /admin | |
| parent | 1b98bd102b08d953afdb00433a4cbd8d314742f8 (diff) | |
| download | newsletters-aa9078988ce3e39c70fa01b4392ad5d46a0bfd40.tar.gz newsletters-aa9078988ce3e39c70fa01b4392ad5d46a0bfd40.tar.bz2 newsletters-aa9078988ce3e39c70fa01b4392ad5d46a0bfd40.zip | |
SCHEMA CHANGE: add last_read_ip to mail_queue
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 1 | ||||
| -rw-r--r-- | admin/upgrade_inc.php | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index a33560e..c3c4de9 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -67,6 +67,7 @@ $tables = array( begin_date I8, sent_date I8, last_read_date I8, + last_read_ip C(16), `reads` I2 NOTNULL DEFAULT '0' 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/upgrade_inc.php b/admin/upgrade_inc.php index 6ccfc63..5581855 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -82,6 +82,11 @@ array( 'DATADICT' => array( CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' " )), + array( 'ALTER' => array( + 'mail_queue' => array( + 'last_read_ip' => array( '`last_read_ip`', 'VARCHAR(40)' ), + ), + )), )), ) ), |