Bug 13743

Summary: Primary key for issues-table
Product: Koha Reporter: Olli-Antti Kivilahti <olli-antti.kivilahti>
Component: CirculationAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt, katrin.fischer, kyle.m.hall, kyle
Version: Main   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9303
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13790
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Bug 13743 - Primary key for issues-table
Bug 13743 - Primary key for issues-table
Bug 13743 - Primary key for issues-table
Bug 13743 - Primary key for issues-table

Description Olli-Antti Kivilahti 2015-02-20 17:28:35 UTC

    
Comment 1 Olli-Antti Kivilahti 2015-02-20 17:34:59 UTC Comment hidden (obsolete)
Comment 2 Olli-Antti Kivilahti 2015-02-20 17:41:13 UTC Comment hidden (obsolete)
Comment 3 Olli-Antti Kivilahti 2015-02-20 17:43:29 UTC Comment hidden (obsolete)
Comment 4 Olli-Antti Kivilahti 2015-03-20 17:02:30 UTC
Created attachment 37060 [details] [review]
Bug 13743 - Primary key for issues-table

Each table must have a primary key.
This makes extending issues-related functionality much easier.

TEST PLAN:

1. Check-out Items for you.
2. Check-in Items from you.
3. Check-out using the SIP2-server.
4. Check-in using the SIP2-server.
Comment 5 Katrin Fischer 2015-03-22 06:40:06 UTC
Hi Olli, 

I think this doesn't look quite right - the database update instance is in the wrong place in the file and I feel the old_issues should not auto_increment. Also I think this wouldn't renumber the old entries?
Please take a look at Kyle's patch on bug 13790 and also my comments on bug 9303.

We did a similar patch for reserves and old_reserves in the past, maybe that could be helpful to look at as well.
Comment 6 Kyle M Hall 2015-03-23 11:24:44 UTC

*** This bug has been marked as a duplicate of bug 13790 ***