Bug 14978: Add unique key constraint on issues.itemnumber
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 8 Oct 2015 08:15:57 +0000 (09:15 +0100)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 2 Nov 2015 15:56:59 +0000 (12:56 -0300)
commit9e1d8d8c5e357a56f88c78eca52ccbb37902d43c
tree14bba999bd512f791b9c3d18ac8afca391c203ea
parent298733cb1e528f117984077442c867c3d2035ee0
Bug 14978: Add unique key constraint on issues.itemnumber

The constraint might have existed before bug 14069.
For these DB, this patch will restore it, for others, it will add it :)

Test plan:
> show create table issues;
should not return "unique key itemnumber"
Execute the updatedb entry twice
> show create table issues;
should return only one "unique key itemnumber"

Signed-off-by: Marc VĂ©ron <veron@veron.ch>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl