https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42425 --- Comment #36 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- Created attachment 209539 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=209539&action=edit Bug 42425: (QA follow-up) Sort accountlines constraints like MariaDB dumps them The DB compare CI job (misc4dev run_tests.pl --compare-with) diffs a dump of an upgraded database against kohastructure.sql. MariaDB lists foreign keys sorted by name, so accountlines_ibfk_checkins is dumped between accountlines_ibfk_branches and accountlines_ibfk_credit_type, not last as kohastructure.sql had it. This is the same problem Pedro found for the checkins table on bug 42418 comment #119. This patch moves the constraint. There are no changes to the table definition, and the DBIC schema files generated from kohastructure.sql do not change. Test plan: 1. Apply patch 2. Run the DB compare job against main: $ ktd --shell k$ perl /kohadevbox/misc4dev/run_tests.pl --run-db-compare-only \ --compare-with=main => SUCCESS: No diff for the accountlines table 3. Sign off :-D Assisted-by: Opus 5.5 (Anthropic) -- You are receiving this mail because: You are watching all bug changes.