[Koha-bugs] [Bug 18050] Missing constraint on aqbudgets.budget_period_id in aqbudgets
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Oct 9 00:50:46 CEST 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18050
Agustín Moyano <agustinmoyano at theke.io> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |agustinmoyano at theke.io
--- Comment #15 from Agustín Moyano <agustinmoyano at theke.io> ---
Great job Katrin.. if I may add a comment, in the atomic update, if there are
some budget periods that were not found, instead of not adding the FK
constraint, I would:
1. Create a temporary table.. something like _bug_18050_aqbudgets where I would
copy the offending rows
2. Update aqbudgets.budget_period_id to null, add the FK constraint
3. Emit the warning that some budget periods where not found, and a copy of
those rows where preserved in _bug_18050_aqbudgets table
If it's ok to you, I can add a follow-up with those steps
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list