Attachment #36087 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 9779-9784 if ( CheckVersion($DBversion) ) { Link Here

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

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