View | Details | Raw Unified | Return to bug 27726
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_27726.perl (+6 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do("ALTER TABLE problem_reports MODIFY content TEXT NOT NULL DEFAULT ''");
4
5
    NewVersion( $DBversion, 27726, "Increase field size for problem_reports.content");
6
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4132-4138 DROP TABLE IF EXISTS `problem_reports`; Link Here
4132
CREATE TABLE `problem_reports` (
4132
CREATE TABLE `problem_reports` (
4133
  `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
4133
  `reportid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
4134
  `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report subject line',
4134
  `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report subject line',
4135
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report message content',
4135
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'report message content',
4136
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report',
4136
  `borrowernumber` int(11) NOT NULL DEFAULT 0 COMMENT 'the user who created the problem report',
4137
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'borrower''s branch',
4137
  `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'borrower''s branch',
4138
  `username` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'OPAC username',
4138
  `username` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'OPAC username',
4139
- 

Return to bug 27726