From f1f1b1516b49857bf92fc5558044a9f52e2d3142 Mon Sep 17 00:00:00 2001
From: Mark Tompsett <mtompset@hotmail.com>
Date: Thu, 6 Mar 2014 17:18:49 -0500
Subject: [PATCH] Bug 8000 - Add a sentto_address column to message_queue

The problem with message_queue is the inability to tell if the
to_address was overriden at the time it was sent/attempted.
This column will reflect what was attempted.

MessageQueue.pm was generated by running the script
installer/data/mysql/updatedatabase.pl and then git add'ing
the resulting Koha/Schema/Result/MessageQueue.pm file. This was
generated by running ./misc/devel/update_dbix_class_files.pl
using appropriate -db_name=... -db_user=... -db_passwd=...
parameters. This file is necessary for 3.16 and higher.
---
 Koha/Schema/Result/MessageQueue.pm     | 7 +++++++
 installer/data/mysql/kohastructure.sql | 1 +
 installer/data/mysql/updatedatabase.pl | 1 -
 3 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/Koha/Schema/Result/MessageQueue.pm b/Koha/Schema/Result/MessageQueue.pm
index 346b463..0c360e0 100644
--- a/Koha/Schema/Result/MessageQueue.pm
+++ b/Koha/Schema/Result/MessageQueue.pm
@@ -82,6 +82,11 @@ __PACKAGE__->table("message_queue");
   data_type: 'mediumtext'
   is_nullable: 1
 
+=head2 sentto_address
+
+  data_type: 'mediumtext'
+  is_nullable: 1
+
 =head2 from_address
 
   data_type: 'mediumtext'
@@ -125,6 +130,8 @@ __PACKAGE__->add_columns(
   },
   "to_address",
   { data_type => "mediumtext", is_nullable => 1 },
+  "sentto_address",
+  { data_type => "mediumtext", is_nullable => 1 },
   "from_address",
   { data_type => "mediumtext", is_nullable => 1 },
   "content_type",
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 431a541..0257aee 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -2565,6 +2565,7 @@ CREATE TABLE `message_queue` (
   `status` enum('sent','pending','failed','deleted') NOT NULL default 'pending',
   `time_queued` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   `to_address` mediumtext,
+  `sentto_address` mediumtext,
   `from_address` mediumtext,
   `content_type` text,
   PRIMARY KEY `message_id` (`message_id`),
diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index db20db7..6ed1223 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -11686,7 +11686,6 @@ foreach my $file ( sort readdir $dirh ) {
     }
 }
 
-
 =head1 FUNCTIONS
 
 =head2 TableExists($table)
-- 
1.9.1