Bug 16371: Add database updates

[koha.git] / installer / data / mysql / atomicupdate / bug_16371-QOTD_for_the_staff_interface.perl

diff --git a/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl b/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl
new file mode 100644 (file)
index 0000000..d5bf79c
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl
@@ -0,0 +1,10 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    # you can use $dbh here like:
+    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
+
+    $dbh->do( "UPDATE systempreferences SET value = '', options = 'intranet,opac', explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page', type = 'multiple' WHERE variable = 'QuoteOfTheDay'" );
+
+    # Always end with this (adjust the bug info)
+    NewVersion( $DBversion, 16371, "Bug 16371 - Quote of the Day (QOTD) for the staff interface ");
+}