From 00b71e8ea3deb717a343a266888744939d23187b Mon Sep 17 00:00:00 2001
From: Agustin Moyano <agustinmoyano@theke.io>
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 <wizzyrea@gmail.com>
Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 installer/data/mysql/atomicupdate/bug_17178.perl      | 10 ++++++++++
 installer/data/mysql/mandatory/keyboard_shortcuts.sql |  3 ++-
 2 files changed, 12 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..e22a2333e8
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_17178.perl
@@ -0,0 +1,10 @@
+$DBversion = 'XXX';
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do(q{
+        INSERT INTO keyboard_shortcuts (shortcut_name, shortcut_keys)
+            VALUES ("toggle_keyboard", "Shift-Ctrl-K")
+    });
+
+    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..604fc6ff94 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", "Shift-Ctrl-K");
-- 
2.20.1