Bug 20581: (follow-up) Do not use PK for AV FK
authorAndrew Isherwood <andrew.isherwood@ptfs-europe.com>
Tue, 5 Feb 2019 14:10:36 +0000 (14:10 +0000)
committerNick Clemens <nick@bywatersolutions.com>
Fri, 22 Feb 2019 14:31:31 +0000 (14:31 +0000)
commit39471ea91255b11cf238009f0a0576514d8774e9
tree24d66e3d9b1691679f68b9d27f47cf4cb018cb73
parentc6f98aab5b0f8e3e09704e8513b6741cf0dd4e02
Bug 20581: (follow-up) Do not use PK for AV FK

As per:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20581#c133

We switch from using authorised_values.id when creating the foreign key
illrequests.status_alias, we now use authorised_values.authorised_value

I have added a migration from using id -> authorised_value, so when
existing users of this bug get this version, their DB migrates nicely
instead of just breaking.

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
ill/ill-requests.pl
installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl
installer/data/mysql/kohastructure.sql
koha-tmpl/intranet-tmpl/prog/en/modules/ill/ill-requests.tt