From 33312c535a9aedd50ba8cff68b4eb149cebc588b Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nPlease order for the library:\r\n\r\nOrdernumber <> (<>) (quantity: <>) ($<> each).\r\n\r\nThank you,\n\n<>', 'email'); -- 2.8.1