From 25f6ace0050fad5fa753b7cfe123eec0bfbeca58 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 3 Apr 2020 14:40:16 +0200 Subject: [PATCH] Bug 4461: Extend problem_reports.problempage to TEXT 255 chars is not enough if want want to store any kind of URL, for instance an authorities search can be much longer Signed-off-by: Jonathan Druart --- .../mysql/atomicupdate/bug-4461_add-problem-reports-table.perl | 2 +- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug-4461_add-problem-reports-table.perl b/installer/data/mysql/atomicupdate/bug-4461_add-problem-reports-table.perl index 02dcb49281..fab48d778d 100644 --- a/installer/data/mysql/atomicupdate/bug-4461_add-problem-reports-table.perl +++ b/installer/data/mysql/atomicupdate/bug-4461_add-problem-reports-table.perl @@ -9,7 +9,7 @@ if( CheckVersion( $DBversion ) ) { 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 - problempage varchar(255) default NULL, -- page the user triggered the problem report form from + problempage TEXT default NULL, -- page the user triggered the problem report form from recipient enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission status varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 2b7371fd52..af10ac5317 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4448,7 +4448,7 @@ CREATE TABLE `problem_reports` ( `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 - `problempage` varchar(255) default NULL, -- page the user triggered the problem report form from + `problempage` TEXT default NULL, -- page the user triggered the problem report form from `recipient` enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission `status` varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed -- 2.20.1