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