Bug 13790: Add unique id issue_id to issues and old_issues tables
authorKyle M Hall <kyle@bywatersolutions.com>
Wed, 4 Mar 2015 09:16:24 +0000 (01:16 -0800)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Thu, 23 Apr 2015 15:57:36 +0000 (12:57 -0300)
commit0ec47d2ae6f687d4691efc0d2a14f0b04789898c
tree6151f8825a50186f6b2aa22c6b3c55e6231bf170
parent8f7ecb7c7818b026c57a5febadb34efb061217ae
Bug 13790: Add unique id issue_id to issues and old_issues tables

Test Plan:
1) Use a database with existing issues and old issues
2) Apply this patch
3) Run updatedatabase
4) Inspect the database
   a) old_issues should now have a column issue_id starting with 1
   b) issues should now have a column issue_id starting with the number
      of rows in the old_issues table plus one
5) Perform a checkout, note it is written to the database
6) Check in the checked out item, note it is moved to the old_issues table

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Nick Clemens <nick@quecheelibrary.org>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl