Attachment 92735 Details for Bug 15497 – Bug 15497: Add itemtypes_branches table and atomic update

[patch] Bug 15497: Add itemtypes_branches table and atomic update

Bug-15497-Add-itemtypesbranches-table-and-atomic-u.patch (text/plain), 2.64 KB, created by Martin Renvoize (ashimema) on 2019-09-12 15:22:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2019-09-12 15:22:19 UTC

Size: 2.64 KB

patch

obsolete

>From 61ed2056d93e0757fb0b780e9fa41b674215c5f1 Mon Sep 17 00:00:00 2001
>From: Agustin Moyano <agustinmoyano@theke.io>
>Date: Thu, 4 Jul 2019 01:30:17 -0300
>Subject: [PATCH] Bug 15497: Add itemtypes_branches table and atomic update
>
>Signed-off-by: Jessica Zairo <jzairo@bywatersolutions.com>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> .../data/mysql/atomicupdate/bug_15497.perl      | 17 +++++++++++++++++
> installer/data/mysql/kohastructure.sql          | 12 ++++++++++++
> 2 files changed, 29 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_15497.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_15497.perl b/installer/data/mysql/atomicupdate/bug_15497.perl
>new file mode 100644
>index 0000000000..cc187cd7cd
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_15497.perl
>@@ -0,0 +1,17 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    if( !TableExists( 'itemtypes_branches' ) ) {
>+       $dbh->do( "
>+            CREATE TABLE itemtypes_branches( -- association table between authorised_values and branches
>+                itemtype VARCHAR(10) NOT NULL,
>+                branchcode VARCHAR(10) NOT NULL,
>+                FOREIGN KEY (itemtype) REFERENCES itemtypes(itemtype) ON DELETE CASCADE,
>+                FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
>+            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+        ");
>+    }
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 15497 - Add itemtypes_branches table)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index f6da9ee1d3..94cac768ca 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4287,6 +4287,18 @@ shortcut_keys varchar(80) NOT NULL,
> PRIMARY KEY (shortcut_name)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
>+--
>+-- Table structure for table itemtypes_branches
>+--
>+
>+DROP TABLE IF EXISTS itemtypes_branches;
>+CREATE TABLE itemtypes_branches( -- association table between authorised_values and branches
>+    itemtype VARCHAR(10) NOT NULL,
>+    branchcode VARCHAR(10) NOT NULL,
>+    FOREIGN KEY (itemtype) REFERENCES itemtypes(itemtype) ON DELETE CASCADE,
>+    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 15497: 91377 | 91378 | 91379 | 91446 | 91450 | 91451 | 91452 | 91469 | 92725 | 92726 | 92727 | 92728 | 92732 | 92735 | 92736 | 92737 | 92738 | 92739 | 92741 | 92742 | 92743 | 92744 | 92745