Attachment 154186 Details for Bug 30708 – Bug 30708: DO NOT PUSH - ONLY FOR DB UPDATE DURING TESTING STAGE

[patch] Bug 30708: DO NOT PUSH - ONLY FOR DB UPDATE DURING TESTING STAGE

Bug-30708-DO-NOT-PUSH---ONLY-FOR-DB-UPDATE-DURING-.patch (text/plain), 2.10 KB, created by Jonathan Druart on 2023-08-03 08:23:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2023-08-03 08:23:31 UTC

Size: 2.10 KB

patch

obsolete

>From 47ca573c72a6e7449ee6b08ef2a80b2f439d8481 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 24 Apr 2023 20:38:16 +0200
>Subject: [PATCH] Bug 30708: DO NOT PUSH - ONLY FOR DB UPDATE DURING TESTING
> STAGE
>
>Sponsored-by: BULAC - http://www.bulac.fr/
>
>Signed-off-by: BULAC - http://www.bulac.fr/
>Signed-off-by: Heather Hernandez <heather_hernandez@nps.gov>
>Signed-off-by: Laurence Rault <laurence.rault@biblibre.com>
>---
> installer/data/mysql/atomicupdate/bug_30708.pl | 16 ++++++++++++++++
> 1 file changed, 16 insertions(+)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_30708.pl b/installer/data/mysql/atomicupdate/bug_30708.pl
>index 2f80c19c7b7..394fe5dacf4 100755
>--- a/installer/data/mysql/atomicupdate/bug_30708.pl
>+++ b/installer/data/mysql/atomicupdate/bug_30708.pl
>@@ -109,5 +109,21 @@ return {
>             say $out "Added new table 'preservation_processing_attributes_items'";
>         }
> 
>+        unless ( column_exists('preservation_processing_attributes_items', 'processing_attribute_item_id') ) {
>+            $dbh->do(q{
>+                ALTER TABLE preservation_processing_attributes_items
>+                DROP CONSTRAINT `preservation_processing_attributes_items_ibfk_1`,
>+                DROP CONSTRAINT `preservation_processing_attributes_items_ibfk_2`,
>+                DROP PRIMARY KEY,
>+                ADD COLUMN `processing_attribute_item_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
>+                ADD PRIMARY KEY(`processing_attribute_item_id`)
>+            });
>+            $dbh->do(q{
>+                ALTER TABLE preservation_processing_attributes_items
>+                ADD CONSTRAINT `preservation_processing_attributes_items_ibfk_1` FOREIGN KEY (`processing_attribute_id`) REFERENCES `preservation_processing_attributes` (`processing_attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
>+                ADD CONSTRAINT `preservation_processing_attributes_items_ibfk_2` FOREIGN KEY (`train_item_id`) REFERENCES `preservation_trains_items` (`train_item_id`) ON DELETE CASCADE ON UPDATE CASCADE
>+            });
>+        }
>+
>     },
> };
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 30708: 134715 | 134716 | 134732 | 134733 | 134734 | 134736 | 134737 | 134738 | 134782 | 134783 | 134784 | 134785 | 152939 | 152940 | 152941 | 152942 | 152943 | 152944 | 152945 | 152946 | 152947 | 152948 | 152949 | 152950 | 152951 | 152952 | 152953 | 152954 | 152955 | 152956 | 152957 | 152958 | 152959 | 152960 | 152961 | 152962 | 152963 | 152964 | 152965 | 152966 | 152967 | 152968 | 152969 | 152970 | 153102 | 153576 | 154167 | 154168 | 154169 | 154170 | 154171 | 154172 | 154173 | 154174 | 154175 | 154176 | 154177 | 154178 | 154179 | 154180 | 154181 | 154182 | 154183 | 154184 | 154185 | 154186 | 154187 | 154188 | 154189 | 154190 | 154191 | 154192 | 154193 | 154194 | 154195 | 154196 | 154197 | 154198 | 154199 | 154200 | 154201 | 154202 | 154203 | 156592 | 156596 | 156597 | 156636 | 156637 | 156638 | 156639 | 156640 | 156641 | 156642 | 156643 | 156644 | 156645 | 156646 | 156647 | 156648 | 156649 | 156650 | 156651 | 156652 | 156653 | 156654 | 156655 | 156656 | 156657 | 156658 | 156659 | 156660 | 156661 | 156662 | 156663 | 156664 | 156665 | 156666 | 156667 | 156668 | 156669 | 156670 | 156671 | 156672 | 156673 | 156674 | 156675 | 157502 | 157503 | 157506 | 157508 | 157512 | 157514 | 157557