From 2aca9f26e32e48d5f7a64c96616a96ed630e388d Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Sat, 1 May 2010 00:19:48 +0200 Subject: [PATCH] Transport_type print missing This type is quite important for all the print notices Signed-off-by: Galen Charlton --- .../mysql/en/mandatory/message_transport_types.sql | 3 ++- .../fr-FR/1-Obligatoire/message_transport_types.sql | 1 + installer/data/mysql/updatedatabase.pl | 10 ++++++++++ kohaversion.pl | 2 +- 4 files changed, 14 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/en/mandatory/message_transport_types.sql b/installer/data/mysql/en/mandatory/message_transport_types.sql index 3b85a6017d..bbcb64cf6f 100644 --- a/installer/data/mysql/en/mandatory/message_transport_types.sql +++ b/installer/data/mysql/en/mandatory/message_transport_types.sql @@ -3,4 +3,5 @@ INSERT INTO message_transport_types values ('email'), ('print'), -('sms'); +('sms'), +('feed'); diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql b/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql index 0c61bb8dea..a355b487a2 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql @@ -1,6 +1,7 @@ INSERT INTO message_transport_types (message_transport_type) values +('print'), ('email'), ('sms'), ('feed'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index d5ccfe2ccf..9aa760bfc7 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3571,6 +3571,16 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.01.00.131"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(q{ +INSERT IGNORE INTO message_transport_types (message_transport_type) VALUES ('print'),('feed'); + }); + print "Upgrade to $DBversion done (Adding index to language_descriptions table)\n"; + SetVersion ($DBversion); +} + + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index 509c6e225d..381bc45d35 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.130'; + our $VERSION = '3.01.00.131'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5