[Koha-bugs] [Bug 14069] Follow-up 13790: Fix database update to drop PK on issues/old_issues first
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Apr 29 10:20:08 CEST 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14069
--- Comment #2 from Jonathan Druart <jonathan.druart at biblibre.com> ---
Created attachment 38644
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=38644&action=edit
Bug 14069: Drop existing primary key on items if exists
On old databases, the issues table has a primary key on itemnumber.
The DBrev 3.19.00.028 (Bug 13790 - Add unique id issue_id to issues and
oldissues tables) has to remove it before adding the new primary key
Test plan:
1/ Make sure you have an old DB, or add primary key (issues.itemnumber)manually
on a DB created before 3.19.00.028.
2/ Execute the updatedatabase.pl script
3/ You should not get any error and the primary key on itemnumber should
have been removed and the new one created as expected.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list