From 51dab3ffb69cd97329fdfd94506fcb2dcfccabe4 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 9 Apr 2021 14:15:09 +0000 Subject: [PATCH] Bug 15986: (follow-up) Add atomic update --- .../mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl diff --git a/installer/data/mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl b/installer/data/mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl new file mode 100644 index 0000000000..3e8ac683a1 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl @@ -0,0 +1,9 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + INSERT IGNORE INTO letter + (module,code,branchcode,name,is_html,title,content,message_transport_type,lang) + VALUES ('reserves','HOLD_REMINDER','','Waiting hold reminder',0,'You have waiting holds.','Dear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nThe follwing holds are waiting at [% branch.branchname %]:\r\n\\r\n[% FOREACH hold IN holds %]\r\n [% hold.biblio.title %] : waiting since [% hold.waitingdate %]\r\n[% END %]','email','default') + }); + NewVersion( $DBversion, 15986, "Add sample HOLD_REMINDER notice"); +} -- 2.11.0