Bug 23590: Create a separate template notice NOTIFY_MANAGER

[srvgit] / installer / data / mysql / atomicupdate / bug_23590.perl

diff --git a/installer/data/mysql/atomicupdate/bug_23590.perl b/installer/data/mysql/atomicupdate/bug_23590.perl
index cc80154..9ca1220 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug_23590.perl
+++ b/installer/data/mysql/atomicupdate/bug_23590.perl
@@ -35,8 +35,13 @@ if( CheckVersion( $DBversion ) ) {
                 WHERE suggestionid = ?
             |, undef, $max_date, $last_modif_by, $suggestion->{suggestionid});
         }
+
     }
 
+    $dbh->do( q|
+        INSERT IGNORE INTO letter(module, code, branchcode, name, is_html, title, content, message_transport_type, lang) VALUES ('suggestions', 'NOTIFY_MANAGER', '', 'Notify manager of a suggestion', 0, "A suggestion has been assigned to you", "Dear [% borrower.firstname %] [% borrower.surname %],\nA suggestion has been assigned to you: [% suggestion.title %].\nThank you,\n[% branch.branchname %]", 'email', 'default');
+    | );
+
     # Always end with this (adjust the bug info)
     SetVersion( $DBversion );
     print "Upgrade to $DBversion done (Bug 23590 - Add lastmodificationby and lastmodificationdate to the suggestions table)\n";