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

(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+5 lines)
Lines 133-138 Thank you. Link Here
133
133
134
Your library.'
134
Your library.'
135
);
135
);
136
136
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
137
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
137
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
138
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
138
139
Lines 142-144 Thank you. Link Here
142
143
143
Your library.'
144
Your library.'
144
);
145
);
146
147
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
148
VALUES (
149
'members','MEMEXP','Membership Expiry Notice','Membership Expiry Notice','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour membership expires soon on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian');
(-)a/installer/data/mysql/sysprefs.sql (-2 / +2 lines)
Lines 454-458 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
454
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
454
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
455
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
455
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
456
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
456
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
457
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
457
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
458
;
458
('MembershipExpiryDaysNotice' ,14,'Send a membership expiry notice that a patron is about to expire after',NULL,'Integer');
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 8845-8850 if ( CheckVersion($DBversion) ) { Link Here
8845
   SetVersion ($DBversion);
8845
   SetVersion ($DBversion);
8846
}
8846
}
8847
8847
8848
$DBversion = "3.17.00.XXX";
8849
if ( CheckVersion($DBversion) ) {
8850
    $dbh->do(q{INSERT INTO `letter` (`module`, `code`, `name`, `title`,`content`) VALUES('members','MEMEXP','Membership Expiry','Your Membership Expires','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,.\r\n\r\nYour membership expires soon on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian')});
8851
    $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MembershipExpiryDaysNotice',14,'Send a membership expiry notice that a patron is about to expire after',NULL,'Integer')");
8852
    print "Upgrade to $DBversion done (Bug - 6810 Insert value in letter and syspref table for Membership expiry notifications)\n";
8853
   SetVersion ($DBversion);
8854
}
8855
8848
=head1 FUNCTIONS
8856
=head1 FUNCTIONS
8849
8857
8850
=head2 TableExists($table)
8858
=head2 TableExists($table)
8851
- 

Return to bug 6810