[Koha-bugs] [Bug 7065] New: reserves table needs a primary key

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

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

             Bug #: 7065
           Summary: reserves table needs a primary key
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Architecture, internals, and plumbing
        AssignedTo: ian.walls at bywatersolutions.com
        ReportedBy: ian.walls at bywatersolutions.com
         QAContact: koha-bugs at lists.koha-community.org
            Blocks: 5609


The reserves (and old_reserves) tables desperately need a primary key. 
reservernumber should be used for consistency sake.  This will allow the
possibility of multiple holds per biblio/patron combination, and a host of
other improvements.

This is included in bug 5872, but needs to be broken out into it's own
enhancement for independent review.

One cavaet: the values must be unique across the union of reserves and
old_reserves.  While this is easy enough to achieve in a new installation,
adding the values into an existing install gets trickier.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.