Attachment 125772 Details for Bug 29093 – Bug 29093: Database revision for article_requests.toc_request

[patch] Bug 29093: Database revision for article_requests.toc_request

Bug-29093-Database-revision-for-articlerequeststoc.patch (text/plain), 2.19 KB, created by Marcel de Rooy on 2021-10-06 11:27:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2021-10-06 11:27:07 UTC

Size: 2.19 KB

patch

obsolete

>From e49d84394a7dd878b9cfd218b79c2ce8b31cf561 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 23 Sep 2021 12:30:31 +0000
>Subject: [PATCH] Bug 29093: Database revision for article_requests.toc_request
>Content-Type: text/plain; charset=utf-8
>
>Test plan:
>Run dbrev or new install.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>
>Signed-off-by: David Nind <david@davidnind.com>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_29093.pl | 15 +++++++++++++++
> installer/data/mysql/kohastructure.sql         |  1 +
> 2 files changed, 16 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_29093.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_29093.pl b/installer/data/mysql/atomicupdate/bug_29093.pl
>new file mode 100755
>index 0000000000..ec7fb05b4d
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_29093.pl
>@@ -0,0 +1,15 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "29093",
>+    description => "Add column article_requests.toc_request",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        if( !column_exists('article_requests', 'toc_request') ) {
>+            $dbh->do( q|
>+                ALTER TABLE article_requests ADD COLUMN toc_request tinyint(4) NOT NULL DEFAULT 0 AFTER updated_on
>+            |);
>+        }
>+    },
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 0976ece489..6680a41003 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -756,6 +756,7 @@ CREATE TABLE `article_requests` (
>   `cancellation_reason` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'optional authorised value AR_CANCELLATION',
>   `created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL',
>   `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
>+  `toc_request` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'borrower requested table of contents',
>   PRIMARY KEY (`id`),
>   KEY `borrowernumber` (`borrowernumber`),
>   KEY `biblionumber` (`biblionumber`),
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 29093: 125190 | 125191 | 125192 | 125288 | 125289 | 125290 | 125448 | 125449 | 125450 | 125772 | 125773 | 125774 | 125775 | 125787 | 125788 | 125789 | 125790 | 125791 | 125792