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

[Jonathan Druart]

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