Some of the existing constraints are wrong, some does not exist. On the 3 bug reports (see original message), I have submitted patches to add/fix the FK constraint, but we will loose data. The big advantage is... not to loose these data :) For the major part of the existing foreign keys, we can keep them, even if the patron is "deleted". We will need to provide a script to really remove the patrons a library would want to delete. 2016-01-13 15:57 GMT+00:00 Marcel de Rooy <M.de.Rooy@rijksmuseum.nl>:
Do not forget all cascaded updates and deletes. If you only set the flag, you will still need to perform those. What would be the big advantage of doing this?
I am wondering why do we have a borrowers and a deletedborrowers tables when a "delete" flag in the borrowers table could do the trick.
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/