Hi Jonathan, I think it makes sense - there should be no serials and subscriptions without a linked bibliographic record. In addition to the delete case we should also make sure that it updates the biblionumber on changing the linking in the subscription or when merging records (on update cascade?). I think at the moment this doesn't work correctly and you end up with the wrong biblionumbers in serials (see also bugs 12921, 5334, 21232). Katrin On 12.12.18 18:32, Jonathan Druart wrote:
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 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/