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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 155-161 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
155
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
155
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
156
  `isbn` mediumtext, -- ISBN (MARC21 020$a)
156
  `isbn` mediumtext, -- ISBN (MARC21 020$a)
157
  `issn` mediumtext, -- ISSN (MARC21 022$a)
157
  `issn` mediumtext, -- ISSN (MARC21 022$a)
158
  `ean` varchar(13) default NULL,
158
  `ean` mediumtext default NULL,
159
  `publicationyear` text,
159
  `publicationyear` text,
160
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
160
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
161
  `volumedate` date default NULL,
161
  `volumedate` date default NULL,
Lines 786-792 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
786
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
786
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
787
  `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a)
787
  `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a)
788
  `issn` mediumtext default NULL, -- ISSN (MARC21 022$a)
788
  `issn` mediumtext default NULL, -- ISSN (MARC21 022$a)
789
  `ean` varchar(13) default NULL,
789
  `ean` mediumtext default NULL,
790
  `publicationyear` text,
790
  `publicationyear` text,
791
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
791
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
792
  `volumedate` date default NULL,
792
  `volumedate` date default NULL,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
Lines 9793-9798 if(CheckVersion($DBversion)) { Link Here
9793
    SetVersion($DBversion);
9793
    SetVersion($DBversion);
9794
}
9794
}
9795
9795
9796
$DBversion = "3.19.00.XXX";
9797
if(CheckVersion($DBversion)) {
9798
    $dbh->do(q{
9799
        ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL
9800
    });
9801
9802
    $dbh->do(q{
9803
        ALTER TABLE deletedbiblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL
9804
    });
9805
9806
    print "Upgrade to $DBversion done (Bug 13766 - Align biblioitems.ean type to biblioitems.isbn)\n";
9807
    SetVersion($DBversion);
9808
}
9809
9796
=head1 FUNCTIONS
9810
=head1 FUNCTIONS
9797
9811
9798
=head2 TableExists($table)
9812
=head2 TableExists($table)
9799
- 

Return to bug 13766