From 3fdcc4cde3c34875e95ff069a8e61aae33e293d2 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Wed, 20 Apr 2022 05:06:12 -1000 Subject: [PATCH] Bug 30237: DBRev 21.12.00.034 Signed-off-by: Fridolin Somers --- Koha.pm | 2 +- .../{atomicupdate/bug_30237.pl => db_revs/211200034.pl} | 7 ++++--- 2 files changed, 5 insertions(+), 4 deletions(-) rename installer/data/mysql/{atomicupdate/bug_30237.pl => db_revs/211200034.pl} (93%) diff --git a/Koha.pm b/Koha.pm index 98e5dcb9f8..8357b3578c 100644 --- a/Koha.pm +++ b/Koha.pm @@ -29,7 +29,7 @@ use vars qw{ $VERSION }; # - #4 : the developer version. The 4th number is the database subversion. # used by developers when the database changes. updatedatabase take care of the changes itself # and is automatically called by Auth.pm when needed. -$VERSION = "21.12.00.033"; +$VERSION = "21.12.00.034"; sub version { return $VERSION; diff --git a/installer/data/mysql/atomicupdate/bug_30237.pl b/installer/data/mysql/db_revs/211200034.pl similarity index 93% rename from installer/data/mysql/atomicupdate/bug_30237.pl rename to installer/data/mysql/db_revs/211200034.pl index d05aed7386..ba4a60a3cf 100755 --- a/installer/data/mysql/atomicupdate/bug_30237.pl +++ b/installer/data/mysql/db_revs/211200034.pl @@ -7,11 +7,12 @@ return { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; # Add WELCOME notice - $dbh->do( q{ - INSERT IGNORE INTO letter (module, code, name, is_html, title, content, message_transport_type) VALUES ('members', 'WELCOME', 'Welcome notice', 1, "[% USE Koha %]Welcome to [% IF Koha.Preference('LibraryName') %][% Koha.Preference('LibraryName') %][% ELSE %]the library[% END %]", "[% USE Koha %]\r\nHello [% borrower.title %] [% borrower.firstname %] [% borrower.surname %].\r\n\r\nThank you for joining [% IF Koha.Preference('LibraryName') %][% Koha.Preference('LibraryName') %][% ELSE %]the library[% END %]\r\n\r\nYou can search for all our materials in our catalog.\r\n\r\nYour library card number is [% borrower.cardnumber %]\r\n\r\nIf you have any problems or questions regarding your account, please contact the library.", 'email');}); + $dbh->do(q{ + INSERT IGNORE INTO letter (module, code, name, is_html, title, content, message_transport_type) VALUES ('members', 'WELCOME', 'Welcome notice', 1, "[% USE Koha %]Welcome to [% IF Koha.Preference('LibraryName') %][% Koha.Preference('LibraryName') %][% ELSE %]the library[% END %]", "[% USE Koha %]\r\nHello [% borrower.title %] [% borrower.firstname %] [% borrower.surname %].\r\n\r\nThank you for joining [% IF Koha.Preference('LibraryName') %][% Koha.Preference('LibraryName') %][% ELSE %]the library[% END %]\r\n\r\nYou can search for all our materials in our catalog.\r\n\r\nYour library card number is [% borrower.cardnumber %]\r\n\r\nIf you have any problems or questions regarding your account, please contact the library.", 'email'); + }); # Update system preference - $dbh->do( q{ + $dbh->do(q{ UPDATE systempreferences SET variable = 'AutoEmailNewUser', explanation = 'Send an email to newly created patrons.' WHERE variable = 'AutoEmailOpacUser' }); }, -- 2.39.2