[Koha-devel] Issues table and foreign keys in general

[Srdjan]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I have noticed some things:

1. issues table has nullable borrowernumber and itemnumber; foreign
key constraints are consequently declared as "ON DELETE SET NULL ON
UPDATE SET NULL"

2. That is not an isolated issue, there are many cases where foreign
key field/constraints are declared like that

Can anyone shed more light, that looksvery wrong to me.

Thanks,
Srdjan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk2k/pcACgkQX6p/D9UE7dy2fQCfZP/QeVQSb7VNNMJvA5yYWdBj
AvAAn0fRuZ1KinfIiIIWCR+EgXhmYBu8
=2WSQ
-----END PGP SIGNATURE-----