From 65c85793737554c76ffc00ea54e7842051b4cb91 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 25 Mar 2021 14:29:06 +0000 Subject: [PATCH] Bug 27726: Increase 'content' field size This alternate patch increases the field size from a 255 character varchar to a 65535 character text field. This allows for more detailed problem reports to be submitted. Signed-off-by: Amit Gupta Signed-off-by: Petro Vashchuk Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart (cherry picked from commit 7c854a87d221a92051411d822121398f2440ae1e) Signed-off-by: Fridolin Somers --- installer/data/mysql/atomicupdate/bug_27726.perl | 6 ++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_27726.perl diff --git a/installer/data/mysql/atomicupdate/bug_27726.perl b/installer/data/mysql/atomicupdate/bug_27726.perl new file mode 100644 index 0000000000..01d18acb25 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_27726.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do("ALTER TABLE problem_reports MODIFY content TEXT NOT NULL"); + + NewVersion( $DBversion, 27726, "Increase field size for problem_reports.content"); +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ef3bff04b0..01a55c9ccd 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4597,7 +4597,7 @@ DROP TABLE IF EXISTS `problem_reports`; CREATE TABLE `problem_reports` ( `reportid` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha `title` varchar(40) NOT NULL default '', -- report subject line - `content` varchar(255) NOT NULL default '', -- report message content + `content` text NOT NULL, -- report message content `borrowernumber` int(11) NOT NULL default 0, -- the user who created the problem report `branchcode` varchar(10) NOT NULL default '', -- borrower's branch `username` varchar(75) default NULL, -- OPAC username -- 2.20.1