From 37cd6d5df64bc9dba5a0ab9820cede196da151dd Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 1 Mar 2021 16:40:17 +0000 Subject: [PATCH] Bug 26247: Atomic update Signed-off-by: Sally --- installer/data/mysql/atomicupdate/bug_26247.perl | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_26247.perl diff --git a/installer/data/mysql/atomicupdate/bug_26247.perl b/installer/data/mysql/atomicupdate/bug_26247.perl new file mode 100644 index 0000000000..0c016051b0 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_26247.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q| + INSERT IGNORE INTO systempreferences (variable, value, explanation, options, type) VALUES + ('StaffRetainSearchTerms', '1', 'If enabled, searches entered into the search bar will be retained', NULL, 'YesNo'), + ('StaffStickySearchTerms', '1', 'If enabled, searches entered into the search bar will be copied to other header tabs', NULL, 'YesNo') + ; + |); + NewVersion( $DBversion, 26247, "Add StaffRetainSearchTerms and StaffStickySearchTerms preferences"); +} -- 2.11.0