Bug 22428: Change datatype of field_value to text
authorMatt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Tue, 21 Feb 2023 10:31:13 +0000 (10:31 +0000)
committerJacob O'Mara <jacob.omara@ptfs-europe.com>
Wed, 1 Mar 2023 15:27:23 +0000 (15:27 +0000)
commite2b439fbb07cad8f08932fd0243d1ab6d98229da
tree7d57e0bff772b0bc0a52856f6d4c94dc8ba341a4
parenta079ac031245f4ba0c1742ef11c716962ad88d91
Bug 22428: Change datatype of field_value to text

This patch changes the datatype of the field_value column in
marc_modification_template_actions to "text". This is to stop text
strings longer than 100 characters from being chopped short and allow
longer strings up to 65,000 characters.

Test plan:
1) Follow the same steps outlined by Caroline in the problem statement
2) Apply patch
3) Follow the steps again and this time the text should upload with no
   problem

Signed-off-by: Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit cce48fc7d41ee9a0a38ae6b537830de886f86fb4)
Signed-off-by: Jacob O'Mara <jacob.omara@ptfs-europe.com>
installer/data/mysql/atomicupdate/bug_22428-change_field_value_column.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql