Attachment 56706 Details for Bug 5260 – [SIGNED OFF] Bug 5260: Insert the new letter for existing installs

[patch] [SIGNED OFF] Bug 5260: Insert the new letter for existing installs

SIGNED-OFF-Bug-5260-Insert-the-new-letter-for-exis.patch (text/plain), 1.39 KB, created by Katrin Fischer on 2016-10-20 21:27:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2016-10-20 21:27:19 UTC

Size: 1.39 KB

patch

obsolete

>From 34262fa4a8189eb50cdccfe75a1cc88c5d2ba02f Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 20 Oct 2016 08:54:50 +0100
>Subject: [PATCH] [SIGNED OFF] Bug 5260: Insert the new letter for existing
> installs
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql | 3 +++
> 1 file changed, 3 insertions(+)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql b/installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql
>index 5d6aafe..5bc8bb3 100644
>--- a/installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql
>+++ b/installer/data/mysql/atomicupdate/bug_5260_acq_email_orders.sql
>@@ -1 +1,4 @@
> ALTER TABLE `aqcontacts` ADD `orderacquisition` BOOLEAN NOT NULL DEFAULT 0 AFTER `notes`;
>+
>+INSERT IGNORE INTO `letter` (module, code, name, title, content, message_transport_type) VALUES
>+('orderacquisition','ACQORDER','Acquisition order','Order','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email');
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 5260: 2653 | 4067 | 4068 | 4781 | 22171 | 56449 | 56450 | 56483 | 56484 | 56549 | 56550 | 56551 | 56560 | 56561 | 56562 | 56568 | 56679 | 56680 | 56686 | 56687 | 56688 | 56689 | 56705 | 56706 | 56707 | 56708 | 56709 | 56786 | 56787 | 56788 | 56789 | 56790 | 56791 | 56792 | 56793 | 56794 | 56795