From 0f9cb38f1d8dc690e20e0a73b2566be8abece9c8 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 12 Jan 2018 11:31:42 +0100 Subject: [PATCH] Bug 18915: (QA follow-up) Add note for installs after 17.05 Since the 17.05 upgrade adds the note and the sql file did not yet include the note, we should add it when it is not there (for example new 17.11s). Signed-off-by: Marcel de Rooy Tested by running the dbrev while there is a letter and while not. Signed-off-by: Jonathan Druart --- .../atomicupdate/bug_18915_-_modifying_patron_note_notice.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql b/installer/data/mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql index 80035b22d1..8fd6b6e974 100644 --- a/installer/data/mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql +++ b/installer/data/mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql @@ -1 +1,4 @@ +-- For installations having the note already UPDATE letter SET code = 'CHECKOUT_NOTE', name = 'Checkout note on item set by patron', title = 'Checkout note', content = REPLACE(content, "<>", "<>") WHERE code = 'PATRON_NOTE'; +-- For installations coming from 17.11 +INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES ('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email'); -- 2.39.2