Bug 7793: redefine the field message_id as PRIMARY KEY of message_queue
authorOlli-Antti Kivilahti <olli-antti.kivilahti@jns.fi>
Tue, 24 Feb 2015 17:00:23 +0000 (19:00 +0200)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 22 Jun 2015 19:50:48 +0000 (16:50 -0300)
commit78da33100def3b478d68cec25109449cc239597d
tree5f72617e9f9434523017ca8cc4817248472f399e
parent1ea3465d30b1b0fcd12a5592ce5a4c34a9a58462
Bug 7793: redefine the field message_id as PRIMARY KEY of message_queue

Making message_queue work nicely with DBIx.

DROP the existing KEY and replace with an PRIMARY KEY.
If somebody has managed to get duplicate message_ids in his/her
message_queue-table, this patch takes care of them as well, but givin
all duplicate message_id's a new id.

TEST INSTRUCTIONS: in the patch.

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@koha-community.org>
Amended patch: Remove change to Koha/Schema/Result/MessageQueue.pm, will
be done by the RM
Signed-off-by: Tomas Cohen Arazi <tomascohen@unc.edu.ar>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl