Attachment #23006 for bug #11268

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

Lines 7750-7755 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
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

Lines 173-179 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
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,