[Bug 7794] New: redefine the field id as PRIMARY KEY of sessions
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 Priority: P5 - low Change sponsored?: --- Bug ID: 7794 Assignee: gmcharlt@gmail.com Summary: redefine the field id as PRIMARY KEY of sessions QA Contact: koha.sekjal@gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: stephane.delaune@biblibre.com Hardware: All Status: NEW Version: unspecified Component: Database Product: Koha table sessions has a UNIQUE KEY `id`, we should move to PRIMARY KEY -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 --- Comment #1 from stephane.delaune@biblibre.com --- Created attachment 8490 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8490&action=edit proposed patch -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 stephane.delaune@biblibre.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Assignee|gmcharlt@gmail.com |stephane.delaune@biblibre.c | |om -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #8490|0 |1 is obsolete| | --- Comment #2 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- Created attachment 9538 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9538&action=edit Bug 7794:redefine the field id as PRIMARY KEY of sessions Signed-off-by: Jared Camins-Esakov <jcamins@cpbibliography.com> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |paul.poulain@biblibre.com --- Comment #3 from Paul Poulain <paul.poulain@biblibre.com> --- QA comment: tiny patch, that works, but after it has been applied, both UNIQUE and PRIMARY KEY are in the table definition. A ALTER TABLE sessions DROP UNIQUE KEY `id`; is usefull to remove the UNIQUE KEY and keep only the primary key. Will push with a follow-up adding this -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7794 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master Version|unspecified |rel_3_10 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org