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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1927-1934 CREATE TABLE `subscriptionhistory` ( Link Here
1927
  `histenddate` date default NULL,
1927
  `histenddate` date default NULL,
1928
  `missinglist` longtext NOT NULL,
1928
  `missinglist` longtext NOT NULL,
1929
  `recievedlist` longtext NOT NULL,
1929
  `recievedlist` longtext NOT NULL,
1930
  `opacnote` varchar(150) NOT NULL default '',
1930
  `opacnote` text NOT NULL default '',
1931
  `librariannote` varchar(150) NOT NULL default '',
1931
  `librariannote` text NOT NULL default '',
1932
  PRIMARY KEY  (`subscriptionid`),
1932
  PRIMARY KEY  (`subscriptionid`),
1933
  KEY `biblionumber` (`biblionumber`)
1933
  KEY `biblionumber` (`biblionumber`)
1934
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1934
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 6784-6789 if ( CheckVersion($DBversion) ) { Link Here
6784
    SetVersion ($DBversion);
6784
    SetVersion ($DBversion);
6785
}
6785
}
6786
6786
6787
$DBversion = "3.11.00.XXX";
6788
if ( CheckVersion($DBversion) ) {
6789
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote TEXT NOT NULL DEFAULT ''}):
6790
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote TEXT NOT NULL DEFAULT ''}):
6791
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";
6792
    SetVersion ($DBversion);
6793
}
6787
6794
6788
=head1 FUNCTIONS
6795
=head1 FUNCTIONS
6789
6796
6790
- 

Return to bug 10215