[Koha-bugs] [Bug 13007] suggestions.budgetid should be a foreign key
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Sep 30 15:29:14 CEST 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13007
Jonathan Druart <jonathan.druart at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #31924|0 |1
is obsolete| |
--- Comment #3 from Jonathan Druart <jonathan.druart at biblibre.com> ---
Created attachment 31945
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=31945&action=edit
Bug 13007: Add a foreign key for suggestions.budgetid
The DB field suggestions.budgetid should be linked to
aqbudgets.budget_id.
If the fund is removed, this column should be set to NULL.
Test plan:
0/ Verify it is not possible to create an suggestion not linked to a fund via
the Koha interface.
1/ Using your SQL CLI (or equivalent), create or update 1+ suggestions and
set
"0" in the budgetid field.
2/ Execute the updatedabase script.
3/ Verify that your suggestion is unlinked to the nonexistent fund.
4/ Verify the constraint has correctly been added (show create table
suggestions).
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list