Attachment 40225 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), 2.96 KB, created by Mark Tompsett on 2015-06-17 11:09:18 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2015-06-17 11:09:18 UTC

Size: 2.96 KB

patch

obsolete

>From 14406e52b779817d9058c8fd750b61bae2a1958b 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 |  1 -
> 3 files changed, 10 insertions(+), 3 deletions(-)
>
>diff --git a/Koha/Schema/Result/MessageQueue.pm b/Koha/Schema/Result/MessageQueue.pm
>index 6612db5..6c98745 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.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YWxM2O2W/h34qqIOIpzOtw
>+# 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 6683125..ffbe658 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,
>   KEY `message_id` (`message_id`),
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index b84e7fa..ee76d7d 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -10612,7 +10612,6 @@ foreach my $file ( sort readdir $dirh ) {
>     }
> }
> 
>-
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>2.1.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