From: Paul Poulain <[email protected]>
(replace previous one, that removed only OPACsubscriptionDisplay)
removing OPACSubscriptionDisplay and sortbynonfiling.
---
admin/systempreferences.pl | 2 --
installer/data/mysql/en/mandatory/sysprefs.sql | 2 --
.../1-Obligatoire/unimarc_standard_systemprefs.sql | 1 -
.../ru-RU/mandatory/system_preferences_optimal.sql | 2 --
.../uk-UA/mandatory/system_preferences_optimal.sql | 2 --
installer/data/mysql/updatedatabase30.pl | 8 ++++++++
kohaversion.pl | 2 +-
7 files changed, 9 insertions(+), 10 deletions(-)
diff --git a/admin/systempreferences.pl b/admin/systempreferences.pl
index ef53715..58eb4b1 100755
--- a/admin/systempreferences.pl
+++ b/admin/systempreferences.pl
@@ -205,7 +205,6 @@ my %tabsysprefs;
$tabsysprefs{QueryStemming}="Searching";
$tabsysprefs{QueryWeightFields}="Searching";
$tabsysprefs{expandedSearchOption}="Searching";
- $tabsysprefs{sortbynonfiling}="Searching";
$tabsysprefs{QueryAutoTruncate}="Searching";
$tabsysprefs{QueryRemoveStopwords}="Searching";
$tabsysprefs{AdvancedSearchTypes}="Searching";
@@ -260,7 +259,6 @@ my %tabsysprefs;
$tabsysprefs{hideBiblioNumber}="OPAC";
$tabsysprefs{OPACDisplayExtendedSubInfo}="OPAC";
$tabsysprefs{OpacMainUserBlock}="OPAC";
- $tabsysprefs{OPACSubscriptionDisplay}="OPAC";
$tabsysprefs{OPACURLOpenInNewWindow}="OPAC";
$tabsysprefs{OPACUserCSS}="OPAC";
$tabsysprefs{OPACHighlightedWords}="OPAC";
diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql
b/installer/data/mysql/en/mandatory/sysprefs.sql
index 904fa75..b52a667 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -85,7 +85,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnBeforeExpiry',0,'If ON, checkout will be prevented if returndate
is after patron card expiry',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnLog',1,'If ON, enables the circulation (returns)
log',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('reviewson',1,'If ON, enables patron reviews of bibliographic records in
the OPAC','','YesNo');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('sortbynonfiling',0,'Sort search results by MARC nonfiling characters
(deprecated)',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SpecifyDueDate',1,'Define whether to display \"Specify Due Date\" form
in Circulation','','YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionHistory',';','Define the display preference for serials
issue history in OPAC','simplified|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionLog',1,'If ON, enables subscriptions log',NULL,'YesNo');
@@ -146,7 +145,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('itemBarcodeInputFilter','','If set, allows specification of a item
barcode input filter','whitespace|T-prefix|cuecat','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('singleBranchMode',0,'Operate in Single-branch mode, hide branch
selection in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('URLLinkText','','Text to display as the link anchor in the
OPAC',NULL,'free');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACSubscriptionDisplay','economical','Specify how to display
subscription information in the OPAC','economical|off|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACDisplayExtendedSubInfo',1,'If ON, extended subscription information
is displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACViewOthersSuggestions',0,'If ON, allows all suggestions to be
displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACURLOpenInNewWindow',0,'If ON, URLs in the OPAC open in a new
window',NULL,'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 17cb8b8..b0788b0 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
@@ -154,7 +154,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('itemBarcodeInputFilter','','If set, allows specification of a item
barcode input filter','whitespace|T-prefix|cuecat','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('singleBranchMode',0,'Operate in Single-branch mode, hide branch
selection in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('URLLinkText','','Text to display as the link anchor in the
OPAC',NULL,'free');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACSubscriptionDisplay','economical','Specify how to display
subscription information in the OPAC','economical|off|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACDisplayExtendedSubInfo',1,'If ON, extended subscription information
is displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACViewOthersSuggestions',0,'If ON, allows all suggestions to be
displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACURLOpenInNewWindow',0,'If ON, URLs in the OPAC open in a new
window',NULL,'YesNo');
diff --git
a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
index d3954c4..f403d6e 100755
--- a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
@@ -109,7 +109,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnBeforeExpiry',0,'If ON, checkout will be prevented if returndate
is after patron card expiry',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnLog',1,'If ON, enables the circulation (returns)
log',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('reviewson',1,'If ON, enables patron reviews of bibliographic records in
the OPAC','','YesNo');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('sortbynonfiling',0,'Sort search results by MARC nonfiling characters
(deprecated)',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SpecifyDueDate',1,'Define whether to display \"Specify Due Date\" form
in Circulation','','YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionHistory',';','Define the display preference for serials
issue history in OPAC','simplified|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionLog',1,'If ON, enables subscriptions log',NULL,'YesNo');
@@ -170,7 +169,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('itemBarcodeInputFilter','','If set, allows specification of a item
barcode input filter','whitespace|T-prefix|cuecat','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('singleBranchMode',0,'Operate in Single-branch mode, hide branch
selection in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('URLLinkText','','Text to display as the link anchor in the
OPAC',NULL,'free');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACSubscriptionDisplay','economical','Specify how to display
subscription information in the OPAC','economical|off|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACDisplayExtendedSubInfo',1,'If ON, extended subscription information
is displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACViewOthersSuggestions',0,'If ON, allows all suggestions to be
displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACURLOpenInNewWindow',0,'If ON, URLs in the OPAC open in a new
window',NULL,'YesNo');
diff --git
a/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
b/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
index b691371..e981930 100755
--- a/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
@@ -109,7 +109,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnBeforeExpiry',0,'If ON, checkout will be prevented if returndate
is after patron card expiry',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('ReturnLog',1,'If ON, enables the circulation (returns)
log',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('reviewson',1,'If ON, enables patron reviews of bibliographic records in
the OPAC','','YesNo');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('sortbynonfiling',0,'Sort search results by MARC nonfiling characters
(deprecated)',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SpecifyDueDate',1,'Define whether to display \"Specify Due Date\" form
in Circulation','','YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionHistory',';','Define the display preference for serials
issue history in OPAC','simplified|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('SubscriptionLog',1,'If ON, enables subscriptions log',NULL,'YesNo');
@@ -170,7 +169,6 @@ INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('itemBarcodeInputFilter','','If set, allows specification of a item
barcode input filter','whitespace|T-prefix|cuecat','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('singleBranchMode',0,'Operate in Single-branch mode, hide branch
selection in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('URLLinkText','','Text to display as the link anchor in the
OPAC',NULL,'free');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACSubscriptionDisplay','economical','Specify how to display
subscription information in the OPAC','economical|off|full','Choice');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACDisplayExtendedSubInfo',1,'If ON, extended subscription information
is displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACViewOthersSuggestions',0,'If ON, allows all suggestions to be
displayed in the OPAC',NULL,'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('OPACURLOpenInNewWindow',0,'If ON, URLs in the OPAC open in a new
window',NULL,'YesNo');
diff --git a/installer/data/mysql/updatedatabase30.pl
b/installer/data/mysql/updatedatabase30.pl
index e44d53d..16306af 100644
--- a/installer/data/mysql/updatedatabase30.pl
+++ b/installer/data/mysql/updatedatabase30.pl
@@ -171,6 +171,14 @@ ENDOFRENEWAL
SetVersion ($DBversion);
}
+$DBversion = "3.00.02.001";
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+ $dbh->do("DELETE FROM systempreferences WHERE variable in
('OPACSubscriptionDisplay','sortbynonfiling')");
+ print "Upgrade to $DBversion done (remove useless syspref)\n";
+ SetVersion ($DBversion);
+}
+
+
=item DropAllForeignKeys($table)
Drop all foreign keys of the table $table
diff --git a/kohaversion.pl b/kohaversion.pl
index 38cd212..856d05f 100644
--- a/kohaversion.pl
+++ b/kohaversion.pl
@@ -10,7 +10,7 @@
use strict;
sub kohaversion {
- our $VERSION = '3.00.01.007';
+ our $VERSION = '3.00.02.001';
# version needs to be set this way
# so that it can be picked up by Makefile.PL
# during install
--
1.5.6.3
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
