Bug 11384: rename the collections_tracking.ctId column
authorGalen Charlton <gmc@esilibrary.com>
Wed, 11 Dec 2013 16:49:01 +0000 (16:49 +0000)
committerFridolin SOMERS <fridolin.somers@biblibre.com>
Fri, 3 Jan 2014 08:24:21 +0000 (09:24 +0100)
commit95d96afb54eca86cae327e0a05da05de5a4c7f62
tree277a606bedf5b0a3d64eab301a8f136026236a3b
parent83823153cfa50d0b0d80b2c42515fcfaa4a52332
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>
(cherry picked from commit 5f015d050281a676670b592831f5b1bd11c81f47)
Signed-off-by: Fridolin SOMERS <fridolin.somers@biblibre.com>
Conflicts:
installer/data/mysql/updatedatabase.pl
C4/RotatingCollections.pm
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl