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

(-)a/C4/Serials.pm (+1 lines)
Lines 435-440 sub GetSubscriptionsFromBiblionumber { Link Here
435
        } else {
435
        } else {
436
            $subs->{histenddate} = "";
436
            $subs->{histenddate} = "";
437
        }
437
        }
438
        $subs->{opacnote} //= "";
438
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
439
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
439
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
440
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
440
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
441
        $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 2147-2154 CREATE TABLE `subscriptionhistory` ( Link Here
2147
  `histenddate` date default NULL,
2147
  `histenddate` date default NULL,
2148
  `missinglist` LONGTEXT NOT NULL,
2148
  `missinglist` LONGTEXT NOT NULL,
2149
  `recievedlist` LONGTEXT NOT NULL,
2149
  `recievedlist` LONGTEXT NOT NULL,
2150
  `opacnote` varchar(150) NOT NULL default '',
2150
  `opacnote` LONGTEXT NOT NULL default '',
2151
  `librariannote` varchar(150) NOT NULL default '',
2151
  `librariannote` LONGTEXT NOT NULL default '',
2152
  PRIMARY KEY  (`subscriptionid`),
2152
  PRIMARY KEY  (`subscriptionid`),
2153
  KEY `biblionumber` (`biblionumber`)
2153
  KEY `biblionumber` (`biblionumber`)
2154
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2154
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2155
- 

Return to bug 10215