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 772-778 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
772
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
772
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
773
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
773
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
774
  `marc` longblob, -- full bibliographic MARC record
774
  `marc` longblob, -- full bibliographic MARC record
775
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
775
  `url` text default NULL, -- url (MARC21 856$u)
776
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
776
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
777
  `cn_class` varchar(30) default NULL,
777
  `cn_class` varchar(30) default NULL,
778
  `cn_item` varchar(10) default NULL,
778
  `cn_item` varchar(10) default NULL,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 7750-7755 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7750
    SetVersion($DBversion);
7750
    SetVersion($DBversion);
7751
}
7751
}
7752
7752
7753
$DBversion = "3.13.00.XXX";
7754
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
7755
    $dbh->do("ALTER TABLE biblioitems CHANGE url url TEXT NULL DEFAULT NULL");
7756
    $dbh->do("ALTER TABLE deletedbiblioitems CHANGE url url TEXT NULL DEFAULT NULL");
7757
    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
7758
    SetVersion($DBversion);
7759
}
7753
7760
7754
=head1 FUNCTIONS
7761
=head1 FUNCTIONS
7755
7762
7756
- 

Return to bug 11268