Attachment 25926 Details for Bug 8000 – Bug 8000 - Add a sentto_address column to message_queue

[patch] Bug 8000 - Add a sentto_address column to message_queue

Bug-8000---Add-a-senttoaddress-column-to-messagequ.patch (text/plain), 3.65 KB, created by Mark Tompsett on 2014-03-07 03:56:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2014-03-07 03:56:43 UTC

Size: 3.65 KB

patch

obsolete

>From 2f64db76b98bc6f04fc6e0e9b29b06d35bda0dea 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     |   11 +++++++++--
> installer/data/mysql/kohastructure.sql |    1 +
> installer/data/mysql/updatedatabase.pl |    3 ++-
> 3 files changed, 12 insertions(+), 3 deletions(-)
>
>diff --git a/Koha/Schema/Result/MessageQueue.pm b/Koha/Schema/Result/MessageQueue.pm
>index 417cd78..cccf6fe 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",
>@@ -169,8 +176,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+gmGYPCtwCYKHAzfd9xByQ
>+# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-03-06 22:50:19
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fL7N2f/cS1ff4rsqQGHX9w
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index dddd2c0..38ff9f6 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2524,6 +2524,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,
>   KEY `message_id` (`message_id`),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index a461b1e..9b61798 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -8015,7 +8015,8 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
> $DBversion = "3.15.00.XXX";
> if ( CheckVersion($DBversion) ) {
>     $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('SendAllEmailsTo','',NULL,'This email will replace the To address in every message sent by the system.  This is meant to help testing and validation only.','Textarea')");
>-    print "Upgrade to $DBversion done (Bug 8000 - system preferences to override the destination of every email sent by the system.)\n";
>+    $dbh->do( qw{ ALTER TABLE message_queue ADD sentto_address mediumtext AFTER to_address } );
>+    print "Upgrade to $DBversion done (Bug 8000 - add method to override the destination of every email sent by the system.)\n";
>     SetVersion ($DBversion);
> }
> 
>-- 
>1.7.10.4

Actions: View | Diff | Splinter Review

Attachments on bug 8000: 21976 | 22315 | 24784 | 25917 | 25919 | 25920 | 25923 | 25924 | 25925 | 25926 | 25927 | 25928 | 25939 | 25950 | 25951 | 26446 | 37463 | 37464 | 37465 | 37466 | 37467 | 37468 | 37469 | 37472 | 37473 | 37474 | 37475 | 37476 | 37477 | 37478 | 37481 | 37482 | 37483 | 37484 | 37485 | 37486 | 37487 | 39985 | 39986 | 39987 | 39988 | 39989 | 39990 | 39991 | 39992 | 40215 | 40216 | 40217 | 40218 | 40219 | 40220 | 40221 | 40222 | 40223 | 40224 | 40225 | 40226 | 40227 | 40228 | 40229 | 40230 | 46354 | 46355 | 46356 | 46357 | 46358 | 46359 | 46360 | 46361 | 46362 | 49991 | 49992 | 49993 | 49998 | 49999 | 50000 | 55940 | 58434 | 62863 | 67155 | 70086 | 70087 | 70484 | 74110 | 74111 | 74848 | 80370 | 81487 | 81488 | 81589 | 81590 | 81591 | 84801 | 84802 | 84803 | 84804 | 84805 | 86861 | 86862 | 86863 | 86864 | 86865 | 88874 | 88875 | 88876 | 88877 | 88878 | 88879