Attachment 122535 Details for Bug 26346 – Bug 26346: Database changes

[patch] Bug 26346: Database changes

Bug-26346-Database-changes.patch (text/plain), 1.03 KB, created by Alex Buckley on 2021-07-02 11:14:54 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Buckley

Created: 2021-07-02 11:14:54 UTC

Size: 1.03 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 26346: 119686 | 120663 | 120664 | 120665 | 120909 | 120910 | 120953 | 120954 | 121511 | 121512 | 122033 | 122034 | 122533 | 122535 | 122536 | 122537 | 122538 | 122539 | 122540 | 122685 | 122686 | 122687 | 122688 | 122689 | 122691 | 124010 | 124011 | 125436 | 125472 | 125914 | 125915 | 125916 | 125917 | 127556 | 127557 | 127558 | 127559 | 127560 | 128017 | 128018 | 128019 | 128020 | 128021 | 128022 | 128023 | 128383 | 128384 | 128385 | 131699 | 131700 | 131757 | 131764 | 132373 | 132475 | 132476 | 132477 | 132478 | 132479 | 132751 | 132752 | 132753 | 132754 | 132755