diff options
| author | Christian Fowler <spider@viovio.com> | 2005-12-11 22:53:05 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2005-12-11 22:53:05 +0000 |
| commit | 8bbaa8db252a57322d4ad36f74637d7df198deee (patch) | |
| tree | 09501e784259ed88f7cafab421d514342f20e881 /admin | |
| parent | 63230d60adeed22fdf349ba4a838029c034551b0 (diff) | |
| download | newsletters-8bbaa8db252a57322d4ad36f74637d7df198deee.tar.gz newsletters-8bbaa8db252a57322d4ad36f74637d7df198deee.tar.bz2 newsletters-8bbaa8db252a57322d4ad36f74637d7df198deee.zip | |
schema changes for powerhouse tiki_mail_queue and tiki_mail_unsubscriptions. content generic in design. send now stuffs the queue and avoids duplicates on multiple sends. only piece left is a mailer class
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 29 |
1 files changed, 15 insertions, 14 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index cbbbffc..7e42ce4 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -14,16 +14,14 @@ $tables = array( CONSTRAINTS ', CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' ", -'tiki_newsletter_subscriptions' => " - nl_id I4 PRIMARY, +'tiki_mail_unsubscriptions' => " + content_id I4 PRIMARY, email C(160) PRIMARY, user_id I4, - code C(32), - valid C(1), - subscribed_date I8, + unsubscribe_all C(1), unsubscribed_date I8 - CONSTRAINTS ', CONSTRAINT `tiki_nl_sub_nl_ref` FOREIGN KEY (`nl_id`) REFERENCES `".BIT_DB_PREFIX."tiki_newsletters`( `nl_id` ), - , CONSTRAINT `tiki_nl_group_ref` FOREIGN KEY (`group_id`) REFERENCES `".BIT_DB_PREFIX."users_groups`( `group_id` )' + 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' => " @@ -35,18 +33,19 @@ $tables = array( , CONSTRAINT `tiki_nl_ed_con_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."tiki_content`( `content_id` )' ", -'tiki_newsletters_mailings' => " - edition_id I4 NOTNULL, +'tiki_editions_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` )' ", -'tiki_newsletters_mailings_queue' => " - edition_id I4 PRIMARY, +'tiki_mail_queue' => " + content_id I4 PRIMARY, email C(160) PRIMARY, - user_id C(1), + user_id I4, + queue_date I8 NOTNULL, sent_date I8 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` )' @@ -75,8 +74,10 @@ $indices = array ( 'tiki_nl_sub_email_idx' => array( 'table' => 'tiki_newsletter_subscriptions', 'cols' => 'email', 'opts' => NULL ), 'tiki_nl_ed_nl_idx' => array( 'table' => 'tiki_newsletters_editions', 'cols' => 'nl_id', 'opts' => NULL ), 'tiki_nl_group_nl_idx' => array( 'table' => 'tiki_newsletter_groups', 'cols' => 'nl_id', 'opts' => NULL ), - 'tiki_nl_mq_email_idx' => array( 'table' => 'tiki_newsletters_mailings_queue', 'cols' => 'email', 'opts' => NULL ), - 'tiki_nl_mq_sent_idx' => array( 'table' => 'tiki_newsletters_mailings_queue', 'cols' => 'sent_date', 'opts' => NULL ), + 'tiki_mq_email_idx' => array( 'table' => 'tiki_mail_queue', 'cols' => 'email', 'opts' => NULL ), + 'tiki_mq_user_idx' => array( 'table' => 'tiki_mail_queue', 'cols' => 'user_id', 'opts' => NULL ), + 'tiki_mq_content_idx' => array( 'table' => 'tiki_mail_queue', 'cols' => 'content_id', 'opts' => NULL ), + 'tiki_mq_sent_idx' => array( 'table' => 'tiki_mail_queue', 'cols' => 'sent_date', 'opts' => NULL ), ); $gBitInstaller->registerSchemaIndexes( LIBERTY_PKG_NAME, $indices ); |