Bugzilla – Attachment 79771 Details for
Bug 18887
Introduce new table 'circulation_rules', use for 'max_holds' rules
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18887: Add foreign keys
Bug-18887-Add-foreign-keys.patch (text/plain), 2.68 KB, created by
Josef Moravec
on 2018-10-01 19:35:34 UTC
(
hide
)
Description:
Bug 18887: Add foreign keys
Filename:
MIME Type:
Creator:
Josef Moravec
Created:
2018-10-01 19:35:34 UTC
Size:
2.68 KB
patch
obsolete
>From 22bd30a40d74240cf7a1fe58d098e0224dbf1b5b Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Sat, 29 Sep 2018 17:29:44 -0300 >Subject: [PATCH] Bug 18887: Add foreign keys > >Signed-off-by: Josef Moravec <josef.moravec@gmail.com> >--- > installer/data/mysql/atomicupdate/bug_18887.perl | 7 ++++--- > installer/data/mysql/kohastructure.sql | 6 +++--- > 2 files changed, 7 insertions(+), 6 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_18887.perl b/installer/data/mysql/atomicupdate/bug_18887.perl >index 85da1d2..97eb1ef 100644 >--- a/installer/data/mysql/atomicupdate/bug_18887.perl >+++ b/installer/data/mysql/atomicupdate/bug_18887.perl >@@ -11,9 +11,10 @@ if( CheckVersion( $DBversion ) ) { > `rule_name` varchar(32) NOT NULL, > `rule_value` varchar(32) NOT NULL, > PRIMARY KEY (`id`), >- KEY `branchcode` (`branchcode`), >- KEY `categorycode` (`categorycode`), >- KEY `itemtype` (`itemtype`), >+ >+ CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, > KEY `rule_name` (`rule_name`), > UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index e889d14..c4d47d2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4219,9 +4219,9 @@ CREATE TABLE `circulation_rules` ( > `rule_name` varchar(32) NOT NULL, > `rule_value` varchar(32) NOT NULL, > PRIMARY KEY (`id`), >- KEY `branchcode` (`branchcode`), >- KEY `categorycode` (`categorycode`), >- KEY `itemtype` (`itemtype`), >+ CONSTRAINT `circ_rules_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `circ_rules_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE, > KEY `rule_name` (`rule_name`), > UNIQUE (`branchcode`,`categorycode`,`itemtype`,`rule_name`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >-- >2.1.4
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 18887
:
65233
|
65234
|
65235
|
65236
|
65237
|
67620
|
70986
|
70987
|
70988
|
70989
|
70990
|
70991
|
71031
|
71042
|
72218
|
72219
|
72220
|
72221
|
72222
|
72223
|
72224
|
77080
|
77081
|
77082
|
77083
|
77084
|
77085
|
77086
|
77087
|
77207
|
77208
|
77209
|
77210
|
77211
|
77212
|
77213
|
77214
|
77215
|
77218
|
77238
|
77649
|
77650
|
77651
|
77652
|
77653
|
77654
|
77655
|
77656
|
77657
|
77658
|
77659
|
78346
|
78347
|
78348
|
78349
|
78350
|
78351
|
78352
|
78353
|
78354
|
78355
|
78356
|
78674
|
78675
|
78676
|
78677
|
78678
|
78679
|
78680
|
78681
|
78682
|
78683
|
78684
|
78743
|
78744
|
78745
|
78746
|
78747
|
78748
|
78749
|
78750
|
78751
|
78752
|
78753
|
78879
|
79119
|
79626
|
79627
|
79628
|
79629
|
79630
|
79631
|
79632
|
79633
|
79634
|
79635
|
79636
|
79637
|
79638
|
79639
|
79640
|
79641
|
79761
|
79762
|
79763
|
79764
|
79765
|
79766
|
79767
|
79768
|
79769
|
79770
| 79771 |
79772
|
79773
|
79774
|
79775
|
79776
|
79778
|
79891