From 292228966c8aab3992dd93b42e56e003cb6555c0 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 2 Aug 2019 15:53:01 -0300 Subject: [PATCH] Bug 23396: (QA follow-up) Add atomic update New installs before the fix won't have the table populated, this patch adds a fix for that, including the shortcut added by bug 17178. Signed-off-by: Tomas Cohen Arazi --- .../data/mysql/atomicupdate/bug_23396.perl | 22 +++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_23396.perl diff --git a/installer/data/mysql/atomicupdate/bug_23396.perl b/installer/data/mysql/atomicupdate/bug_23396.perl new file mode 100644 index 0000000000..5f214c7546 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_23396.perl @@ -0,0 +1,22 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + + $dbh->do(q| + INSERT IGNORE INTO keyboard_shortcuts (shortcut_name, shortcut_keys) VALUES + ("insert_copyright","Alt-C"), + ("insert_copyright_sound","Alt-P"), + ("insert_delimiter","Ctrl-D"), + ("subfield_help","Ctrl-H"), + ("link_authorities","Shift-Ctrl-L"), + ("delete_field","Ctrl-X"), + ("delete_subfield","Shift-Ctrl-X"), + ("new_line","Enter"), + ("line_break","Shift-Enter"), + ("next_position","Tab"), + ("prev_position","Shift-Tab"), + ("toggle_keyboard", "Shift-Ctrl-K") + ;|); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 23396 - Fix missing keyboard_shortcuts table)\n"; +} \ No newline at end of file -- 2.22.0