Attachment 125288 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), 1.99 KB, created by David Nind on 2021-09-24 16:44:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Nind

Created: 2021-09-24 16:44:45 UTC

Size: 1.99 KB

patch

obsolete

>From f0940da2e6269be149bfb5d93d47e9a4ee49846c 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
>
>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>
>---
> 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 f9e5c6453e..09de062ac7 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -755,6 +755,7 @@ CREATE TABLE `article_requests` (
>   `urls` MEDIUMTEXT,
>   `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