Bugzilla – Attachment 194332 Details for
Bug 40504
ILL requests should have ability to assign staff to manage
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40504: Fix DB structure comparison
5f5d766.patch (text/plain), 2.15 KB, created by
Jonathan Druart
on 2026-03-02 11:31:54 UTC
(
hide
)
Description:
Bug 40504: Fix DB structure comparison
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2026-03-02 11:31:54 UTC
Size:
2.15 KB
patch
obsolete
>From 5f5d76660cbc5fb5f1e42b8bd2220965b6d6c216 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 2 Mar 2026 12:08:05 +0100 >Subject: [PATCH] Bug 40504: Fix DB structure comparison > >Fix misc4dev/run_tests.pl --run-db-compare-only >--- > installer/data/mysql/kohastructure.sql | 4 ++-- > 1 file changed, 2 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 4656b1f962c..074b8451904 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3808,16 +3808,16 @@ CREATE TABLE `illrequests` ( > `batch_id` int(11) DEFAULT NULL COMMENT 'Optional ID of batch that this request belongs to', > PRIMARY KEY (`illrequest_id`), > KEY `illrequests_bnfk` (`borrowernumber`), >- KEY `illrequests_manfk` (`managedby`), > KEY `illrequests_bcfk_2` (`branchcode`), > KEY `illrequests_safk` (`status_alias`), > KEY `illrequests_bibfk` (`biblio_id`), > KEY `illrequests_ibfk` (`batch_id`), >+ KEY `illrequests_manfk` (`managedby`), > 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 SET NULL ON UPDATE CASCADE, >- CONSTRAINT `illrequests_manfk` FOREIGN KEY (`managedby`) 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_manfk` FOREIGN KEY (`managedby`) REFERENCES `borrowers` (`borrowernumber`) 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; > /*!40101 SET character_set_client = @saved_cs_client */; >-- >2.43.0 >
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 40504
:
187906
|
187907
|
187908
|
187909
|
187910
|
187911
|
187912
|
187913
|
187914
|
187915
|
188365
|
188563
|
188565
|
188566
|
188567
|
188568
|
188569
|
188570
|
188571
|
188572
|
188573
|
188574
|
188624
|
188625
|
188935
|
188936
|
191196
|
191197
|
191198
|
191199
|
191200
|
191201
|
191202
|
191203
|
191204
|
191205
|
191206
|
192094
|
193186
|
193187
|
193188
|
193189
|
193190
|
193191
|
193192
|
193193
|
193194
|
193195
|
193196
|
193197
|
194023
|
194024
|
194026
|
194027
|
194028
|
194029
|
194030
|
194031
|
194032
|
194033
|
194034
|
194035
|
194036
|
194037
|
194038
| 194332