diff options
| author | Christian Fowler <spider@viovio.com> | 2005-12-28 20:12:46 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2005-12-28 20:12:46 +0000 |
| commit | 2149b17e33d9905d16986ce86757343fabfa8211 (patch) | |
| tree | 4229d0bbf70d551a074a411b3562facfe319564f /admin | |
| parent | fd43e1191a1b9e2a87d59e2772c5fd9ef0cd7bcd (diff) | |
| download | newsletters-2149b17e33d9905d16986ce86757343fabfa8211.tar.gz newsletters-2149b17e33d9905d16986ce86757343fabfa8211.tar.bz2 newsletters-2149b17e33d9905d16986ce86757343fabfa8211.zip | |
unsubscription now working. several schema changes. tiki_mail_subscriptions not maintains indviidual email subscriptions as well as all unsubs.
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 43 |
1 files changed, 22 insertions, 21 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index b898a60..de0196e 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -14,6 +14,26 @@ $tables = array( CONSTRAINTS ', CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' ", +'tiki_newsletters_editions' => " + edition_id I4 AUTO PRIMARY, + nl_id I4 NOTNULL, + is_draft C(1), + content_id I4 NOTNULL + CONSTRAINTS ', CONSTRAINT `tiki_nl_ed_nl_ref` FOREIGN KEY (`nl_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters`( `nl_id` ) + , CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' +", + +'tiki_mail_subscriptions' => " + email C(160), + user_id I4, + nl_content_id I4, + response_content_id I4, + unsubscribe_all C(1), + unsubscribe_date I8 + CONSTRAINTS ', CONSTRAINT `tiki_mail_unsub_con_ref` FOREIGN KEY (`unsub_content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters`( `unsub_content_id` ), + , CONSTRAINT `tiki_mail_unsub_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `user_id` )' +", + 'tiki_mail_errors' => " url_code C(32) PRIMARY, email C(160), @@ -24,31 +44,12 @@ $tables = array( 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, - user_id I4, - unsubscribe_all C(1), - unsubscribed_date I8 - CONSTRAINTS ', CONSTRAINT `tiki_mail_unsub_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters`( `content_id` ), - , CONSTRAINT `tiki_mail_unsub_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `user_id` )' -", - -'tiki_newsletters_editions' => " - edition_id I4 AUTO PRIMARY, - nl_id I4 NOTNULL, - is_draft C(1), - content_id I4 NOTNULL - CONSTRAINTS ', CONSTRAINT `tiki_nl_ed_nl_ref` FOREIGN KEY (`nl_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters`( `nl_id` ) - , CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' -", - -'tiki_editions_mailings' => " +'tiki_mail_mailings' => " content_id I4 NOTNULL, queue_date I8, send_date I8, emails_sent I8 - CONSTRAINTS ', CONSTRAINT `tiki_nl_mail_ed_ref` FOREIGN KEY (`edition_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters_editions`( `edition_id` )' + CONSTRAINTS ', CONSTRAINT `tiki_mail_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content` ( `content_id` )' ", 'tiki_mail_queue' => " |