diff options
| author | Christian Fowler <spider@viovio.com> | 2005-12-21 09:02:22 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2005-12-21 09:02:22 +0000 |
| commit | 4bf28d9d32df9ad5e040b214d15d4af57eeed847 (patch) | |
| tree | 13e55c2bd28cfa18bd5d62274517dd7f0e4120b5 /admin | |
| parent | 23026641de4ecfaa978485b1a6d808bd12f0e791 (diff) | |
| download | newsletters-4bf28d9d32df9ad5e040b214d15d4af57eeed847.tar.gz newsletters-4bf28d9d32df9ad5e040b214d15d4af57eeed847.tar.bz2 newsletters-4bf28d9d32df9ad5e040b214d15d4af57eeed847.zip | |
add smtp error logging, schema changes
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index faafe42..99f20ab 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -14,6 +14,16 @@ $tables = array( CONSTRAINTS ', CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' ", +'tiki_mail_errors' => " + url_code C(32) PRIMARY, + email C(160), + user_id I4, + content_id I4, + error_date I8, + error_message X + CONSTRAINTS ', CONSTRAINT `tiki_mail_err_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `user_id` )' +" + 'tiki_mail_unsubscriptions' => " content_id I4 PRIMARY, email C(160) PRIMARY, @@ -45,6 +55,7 @@ $tables = array( content_id I4 PRIMARY, email C(160) PRIMARY, user_id I4, + url_code C(32), queue_date I8 NOTNULL, begin_date I8, sent_date I8 |