Attachment 156112 Details for Bug 34686 – Bug 34686: Add reserve_id to tmp_holdsqueue table (database update)

[patch] Bug 34686: Add reserve_id to tmp_holdsqueue table (database update)

Bug-34686-Add-reserveid-to-tmpholdsqueue-table-dat.patch (text/plain), 3.16 KB, created by Katrin Fischer on 2023-09-22 16:28:26 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2023-09-22 16:28:26 UTC

Size: 3.16 KB

patch

obsolete

>From 0f3febe8e261ec5979974a7e732fb14a8ac96aed Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer@bsz-bw.de>
>Date: Fri, 22 Sep 2023 15:35:01 +0000
>Subject: [PATCH] Bug 34686: Add reserve_id to tmp_holdsqueue table (database
> update)
>
>---
> .../atomicupdate/bug_34686_reserve_id.pl      | 22 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  5 ++++-
> 2 files changed, 26 insertions(+), 1 deletion(-)
> create mode 100755 installer/data/mysql/atomicupdate/bug_34686_reserve_id.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_34686_reserve_id.pl b/installer/data/mysql/atomicupdate/bug_34686_reserve_id.pl
>new file mode 100755
>index 0000000000..b9a41e5167
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_34686_reserve_id.pl
>@@ -0,0 +1,22 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => "34686",
>+    description => "Add reserve_id to tmp_holdsqueue table",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        unless ( column_exists( 'tmp_holdsqueue', 'reserve_id' ) ) {
>+            $dbh->do(
>+                q{
>+                ALTER TABLE tmp_holdsqueue ADD reserve_id int(11) NULL DEFAULT NULL FIRST
>+            }
>+            );
>+            $dbh->do(
>+                q{ ALTER TABLE tmp_holdsqueue ADD CONSTRAINT `tmp_holdsqueue_ibfk_4` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE CASCADE ON UPDATE CASCADE }
>+            );
>+            say $out "Added column 'tmp_holdsqueue.reserve_id'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index add4518807..8a3b442da9 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -5869,6 +5869,7 @@ DROP TABLE IF EXISTS `tmp_holdsqueue`;
> /*!40101 SET @saved_cs_client     = @@character_set_client */;
> /*!40101 SET character_set_client = utf8 */;
> CREATE TABLE `tmp_holdsqueue` (
>+  `reserve_id` int(11) DEFAULT NULL,
>   `biblionumber` int(11) DEFAULT NULL,
>   `itemnumber` int(11) NOT NULL,
>   `barcode` varchar(20) DEFAULT NULL,
>@@ -5889,9 +5890,11 @@ CREATE TABLE `tmp_holdsqueue` (
>   KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`),
>   KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`),
>   KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`),
>+  KEY `tmp_holdsqueue_ibfk_4` (`reserve_id`),
>   CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>   CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>-  CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
>+  CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
>+  CONSTRAINT `tmp_holdsqueue_ibfk_4` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 34686: 156112 | 156113