https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40529

--- Comment #59 from Pedro Amorim <[email protected]> ---
Created attachment 188933
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=188933&action=edit
Bug 40529: (QA follow-up): Fix DB changes

Add UNIQUE KEY entries to table definition
The UNIQUE KEY are required as a hold group 'might have' a target hold, not
'has many' target holds.
This update and the other things this patch updates in atomicupdate +
kohastructure should  fix the error thrown by command:
perl /kohadevbox/misc4dev/run_tests.pl --instance=kohadev
--db-password=password --run-db-compare-only --compare-with=HEAD

This command no longer produces any errors.

Also in this patch:
Renamed table from 'hold_group_target_holds' to 'hold_groups_target_holds' and
move it alphabetically to be after 'hold_groups' in kohastructure.sql
This is cleaner, as it matches the 'hold_groups' related table, and allows for
alphabetical sorting on kohastructure.sql that makes sense i.e. hold_groups is
created first, then hold_group_target_holds is created second with an FK to the
former.

All of this passes:
prove ./t/db_dependent/Koha/Hold.t
prove ./t/db_dependent/Reserves/HoldGroup.t
prove ./t/db_dependent/Circulation*
prove ./t/db_dependent/Hold*
prove ./t/db_dependent/Reserves*

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to