Attachment #35932 for bug #13523

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




    SetVersion ($DBversion);
}

$DBversion = "3.19.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        ALTER TABLE biblioitems MODIFY COLUMN marcxml longtext
    });

    $dbh->do(q{
        ALTER TABLE deletedbiblioitems MODIFY COLUMN marcxml longtext
    });

    print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 13523

Lines 9773-9778 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
9773	SetVersion ($DBversion);	9773	SetVersion ($DBversion);
9774	}	9774	}
9775		9775
		9776	$DBversion = "3.19.00.XXX";
		9777	if(CheckVersion($DBversion)) {
		9778	$dbh->do(q{
		9779	ALTER TABLE biblioitems MODIFY COLUMN marcxml longtext
		9780	});
		9781
		9782	$dbh->do(q{
		9783	ALTER TABLE deletedbiblioitems MODIFY COLUMN marcxml longtext
		9784	});
		9785
		9786	print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
		9787	SetVersion($DBversion);
		9788	}
		9789
9776	=head1 FUNCTIONS	9790	=head1 FUNCTIONS
9777		9791
9778	=head2 TableExists($table)	9792	=head2 TableExists($table)
9779	-

Lines 181-187 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
181	`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting	181	`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
182	`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)	182	`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
183	`totalissues` int(10),	183	`totalissues` int(10),
184	`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML	184	`marcxml` longtext, -- full bibliographic MARC record in MARCXML
185	PRIMARY KEY (`biblioitemnumber`),	185	PRIMARY KEY (`biblioitemnumber`),
186	KEY `bibinoidx` (`biblioitemnumber`),	186	KEY `bibinoidx` (`biblioitemnumber`),
187	KEY `bibnoidx` (`biblionumber`),	187	KEY `bibnoidx` (`biblionumber`),
Lines 812-818 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
812	`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting	812	`cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
813	`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)	813	`agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
814	`totalissues` int(10),	814	`totalissues` int(10),
815	`marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML	815	`marcxml` longtext, -- full bibliographic MARC record in MARCXML
816	PRIMARY KEY (`biblioitemnumber`),	816	PRIMARY KEY (`biblioitemnumber`),
817	KEY `bibinoidx` (`biblioitemnumber`),	817	KEY `bibinoidx` (`biblioitemnumber`),
818	KEY `bibnoidx` (`biblionumber`),	818	KEY `bibnoidx` (`biblionumber`),