Bug 10604: increase width of two columns in the courses table
authorGalen Charlton <gmc@esilibrary.com>
Wed, 17 Jul 2013 14:35:16 +0000 (14:35 +0000)
committerGalen Charlton <gmc@esilibrary.com>
Mon, 22 Jul 2013 14:46:58 +0000 (14:46 +0000)
commit3793bfe9ed4e5f77aa3a2e4baf57258887abb70b
treed9ad09f83786c22d839fa9a4e9ec8d74251a37ab
parentee224415b7c8b5e31f9c052e1c14a143ab137898
Bug 10604: increase width of two columns in the courses table

The department and term columns in the courses table started
as varchar(20), but since they refer to authorized values, need
to be varchar(80) to match authorised_values.authorised_value.  This
patch increases the width of those columns.

To test:

[1] Create two DEPARTMENT authorised values, one whose code
    is shorter than 20 characters and one whose code is longer
    than 20 characters.
[2] Create two courses; give one course the short department and
    the other the long department.
[3] Go to the courses list.  Observe that the department column is
    displays the department name only for the short course.
[4] Apply the patch.
[5] Edit the course with the long department and assign that long
    department to it again.
[6] Go back to the courses list.  Observe that both of the courses
    now display their assigned department.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Verified changes are consistent for new installations
and updated installations.
Passes all tests.

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