From fa27de30d5427a8f8104a57e2cd25a818279e511 Mon Sep 17 00:00:00 2001
From: Owen Leonard <oleonard@myacpl.org>
Date: Thu, 11 Apr 2019 11:03:20 +0000
Subject: [PATCH] Bug 21891: (follow-up) Update database to set blank values to
 "default"

This patch adds a database update which will update any blank values of
the XSLTDetailsDisplay system preference to "default." Although a blank
value will still result in the default XSLT view, it's more consistent
with the other XSLT preferences to use "default."

To test, apply the patch and set the XSLTDetailsDisplay to a blank
value. Run the database update. The value of the XSLTDetailsDisplay
system preference should now be "default."
---
 .../data/mysql/atomicupdate/bug_21891-remove-non-xslt-detail.perl  | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_21891-remove-non-xslt-detail.perl

diff --git a/installer/data/mysql/atomicupdate/bug_21891-remove-non-xslt-detail.perl b/installer/data/mysql/atomicupdate/bug_21891-remove-non-xslt-detail.perl
new file mode 100644
index 0000000..fd67848
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_21891-remove-non-xslt-detail.perl
@@ -0,0 +1,7 @@
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+    $dbh->do( "UPDATE systempreferences SET value = 'default' WHERE variable = 'XSLTDetailsDisplay' AND value = ''" );
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 29891 - Remove non-XSLT detail view in the staff client)\n";
+}
+
-- 
2.1.4