From 991fa56daeebd0a1d6417750f6675b780882ac5e Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Wed, 26 Nov 2014 09:26:29 -0500 Subject: [PATCH] Bug 6810 [Sample notices follow-up] Send membership expiry reminder notices Content-Type: text/plain; charset="utf-8" This patch adds the new sample notice (in English) to the non-English web installers so that it is available to users of non-English templates. This patch also corrects the SQL of the sample notice updates to reflect changes in the structure of the notices table. To test, apply the patch and test installation of Koha with a blank database. The installation process should correctly add sample notices, including the new MEMEXP notice. Test again using a different set of translations to confirm that non-English sample notices are working as well. --- .../data/mysql/de-DE/mandatory/sample_notices.sql | 3 +++ .../data/mysql/en/mandatory/sample_notices.sql | 4 ++-- .../data/mysql/es-ES/mandatory/sample_notices.sql | 3 +++ .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 3 +++ installer/data/mysql/it-IT/necessari/notices.sql | 3 +++ .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 3 +++ .../data/mysql/pl-PL/mandatory/sample_notices.sql | 3 +++ .../data/mysql/ru-RU/mandatory/sample_notices.sql | 3 +++ .../data/mysql/uk-UA/mandatory/sample_notices.sql | 3 +++ 9 files changed, 26 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql index 01ae5d4..37c46a1 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -131,3 +131,6 @@ Wir möchten Sie darüber informieren, dass der Benutzer <> Vielen Dank, Ihr Biblioheksteam' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 15f9b25..04d6027 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -144,6 +144,6 @@ Thank you. Your library.' ); -INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) VALUES ( -'members','MEMEXP','Account expiration','Account expiration','Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql index b105f58..df40115 100644 --- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql +++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql @@ -143,3 +143,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql index d66a2d4..a29aeb7 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -145,3 +145,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql index 626f208..dcf7575 100644 --- a/installer/data/mysql/it-IT/necessari/notices.sql +++ b/installer/data/mysql/it-IT/necessari/notices.sql @@ -142,3 +142,6 @@ Grazie di tutto Lo staff della biblioteca.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql index f1e8fb0..bd98b6d 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql @@ -163,3 +163,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql index 50e0cd5..05da073 100644 --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -145,3 +145,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql index a8d3046..6159148 100644 --- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql +++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql @@ -145,3 +145,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql index db8976e..c6291d0 100644 --- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql +++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql @@ -144,3 +144,6 @@ Thank you. Your library.' ); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( +'members','MEMEXP','','Account expiration','Account expiration', '0', 'Dear <> <> <>,.\r\n\r\nYour library card will expire soon, on:\r\n\r\n<>\r\n\r\nThank you,\r\n\r\nLibrarian'); \ No newline at end of file -- 1.7.9.5