https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15516 --- Comment #512 from David Cook <dcook@prosentient.com.au> --- Created attachment 184066 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=184066&action=edit Bug 15516: (follow-up) explicitly define indexes for foreign keys This patch explicitly defines indexes for foreign keys. This isn't really needed for the atomic update, but we've included it for consistency. It is needed in kohastructure.sql, because MySQL/MariaDB silently/implicitly adds these indexes for foreign keys, which means that the database audit tool will show a discrepancy between kohastructure.sql and the installed DB schema. Also fix a discrepancy between atomic update and kohastructure.sql Test plan: 0. Apply the patch 1. Use both methods to update the DB schema 2. Go to http://localhost:8081/cgi-bin/koha/about.pl?tab=database 3. Note that about.pl isn't telling you to drop the indexes for reserves_ibfk_hg and old_reserves_ibfk_hg now -- You are receiving this mail because: You are watching all bug changes.