From 4bf28d9d32df9ad5e040b214d15d4af57eeed847 Mon Sep 17 00:00:00 2001
From: Christian Fowler <spider@viovio.com>
Date: Wed, 21 Dec 2005 09:02:22 +0000
Subject: add smtp error logging, schema changes

---
 admin/schema_inc.php | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'admin')

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
-- 
cgit v1.3