Bug 10215: Increase the size of opacnote and librariannote for table subscriptionhistory
authorKyle M Hall <kyle@bywatersolutions.com>
Tue, 7 May 2013 16:49:03 +0000 (12:49 -0400)
committerLucas Gass <lucas@bywatersolutions.com>
Wed, 12 Jun 2019 22:21:05 +0000 (22:21 +0000)
commit0caaa8e88457c65fdf303fa4a49f361ab07e67cc
treec608ec685a38b36dbe67b3b0a39bdaa2c4445f99
parent76b797bb5fc8ea1d7b7af06406ad0787fc3941c9
Bug 10215: Increase the size of opacnote and librariannote for table subscriptionhistory

We have librarians that are regularly hitting the maximum number of
characters for the note fields in subscription history. They would like
to be able to store at least 1000 characters here. Converting the
varchar(150) to text should do it.

Test Plan:
1) Apply this patch
2) Run updatedatabase.pl
3) Add public and private notes to a subscription history entry
   where each note is greater than 150 characters.
4) Save and view the notes, the notes should not be truncated.

Rescued-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 8592474c3fe6af408c7265a50bd1776a76942397)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
(cherry picked from commit c42c44e932133e6df6c3b9ccda30932d2835f5ee)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
C4/Serials.pm
installer/data/mysql/atomicupdate/bug_10215.perl [new file with mode: 0644]
installer/data/mysql/kohastructure.sql