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 2110-2117
          CREATE TABLE `subscriptionhistory` (
      
      
        Link Here
      
    
  

        

          2110
          
  `histenddate` date default NULL,

          2110
          
  `histenddate` date default NULL,

        

        

          2111
          
  `missinglist` LONGTEXT NOT NULL,

          2111
          
  `missinglist` LONGTEXT NOT NULL,

        

        

          2112
          
  `recievedlist` LONGTEXT NOT NULL,

          2112
          
  `recievedlist` LONGTEXT NOT NULL,

        

          
            

              2113
              
  `opacnote` varchar(150) NOT NULL default '',


              2113
              
  `opacnote` LONGTEXT NULL,

            

            

              2114
              
  `librariannote` varchar(150) NOT NULL default '',


              2114
              
  `librariannote` LONGTEXT NULL,

            

        

          2115
          
  PRIMARY KEY  (`subscriptionid`),

          2115
          
  PRIMARY KEY  (`subscriptionid`),

        

        

          2116
          
  KEY `biblionumber` (`biblionumber`)

          2116
          
  KEY `biblionumber` (`biblionumber`)

        

        

          2117
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

          2117
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        

            

              2118
              
- 

              
              
            






  

  Return to bug 10215