Attachment #24741 for bug #11268

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

Lines 7945-7950 if (CheckVersion($DBversion)) { Link Here

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

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 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,