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>

diff --git a/installer/data/mysql/atomicupdate/bug_17178.perl b/installer/data/mysql/atomicupdate/bug_17178.perl
new file mode 100644 (file)
index 0000000..e22a233
--- /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 ef4a955..604fc6f 100644 (file)
--- 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");