Bug 11384: rename the collections_tracking.ctId column
authorGalen Charlton <gmc@esilibrary.com>
Wed, 11 Dec 2013 16:49:01 +0000 (16:49 +0000)
committerGalen Charlton <gmc@esilibrary.com>
Mon, 23 Dec 2013 16:14:57 +0000 (16:14 +0000)
commit5f015d050281a676670b592831f5b1bd11c81f47
tree9c28d939b474bd9bb9ded509ac9267159f3ac493
parent458ef35a6a5c7da5523e8c1c208fdf3fee5ae4b6
Bug 11384: rename the collections_tracking.ctId column

'ctId' as a column name conflicts with one of the system
columns that PostgreSQL uses for each table, and consequently
needs to be renamed to enable deploying the schema to a Pg
database.  This patch makes this change.

To test:

[1] Apply the patch and run the SQL specified in the database
    updated.
[2] Verify that the collections_tracking table no longer has
    a ctId column, but now has collections_tracking_id.
[3] Verify that prove -v t/db_dependent/RotatingCollections.t
    passes.
[4] Verify that installer/data/mysql/kohastructure.sql runs
    cleanly in an empty database.

This patch does not affect user-visible behavior given the fact
that the rotating collections feature is currently disabled.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
C4/RotatingCollections.pm
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl