Bug 25871: (QA follow-up) Update syspref

[koha.git] / installer / data / mysql / atomicupdate / bug_25871_Update_OpacItemLocation_preference.perl

diff --git a/installer/data/mysql/atomicupdate/bug_25871_Update_OpacItemLocation_preference.perl b/installer/data/mysql/atomicupdate/bug_25871_Update_OpacItemLocation_preference.perl
new file mode 100644 (file)
index 0000000..fce4245
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_25871_Update_OpacItemLocation_preference.perl
@@ -0,0 +1,8 @@
+$DBversion = 'XXX';
+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");
+}