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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 173-179 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
173
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
173
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
174
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
174
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
175
  `marc` longblob, -- full bibliographic MARC record
175
  `marc` longblob, -- full bibliographic MARC record
176
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
176
  `url` text default NULL, -- url (MARC21 856$u)
177
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
177
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
178
  `cn_class` varchar(30) default NULL,
178
  `cn_class` varchar(30) default NULL,
179
  `cn_item` varchar(10) default NULL,
179
  `cn_item` varchar(10) default NULL,
Lines 775-781 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
775
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
775
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
776
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
776
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
777
  `marc` longblob, -- full bibliographic MARC record
777
  `marc` longblob, -- full bibliographic MARC record
778
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
778
  `url` text default NULL, -- url (MARC21 856$u)
779
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
779
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
780
  `cn_class` varchar(30) default NULL,
780
  `cn_class` varchar(30) default NULL,
781
  `cn_item` varchar(10) default NULL,
781
  `cn_item` varchar(10) default NULL,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7945-7950 if (CheckVersion($DBversion)) { Link Here
7945
    SetVersion($DBversion);
7945
    SetVersion($DBversion);
7946
}
7946
}
7947
7947
7948
$DBversion = "3.15.00.XXX";
7949
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
7950
    $dbh->do("ALTER TABLE biblioitems CHANGE url url TEXT NULL DEFAULT NULL");
7951
    $dbh->do("ALTER TABLE deletedbiblioitems CHANGE url url TEXT NULL DEFAULT NULL");
7952
    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
7953
    SetVersion($DBversion);
7954
}
7955
7948
=head1 FUNCTIONS
7956
=head1 FUNCTIONS
7949
7957
7950
=head2 TableExists($table)
7958
=head2 TableExists($table)
7951
- 

Return to bug 11268