From f9c6a5678e768da22baf1869b07ead62dbbd2878 Mon Sep 17 00:00:00 2001
From: Alex Buckley <alexbuckley@catalyst.net.nz>
Date: Fri, 2 Jul 2021 06:46:12 +0000
Subject: [PATCH] Bug 26346: Database changes

- Adds allow_change_from_staff to virtualshelves table

Sponsored-By: Catalyst IT
---
 installer/data/mysql/atomicupdate/bug_26346.perl | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_26346.perl

diff --git a/installer/data/mysql/atomicupdate/bug_26346.perl b/installer/data/mysql/atomicupdate/bug_26346.perl
new file mode 100644
index 0000000000..a3470125ad
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_26346.perl
@@ -0,0 +1,7 @@
+$DBversion = 'XXX';
+if ( CheckVersion($DBversion) ) {
+    if ( !column_exists( 'virtualshelves', 'allow_change_from_staff' ) ) {
+        $dbh->do(q{ALTER TABLE virtualshelves ADD COLUMN `allow_change_from_staff` tinyint(1) DEFAULT '0'});
+    }
+    NewVersion( $DBversion, 26346, "Add allow_change_from_staff to virtualshelves table" );
+}
-- 
2.11.0