@@ -, +, @@ --- .../mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql | 3 +++ 1 file changed, 3 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_18915_-_modifying_patron_note_notice.sql +++ a/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'); --