From 4918af1a903bac5765cbf8709cfe2ce7f41ff082 Mon Sep 17 00:00:00 2001 From: Christian Fowler Date: Thu, 29 Dec 2005 17:23:05 +0000 Subject: add newsletter email read tracking --- admin/schema_inc.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'admin') diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 3f16b01..cf09edd 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -60,7 +60,9 @@ $tables = array( url_code C(32), queue_date I8 NOTNULL, begin_date I8, - sent_date I8 + sent_date I8, + last_read_date I8, + reads I2 NOTNULL DEFAULT '0' CONSTRAINTS ', CONSTRAINT `tiki_nl_mailq_ed_ref` FOREIGN KEY (`edition_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters_editions`( `edition_id` ), , CONSTRAINT `tiki_nl_mailq_user_ref` FOREIGN KEY (`users_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `users_id` )' " -- cgit v1.3