diff options
| author | Christian Fowler <spider@viovio.com> | 2005-12-29 17:23:05 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2005-12-29 17:23:05 +0000 |
| commit | 4918af1a903bac5765cbf8709cfe2ce7f41ff082 (patch) | |
| tree | bf3e229faa3fb3e6209aac40e15f2804c9a527af /admin | |
| parent | 4ef765eb33d8121228668bb4124a52c40ab5b980 (diff) | |
| download | newsletters-4918af1a903bac5765cbf8709cfe2ce7f41ff082.tar.gz newsletters-4918af1a903bac5765cbf8709cfe2ce7f41ff082.tar.bz2 newsletters-4918af1a903bac5765cbf8709cfe2ce7f41ff082.zip | |
add newsletter email read tracking
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 4 |
1 files changed, 3 insertions, 1 deletions
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` )' " |