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

(-)a/C4/Serials.pm (+1 lines)
Lines 428-433 sub GetSubscriptionsFromBiblionumber { Link Here
428
        } else {
428
        } else {
429
            $subs->{histenddate} = "";
429
            $subs->{histenddate} = "";
430
        }
430
        }
431
        $subs->{opacnote}     //= "";
431
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
432
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
432
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
433
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
433
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
434
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
(-)a/installer/data/mysql/atomicupdate/bug_10215.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if ( CheckVersion($DBversion) ) {
3
4
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote LONGTEXT NULL});
5
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote LONGTEXT NULL});
6
7
    SetVersion ($DBversion);
8
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";
9
}
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 2111-2118 CREATE TABLE `subscriptionhistory` ( Link Here
2111
  `histenddate` date default NULL,
2111
  `histenddate` date default NULL,
2112
  `missinglist` LONGTEXT NOT NULL,
2112
  `missinglist` LONGTEXT NOT NULL,
2113
  `recievedlist` LONGTEXT NOT NULL,
2113
  `recievedlist` LONGTEXT NOT NULL,
2114
  `opacnote` varchar(150) NOT NULL default '',
2114
  `opacnote` LONGTEXT NULL,
2115
  `librariannote` varchar(150) NOT NULL default '',
2115
  `librariannote` LONGTEXT NULL,
2116
  PRIMARY KEY  (`subscriptionid`),
2116
  PRIMARY KEY  (`subscriptionid`),
2117
  KEY `biblionumber` (`biblionumber`)
2117
  KEY `biblionumber` (`biblionumber`)
2118
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2118
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2119
- 

Return to bug 10215