Bug 30449: Add missing FK constraint on borrower_attribute_types
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Mon, 4 Apr 2022 13:20:37 +0000 (13:20 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 2 May 2022 21:22:57 +0000 (11:22 -1000)
commitb1bf07f49ce8bcd7a3d7b05a9f0a97966f9e0295
tree10c81a42477e649aa5a4465dfad4446dac7c73e9
parent7989e661f70a22377348692a9b67e190dab0efc2
Bug 30449: Add missing FK constraint on borrower_attribute_types

Old Koha databases probably have it, newer ones might not.
See also BZ description.

Test plan:
[1} Check SHOW CREATE TABLE borrower_attribute_types to see if you
    have any index and FK constraint on category_code.
[2] Run updatedatabase.
[3] If you had category_code_fk, it should be replaced.
[4] Remove index and constraint again using things like:
    alter table borrower_attribute_types drop constraint `borrower_attribute_types_ibfk_1`;
    alter table borrower_attribute_types drop index category_code;
[5] Run updatedatabase.
[6] You should have KEY category_code and FK borrower_attribute_types_ibfk_1.
[7] Run updatedatabase. Idempotent, no changes.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_30449.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql