Bug 20581: Modifications to database schema
authorAndrew Isherwood <andrew.isherwood@ptfs-europe.com>
Tue, 17 Apr 2018 10:57:09 +0000 (11:57 +0100)
committerNick Clemens <nick@bywatersolutions.com>
Fri, 22 Feb 2019 14:31:31 +0000 (14:31 +0000)
commite631207eaa7df02601353d34ade406ec9c8a5bc3
tree1722bc39cbee7edb18bf9eb2251f87cb4401a7fc
parenta54eb7fd5cba95f6ef350fa50b7713c8c096a204
Bug 20581: Modifications to database schema

- This patch provides an illrequests.status_alias column that is a foreign key to
authorised_values.id. This provides the ability for an ILL request to
have an optional status alias that is defined as an authorised valued.
- A new ILLSTATUS authorised value category is also made available during install.

Signed-off-by: Niamh.Walker-Headon@it-tallaght.ie

Following commit was squashed into this one:

Bug 20581: (follow-up) Modify DB updgrade

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

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>
installer/data/mysql/atomicupdate/bug_20581-add_new_illrequests_status_alias_column.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql
installer/data/mysql/mandatory/auth_val_cat.sql