[Koha-bugs] [Bug 7793] redefine the field message_id as PRIMARY KEY of message_queue

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7793

Galen Charlton <gmcharlt at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gmcharlt at gmail.com

--- Comment #8 from Galen Charlton <gmcharlt at gmail.com> ---
(In reply to Jared Camins-Esakov from comment #3)
> I'm concerned about this patch because there is nothing to prevent two rows
> having duplicate message_ids. The existing index is KEY and not UNIQUE.

Since the column is AUTO_INCREMENT, I question to what extent this would be a
problem in practice unless folks have been in the habit of munging message_id.

Regardless, a follow-up to the schema update should be straightforward: check
to see if there are duplicates, and if so, renumber the affected rows.  I don't
think that there is any code that cares about any particular values in that
column.

-- 
You are receiving this mail because:
You are watching all bug changes.