Bug 8732: Update statement

[koha-equinox.git] / installer / data / mysql / atomicupdate / bug_8732_add_BiblioItemtypeInfo_system_preference.perl

diff --git a/installer/data/mysql/atomicupdate/bug_8732_add_BiblioItemtypeInfo_system_preference.perl b/installer/data/mysql/atomicupdate/bug_8732_add_BiblioItemtypeInfo_system_preference.perl
new file mode 100644 (file)
index 0000000..9af09f3
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_8732_add_BiblioItemtypeInfo_system_preference.perl
@@ -0,0 +1,7 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('BiblioItemtypeInfo', '0','Control whether biblio level itemtype image displays','0','YesNo')" );
+
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 8732: Add new BiblioItemtypeInfo to system preferences)\n";
+}