12 Dec
2018
12 Dec
'18
5:32 p.m.
Hi devs, A quick question, in case I am missing something obvious. Reported on bug 21901: indices are missing on the serial and subscription tables. Worst is, in the serial table: `biblionumber` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `subscriptionid` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', So I think we should: Add FK (with on delete cascade) on - serial.biblionumber - serial.subscritionid - subscription.biblionumber Would it make sense? Cheers, Jonathan