https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15516 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #184066|0 |1 is obsolete| | --- Comment #529 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Created attachment 185465 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=185465&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 Signed-off-by: Andrew Fuerste Henry <andrew@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.