Bug 25871: DBRev 20.06.00.021

[koha.git] / installer / data / mysql / updatedatabase.pl

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 76a4ffa..99371e4 100755 (executable)
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -22543,6 +22543,15 @@ if( CheckVersion( $DBversion ) ) {
     NewVersion( $DBversion, 26070, "Remove references to deprecated Google Transliterate API");
 }
 
+$DBversion = '20.06.00.021';
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do(q{
+        UPDATE systempreferences SET options = "callnum|ccode|location|library"
+        WHERE variable = "OpacItemLocation"
+    });
+    NewVersion( $DBversion, 25871, "Add library option to OpacItemLocation");
+}
+
 # SEE bug 13068
 # if there is anything in the atomicupdate, read and execute it.
 my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';