View | Details | Raw Unified | Return to bug 15986
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_15986_add_holdreminder_notice.perl (-1 / +9 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO letter 
5
        (module,code,branchcode,name,is_html,title,content,message_transport_type,lang)
6
        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')
7
    });
8
    NewVersion( $DBversion, 15986, "Add sample HOLD_REMINDER notice");
9
}

Return to bug 15986