[Koha-devel] Missing FK on serial tables (?)

[Katrin Fischer]

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 at 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/