Bugzilla – Attachment 123492 Details for
Bug 22690
Merging records with many items too slow (Elasticsearch)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22690: (QA follow-up) Add relationships to linktracker
Bug-22690-QA-follow-up-Add-relationships-to-linktr.patch (text/plain), 3.21 KB, created by
Martin Renvoize (ashimema)
on 2021-08-05 13:29:16 UTC
(
hide
)
Description:
Bug 22690: (QA follow-up) Add relationships to linktracker
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2021-08-05 13:29:16 UTC
Size:
3.21 KB
patch
obsolete
>From e86bfb626bcd4b32d7db7c72ad7fd799414217ac Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 22 Jul 2021 10:37:26 +0100 >Subject: [PATCH] Bug 22690: (QA follow-up) Add relationships to linktracker > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > .../data/mysql/atomicupdate/bug_22690.perl | 21 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 5 ++++- > 2 files changed, 25 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_22690.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_22690.perl b/installer/data/mysql/atomicupdate/bug_22690.perl >new file mode 100644 >index 0000000000..754372fc86 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_22690.perl >@@ -0,0 +1,21 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ >+ unless( foreign_key_exists( 'linktracker', 'linktracker_biblio_ibfk' ) ) { >+ $dbh->do(q{ UPDATE linktracker SET biblionumber = NULL WHERE biblionumber NOT IN (SELECT biblionumber FROM biblio) }); >+ $dbh->do(q{ ALTER TABLE linktracker ADD CONSTRAINT `linktracker_biblio_ibfk` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL }); >+ } >+ >+ unless( foreign_key_exists( 'linktracker', 'linktracker_item_ibfk' ) ) { >+ $dbh->do(q{ UPDATE linktracker SET itemnumber = NULL WHERE itemnumber NOT IN (SELECT itemnumber FROM items) }); >+ $dbh->do(q{ ALTER TABLE linktracker ADD CONSTRAINT `linktracker_item_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL }); >+ } >+ >+ unless( foreign_key_exists( 'linktracker', 'linktracker_borrower_ibfk' ) ) { >+ $dbh->do(q{ UPDATE linktracker SET borrowernumber = NULL WHERE borrowernumber NOT IN (SELECT borrowernumber FROM borrowers) }); >+ $dbh->do(q{ ALTER TABLE linktracker ADD CONSTRAINT `linktracker_borrower_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL }); >+ } >+ >+ # Always end with this (adjust the bug info) >+ NewVersion( $DBversion, 22690, "Add constraints to linktracker table"); >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 0ff6005d93..c3b992e587 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3339,7 +3339,10 @@ CREATE TABLE `linktracker` ( > KEY `bibidx` (`biblionumber`), > KEY `itemidx` (`itemnumber`), > KEY `borridx` (`borrowernumber`), >- KEY `dateidx` (`timeclicked`) >+ KEY `dateidx` (`timeclicked`), >+ CONSTRAINT `linktracker_biblio_ibfk` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL, >+ CONSTRAINT `linktracker_item_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL, >+ CONSTRAINT `linktracker_borrower_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >-- >2.20.1
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 22690
:
90061
|
90115
|
90116
|
92828
|
94505
|
97696
|
98143
|
98210
|
98211
|
99376
|
99379
|
100316
|
104796
|
104797
|
104871
|
105445
|
106144
|
108777
|
109694
|
110991
|
110994
|
111196
|
111207
|
111236
|
111237
|
112100
|
112184
|
112567
|
112569
|
112754
|
113308
|
113309
|
113941
|
113942
|
113967
|
113968
|
118226
|
118227
|
118229
|
118231
|
118391
|
119433
|
119434
|
120820
|
120821
|
120852
|
120853
|
121389
|
121392
|
121474
|
121516
|
121517
|
121518
|
121519
|
121520
|
122846
|
122847
|
122848
|
122849
|
122850
|
122886
|
122887
|
122888
|
122889
|
122890
|
122936
|
122938
|
122939
|
123029
|
123030
|
123031
|
123032
|
123033
|
123034
|
123035
|
123036
|
123037
|
123038
|
123039
|
123040
|
123041
|
123042
|
123044
|
123062
|
123481
|
123482
|
123483
|
123484
|
123485
|
123486
|
123487
|
123488
|
123489
|
123490
|
123491
| 123492 |
123493
|
123494
|
123495
|
123496
|
123497
|
124176
|
124188
|
124257