Attachment 56687 Details for Bug 5260 – Bug 5260: Insert the new letter for existing installs

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

Bug-5260-Insert-the-new-letter-for-existing-instal.patch (text/plain), 1.32 KB, created by Jonathan Druart on 2016-10-20 08:09:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-10-20 08:09:14 UTC

Size: 1.32 KB

patch

obsolete

>From 33312c535a9aedd50ba8cff68b4eb149cebc588b 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] Bug 5260: Insert the new letter for existing installs
>
>---
> 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.8.1

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