Bug 7718 - Remove itemnumber column from serials table
authorKyle M Hall <kyle@bywatersolutions.com>
Mon, 4 Feb 2013 13:16:58 +0000 (08:16 -0500)
committerGalen Charlton <gmc@esilibrary.com>
Wed, 22 May 2013 15:44:31 +0000 (08:44 -0700)
commit67fb83d52554031f946709495112920fa2fc784c
tree7f5fd864bb7129a0973030acd93c45cfea0acdf6
parent33b6ed32b40133c2c88e17aebf4d3382bd966c6f
Bug 7718 - Remove itemnumber column from serials table

Remove the column 'itemnumber' from the table 'serial'. This is
a 1 to many relationship, and this reference does not make sense.
The 'serialitems' table handles the relationship between the 'items'
table and the 'serial' table.

Test Plan:
1) Apply patch
2) Run updatedatabase.pl
3) Verify serial.itemnumber has been removed from the database

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Column removed. No errors.

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl