Also added index on authorised_values.lib.
---
installer/data/mysql/en/mandatory/sysprefs.sql | 1 +
.../1-Obligatoire/unimarc_standard_systemprefs.sql | 1 +
installer/data/mysql/kohastructure.sql | 3 ++-
installer/data/mysql/updatedatabase.pl | 7 +++++++
kohaversion.pl | 2 +-
5 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql
b/installer/data/mysql/en/mandatory/sysprefs.sql
index a0e606e..a978fad 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -244,3 +244,4 @@ INSERT INTO systempreferences
(variable,value,explanation,options,type) VALUES('
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewISBD','1','Allow display
of ISBD view of bibiographic records','','YesNo');
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewLabeledMARC','0','Allow
display of labeled MARC view of bibiographic records','','YesNo');
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewMARC','1','Allow display
of MARC view of bibiographic records','','YesNo');
+INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('FilterBeforeOverdueReport','0','Do
not run overdue report until filter selected','','YesNo');
diff --git
a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
index 0d08e1b..424b716 100644
--- a/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/unimarc_standard_systemprefs.sql
@@ -246,3 +246,4 @@ INSERT INTO systempreferences
(variable,value,explanation,options,type) VALUES('
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewISBD','1','Autoriser
l''affichage de la vue ISBD des notices bibliographiques','','YesNo');
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewLabeledMARC','0','Autoriser
l''affichage MARC labellis des notices bibliographiques','','YesNo');
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('viewMARC','1','Autoriser
l''affichage de la vue MARC des notices bibliographiques','','YesNo');
+INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('FilterBeforeOverdueReport','0','Ne
pas lancer le rapport sur les retards tant qu''il n''y a pas de
filtre','','YesNo');
diff --git a/installer/data/mysql/kohastructure.sql
b/installer/data/mysql/kohastructure.sql
index af65299..2b2e0c9 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -341,7 +341,8 @@ CREATE TABLE `authorised_values` (
`lib` varchar(80) default NULL,
`imageurl` varchar(200) default NULL,
PRIMARY KEY (`id`),
- KEY `name` (`category`)
+ KEY `name` (`category`),
+ KEY `lib` (`lib`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
diff --git a/installer/data/mysql/updatedatabase.pl
b/installer/data/mysql/updatedatabase.pl
index a99bb6c..58497c8 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2459,6 +2459,13 @@ if (C4::Context->preference("Version") <
TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
+$DBversion = '3.01.00.037';
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+ $dbh->do('ALTER TABLE authorised_values ADD KEY `lib` (`lib`)');
+ $dbh->do("INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('FilterBeforeOverdueReport','0','Do
not run overdue report until filter selected','','YesNo')");
+ SetVersion ($DBversion);
+ print "Upgrade to $DBversion done (added FilterBeforeOverdueReport syspref
and new index on authorised_values)\n";
+}
=item DropAllForeignKeys($table)
diff --git a/kohaversion.pl b/kohaversion.pl
index 6918efe..87fd2cc 100644
--- a/kohaversion.pl
+++ b/kohaversion.pl
@@ -10,7 +10,7 @@
use strict;
sub kohaversion {
- our $VERSION = '3.01.00.036';
+ our $VERSION = '3.01.00.037';
# version needs to be set this way
# so that it can be picked up by Makefile.PL
# during install
--
1.5.6.5
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
