From 7003064908c6d2235fc336794acd9e9a0924a725 Mon Sep 17 00:00:00 2001 From: Agustin Moyano Date: Tue, 14 May 2019 02:57:07 -0300 Subject: [PATCH] Bug 17178: Add shortcut to keyboard_shortcut table This patch adds Ctrl-K shortcut to toggle virtual keyboard shortcut Sponsored-by: Round Rock Public Library Signed-off-by: Liz Rea --- installer/data/mysql/atomicupdate/bug_17178.perl | 15 +++++++++++++++ installer/data/mysql/mandatory/keyboard_shortcuts.sql | 3 ++- 2 files changed, 17 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_17178.perl diff --git a/installer/data/mysql/atomicupdate/bug_17178.perl b/installer/data/mysql/atomicupdate/bug_17178.perl new file mode 100644 index 0000000000..851285211e --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_17178.perl @@ -0,0 +1,15 @@ +$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" ); + + # or perform some test and warn + # if( !column_exists( 'biblio', 'biblionumber' ) ) { + # warn "There is something wrong"; + # } + $dbh->do( 'INSERT INTO keyboard_shortcuts (shortcut_name, shortcut_keys) VALUES ("toggle_keyboard", "Ctrl-K")'); + + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 17178 - add shortcut to keyboard_shortcuts)\n"; +} diff --git a/installer/data/mysql/mandatory/keyboard_shortcuts.sql b/installer/data/mysql/mandatory/keyboard_shortcuts.sql index ef4a95553d..1f87056b24 100644 --- a/installer/data/mysql/mandatory/keyboard_shortcuts.sql +++ b/installer/data/mysql/mandatory/keyboard_shortcuts.sql @@ -31,4 +31,5 @@ INSERT INTO keyboard_shortcuts (shortcut_name, shortcut_keys) VALUES ("new_line","Enter"), ("line_break","Shift-Enter"), ("next_position","Tab"), - ("prev_position","Shift-Tab"); + ("prev_position","Shift-Tab"), + ("toggle_keyboard", "Ctrl-K"); -- 2.11.0