From d6aed5f0d081af8d7229fe6b3fc9ea029f719e51 Mon Sep 17 00:00:00 2001 From: "J. David Bavousett" Date: Mon, 22 Feb 2010 11:02:01 -0500 Subject: [PATCH] Bug 3482: Updated DB version Updated DB version and inserted mandatory SQL for this series of patches. --- installer/data/mysql/updatedatabase.pl | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e6f3f9f658..49483de39a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3520,6 +3520,18 @@ if (C4::Context->preference('Version') < TransformToNum($DBversion)){ SetVersion ($DBversion); } +$DBversion = '3.01.00.125'; +if (C4::Context->preference('Version') < TransformToNum($DBversion)){ + $dbh->do(" + INSERT INTO `systempreferences` ( `variable` , `value` , `options` , `explanation` , `type` ) VALUES ( 'PrintNoticesMaxLines', '0', '', 'If greater than 0, sets the maximum number of lines an overdue notice will print. If the number of items is greater than this number, the notice will end with a warning asking the borrower to check their online account for a full list of overdue items.', 'Integer' ); + "); + $dbh->do(" + INSERT INTO message_transport_types (message_transport_type) values ('print'); + "); + print "Upgrade to $DBversion done (bug 3482: Printable hold and overdue notices)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.2