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

(-)a/installer/data/mysql/atomicupdate/bug_XXXXX.sql (-3 / +2 lines)
Lines 1-7 Link Here
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
3
3
4
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
4
INSERT INTO letter (module, code, name, title, content, message_transport_type, is_tt) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
5
"Dear [% borrower.firstname %] [% borrower.surname %],
5
"Dear [% borrower.firstname %] [% borrower.surname %],
6
[% IF checkout.auto_renew_error %]
6
[% IF checkout.auto_renew_error %]
7
The following item [% biblio.title %] has not been correctly renewed
7
The following item [% biblio.title %] has not been correctly renewed
Lines 20-23 You have too much unpaid fines. Link Here
20
[% END %]
20
[% END %]
21
[% ELSE %]
21
[% ELSE %]
22
The following item [% biblio.title %] as correctly been renewed.
22
The following item [% biblio.title %] as correctly been renewed.
23
[% END %]", 'email');
23
[% END %]", 'email', 1);
24
- 

Return to bug 15705