Necessary db schema, updatedatabase.pl, and syspref sql updates.
NOTE: This leaves the db minor rev as .XXX and therefore does not
modify kohaversion.pl.
---
installer/data/mysql/en/mandatory/sysprefs.sql | 2 ++
.../1-Obligatoire/unimarc_standard_systemprefs.sql | 3 +++
installer/data/mysql/pl-PL/mandatory/sysprefs.sql | 3 +++
.../ru-RU/mandatory/system_preferences_optimal.sql | 3 +++
.../uk-UA/mandatory/system_preferences_optimal.sql | 3 +++
installer/data/mysql/updatedatabase.pl | 9 +++++++++
6 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql
b/installer/data/mysql/en/mandatory/sysprefs.sql
index 3647715..64a8bc7 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -282,3 +282,5 @@ INSERT INTO `systempreferences`
(variable,value,options,explanation,type) VALUES
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0',
'For corporate and special libraries which want web-based self-check available
from any PC without the need for a manual staff login. Most libraries will want
to leave this turned off. If on, requires self-check ID and password to be
entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.', '', 'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckID','','Staff ID with circulation rights to be used for
automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is
turned on.','','free');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckPass','','Password to be used for automatic web-based
self-check. Only applies if AutoSelfCheckAllowed syspref is turned
on.','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before
session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the
header of the web-based self checkout service','Textarea');
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 1738d8d..acf7053 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
@@ -285,3 +285,6 @@ INSERT INTO `systempreferences`
(variable,value,options,explanation,type) VALUES
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0',
'Pour les bibliothèques d''entreprise qui veulent du prêt auto-contrôlé de
n''importe quel PC sans le besoin de recourir à un login de bibliothécaire.',
'', 'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckID','','Identifiant Bibliothécaire avec droits de
circulation qui sera utilisé pour les prêt auto-contré. Ne s''applique que
dans les cas de l''activation de la préférence AutoSelfCheckout.','','free');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckPass','','Mot de passe utilisé pour le prêt
autocontrôlé. Ne s''applique que dans le cas de l''activation de la
préférence AutoSelfCheckout.','','free');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before
session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the
header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
index c62aad0..568e221 100755
--- a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
+++ b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql
@@ -274,3 +274,6 @@ INSERT INTO systempreferences
(variable,value,explanation,options,type) VALUES('
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('ShowPatronImageInWebBasedSelfCheck',
'0', 'If ON, displays patron image when a patron uses web-based
self-checkout', '', 'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('EnableOpacSearchHistory', '1', 'Enable or disable opac search
history','', 'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('RoutingListAddReserves','1','If ON the patrons on routing lists are
automatically added to holds on the issue.','','YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before
session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the
header of the web-based self checkout service','Textarea');
+
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 a33f793..7b56270 100644
--- a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql
@@ -242,3 +242,6 @@ INSERT INTO systempreferences
(variable,value,options,explanation,type)VALUES('D
INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('AutoSelfCheckAllowed', '0',
'For corporate and special libraries which want web-based self-check available
from any PC without the need for a manual staff login. Most libraries will want
to leave this turned off. If on, requires self-check ID and password to be
entered in AutoSelfCheckID and AutoSelfCheckPass sysprefs.', '', 'YesNo');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckID','','Staff ID with circulation rights to be used for
automatic web-based self-check. Only applies if AutoSelfCheckAllowed syspref is
turned on.','70|10','Textarea');
INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES('AutoSelfCheckPass','','Password to be used for automatic web-based
self-check. Only applies if AutoSelfCheckAllowed syspref is turned
on.','70|10','Textarea');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before
session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the
header of the web-based self checkout service','Textarea');
+
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 871fee0..35205b6 100644
--- a/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
+++ b/installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql
@@ -238,3 +238,6 @@ INSERT INTO `systempreferences`
(variable,value,options,explanation,type) VALUES
INSERT INTO systempreferences (variable,value,explanation,options,type)
VALUES('AllowRenewalLimitOverride', '0', 'if ON, allows renewal limits to be
overridden on the circulation screen',NULL,'YesNo');
INSERT INTO systempreferences (variable,value,explanation,options,type)
VALUES('MergeAuthoritiesOnUpdate', '1', 'if ON, Updating authorities will
automatically updates biblios',NULL,'YesNo');
INSERT INTO systempreferences (variable,value,explanation,options,type)
VALUES('AllowNotForLoanOverride', '0', 'if ON, enables the librarian to choose
when they want to check out a notForLoan regular item',NULL,'YesNo');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before
session times out (1000 milliseconds/second)','Integer');
+INSERT INTO `systempreferences` (variable,value,explanation,options,type)
VALUES ('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the
header of the web-based self checkout service','Textarea');
+
diff --git a/installer/data/mysql/updatedatabase.pl
b/installer/data/mysql/updatedatabase.pl
index 32ad48b..cb3dc11 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -3445,6 +3445,15 @@ if (C4::Context->preference("Version") <
TransformToNum($DBversion)) {
SetVersion ($DBversion);
}
+$DBversion = '3.01.00.XXX';
+if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+ $dbh->do("INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('WebBasedSelfCheckTimeout','120000','','Number of milliseconds before session
times out (1000 milliseconds/second)','Integer')");
+ $dbh->do("INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('WebBasedSelfCheckHeader','','70|10','Include the following HTML in the header
of the web-based self checkout service','Textarea')");
+ print "Upgrade to $DBversion done (Adding new web-based self checkout
system preferences: WebBasedSelfCheckTimeout, WebBasedSelfCheckHeader)\n";
+ SetVersion ($DBversion);
+}
+
+
=item DropAllForeignKeys($table)
Drop all foreign keys of the table $table
--
1.6.0.4
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
