Bugzilla – Attachment 89429 Details for
Bug 18928
Move `holdallowed`, `hold_fulfillment_policy` and `returnbranch` into the `circulation_rules` table.
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18928: Add DB structure changes
Bug-18928-Add-DB-structure-changes.patch (text/plain), 4.53 KB, created by
Kyle M Hall (khall)
on 2019-05-07 14:25:02 UTC
(
hide
)
Description:
Bug 18928: Add DB structure changes
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2019-05-07 14:25:02 UTC
Size:
4.53 KB
patch
obsolete
>From 187e2bea3c9b941fc97a71e53362af1e93b90c52 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> >Signed-off-by: Agustin Moyano <agustinmoyano@theke.io> > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > 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 >@@ -354,34 +354,6 @@ CREATE TABLE collections_tracking ( > PRIMARY KEY (collections_tracking_id) > ) 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` > -- >@@ -969,21 +941,6 @@ CREATE TABLE `itemtypes` ( -- defines the item types > UNIQUE KEY `itemtype` (`itemtype`) > ) 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` > -- >@@ -1006,25 +963,6 @@ CREATE TABLE `branchtransfers` ( -- information for items that are in transit be > CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE > ) 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.20.1 (Apple Git-117)
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
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