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)
committerFrédéric Demians <f.demians@tamil.fr>
Wed, 2 Dec 2015 07:55:31 +0000 (08:55 +0100)
commit916f31971317cfbcf261085c06017e5738b0326e
treefbc6344ca0ec32113ec154804d17466e7228dc0b
parenteb95e2beb18dd5cbb6ed54520f958b5a17423625
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>
(cherry picked from commit 9e1d8d8c5e357a56f88c78eca52ccbb37902d43c)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl