Attachment 89018 Details for Bug 18928 – Bug 18928: Add DB structure changes

[patch] Bug 18928: Add DB structure changes

Bug-18928-Add-DB-structure-changes.patch (text/plain), 4.21 KB, created by Jonathan Druart on 2019-04-29 15:21:24 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2019-04-29 15:21:24 UTC

Size: 4.21 KB

patch

obsolete

>From b3481aaac237ff8cedee7016d748b3ecd751425a Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 24 Oct 2018 19:32:48 -0300
>Subject: [PATCH] Bug 18928: Add DB structure changes
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> installer/data/mysql/kohastructure.sql | 62 ----------------------------------
> 1 file changed, 62 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 77224bcac3..f339272cbf 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -355,34 +355,6 @@ CREATE TABLE collections_tracking (
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
> --
>--- Table structure for table `default_branch_circ_rules`
>---
>-
>-DROP TABLE IF EXISTS `default_branch_circ_rules`;
>-CREATE TABLE `default_branch_circ_rules` (
>-  `branchcode` VARCHAR(10) NOT NULL,
>-  `holdallowed` tinyint(1) default NULL,
>-  hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
>-  `returnbranch` varchar(15) default NULL,
>-  PRIMARY KEY (`branchcode`),
>-  CONSTRAINT `default_branch_circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
>-    ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-
>---
>--- Table structure for table `default_circ_rules`
>---
>-
>-DROP TABLE IF EXISTS `default_circ_rules`;
>-CREATE TABLE `default_circ_rules` (
>-    `singleton` enum('singleton') NOT NULL default 'singleton',
>-    `holdallowed` int(1) default NULL,
>-    hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
>-    `returnbranch` varchar(15) default NULL,
>-    PRIMARY KEY (`singleton`)
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-
>---
> -- Table structure for table `cities`
> --
> 
>@@ -970,21 +942,6 @@ CREATE TABLE `itemtypes` ( -- defines the item types
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
> --
>--- Table structure for table `default_branch_item_rules`
>---
>-
>-DROP TABLE IF EXISTS `default_branch_item_rules`;
>-CREATE TABLE `default_branch_item_rules` (
>-  `itemtype` varchar(10) NOT NULL,
>-  `holdallowed` tinyint(1) default NULL,
>-  hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
>-  `returnbranch` varchar(15) default NULL,
>-  PRIMARY KEY  (`itemtype`),
>-  CONSTRAINT `default_branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
>-    ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-
>---
> -- Table structure for table `branchtransfers`
> --
> 
>@@ -1007,25 +964,6 @@ CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
> --
>--- Table structure for table `branch_item_rules`
>---
>-
>-DROP TABLE IF EXISTS `branch_item_rules`;
>-CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and fine rules under 'Holds policy by item type'
>-  `branchcode` varchar(10) NOT NULL, -- the branch this rule is for (branches.branchcode)
>-  `itemtype` varchar(10) NOT NULL, -- the item type this rule applies to (items.itype)
>-  `holdallowed` tinyint(1) default NULL, -- the number of holds allowed
>-  hold_fulfillment_policy ENUM('any', 'homebranch', 'holdingbranch') NOT NULL DEFAULT 'any', -- limit trapping of holds by branchcode
>-  `returnbranch` varchar(15) default NULL, -- the branch the item returns to (homebranch, holdingbranch, noreturn)
>-  PRIMARY KEY  (`itemtype`,`branchcode`),
>-  KEY `branch_item_rules_ibfk_2` (`branchcode`),
>-  CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`)
>-    ON DELETE CASCADE ON UPDATE CASCADE,
>-  CONSTRAINT `branch_item_rules_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
>-    ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-
>---
> -- Table structure for table `creator_images`
> --
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 18928: 65241 | 65242 | 71005 | 71006 | 81096 | 81097 | 81098 | 81099 | 82933 | 82934 | 82935 | 82936 | 85487 | 85488 | 85489 | 85490 | 85491 | 86134 | 86135 | 86136 | 86137 | 86138 | 86139 | 88659 | 89017 | 89018 | 89019 | 89020 | 89021 | 89022 | 89023 | 89024 | 89333 | 89334 | 89336 | 89338 | 89339 | 89340 | 89341 | 89342 | 89343 | 89344 | 89345 | 89346 | 89347 | 89348 | 89349 | 89377 | 89402 | 89427 | 89428 | 89429 | 89430 | 89431 | 89432 | 89433 | 89434 | 89435 | 89436 | 89437 | 89438 | 89440 | 89441 | 89442 | 89443 | 89444 | 89445 | 89446 | 89447 | 89448 | 89449 | 89450 | 89451 | 89628 | 89629 | 89630 | 89631 | 89632 | 89633 | 89634 | 89635 | 89636 | 89637 | 89638 | 90501 | 91082 | 91083 | 91084 | 91085 | 91086 | 91087 | 91088 | 91089 | 91090 | 91091 | 91092 | 91093 | 91094