Bugzilla – Attachment 178388 Details for
Bug 32630
Don't delete ILL requests when patron is deleted
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32630: database changes
Bug-32630-database-changes.patch (text/plain), 1.50 KB, created by
Pedro Amorim
on 2025-02-20 11:58:18 UTC
(
hide
)
Description:
Bug 32630: database changes
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-02-20 11:58:18 UTC
Size:
1.50 KB
patch
obsolete
>From e54c2db7de1ca50d81bde89f5108472dc4d3da82 Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >Date: Thu, 20 Feb 2025 11:49:49 +0000 >Subject: [PATCH] Bug 32630: database changes > >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3bf15c1007d..43905832581 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3701,7 +3701,7 @@ CREATE TABLE `illrequests` ( > KEY `illrequests_ibfk` (`batch_id`), > CONSTRAINT `illrequests_bcfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT `illrequests_bibfk` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, >- CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `illrequests_bnfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, > CONSTRAINT `illrequests_ibfk` FOREIGN KEY (`batch_id`) REFERENCES `illbatches` (`ill_batch_id`) ON DELETE SET NULL ON UPDATE CASCADE, > CONSTRAINT `illrequests_safk` FOREIGN KEY (`status_alias`) REFERENCES `authorised_values` (`authorised_value`) ON DELETE SET NULL ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >-- >2.39.5
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 32630
:
178387
|
178388
|
178389
|
178390
|
178391
|
178392
|
178393
|
178858
|
178859
|
178860
|
178861
|
178862
|
178863
|
178864
|
178876
|
178877
|
178878
|
178879
|
178880
|
178881
|
178882
|
178883