@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 4 ++-- installer/data/mysql/updatedatabase.pl | 14 ++++++++++++++ 2 files changed, 16 insertions(+), 2 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -155,7 +155,7 @@ CREATE TABLE `biblioitems` ( -- information related to bibliographic records in `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) `isbn` mediumtext, -- ISBN (MARC21 020$a) `issn` mediumtext, -- ISSN (MARC21 022$a) - `ean` varchar(13) default NULL, + `ean` mediumtext default NULL, `publicationyear` text, `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) `volumedate` date default NULL, @@ -786,7 +786,7 @@ CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c) `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a) `issn` mediumtext default NULL, -- ISSN (MARC21 022$a) - `ean` varchar(13) default NULL, + `ean` mediumtext default NULL, `publicationyear` text, `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b) `volumedate` date default NULL, --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -9793,6 +9793,20 @@ if(CheckVersion($DBversion)) { SetVersion($DBversion); } +$DBversion = "3.19.00.XXX"; +if(CheckVersion($DBversion)) { + $dbh->do(q{ + ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL + }); + + $dbh->do(q{ + ALTER TABLE deletedbiblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL + }); + + print "Upgrade to $DBversion done (Bug 13766 - Align biblioitems.ean type to biblioitems.isbn)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) --