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

(-)a/installer/data/mysql/atomicupdate/bug_13766_fix_ean.perl (+20 lines)
Line 0 Link Here
1
$DBversion = "XXX";
2
if(CheckVersion($DBversion)) {
3
    # Drop index that might exist because of bug 5337
4
    my $temp = $dbh->selectall_arrayref(q{
5
        SHOW INDEXES FROM biblioitems WHERE key_name = 'ean' });
6
    if( @$temp > 0 ) {
7
        $dbh->do(q{ ALTER TABLE biblioitems DROP INDEX ean });
8
    }
9
10
    # Change data type of column
11
    $dbh->do(q{ ALTER TABLE biblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL });
12
    $dbh->do(q{ ALTER TABLE deletedbiblioitems MODIFY COLUMN ean MEDIUMTEXT default NULL });
13
14
    # Add indexes
15
    $dbh->do(q{ ALTER TABLE biblioitems ADD INDEX ean ( ean(255) )});
16
    $dbh->do(q{ ALTER TABLE deletedbiblioitems ADD INDEX ean ( ean(255 ) )});
17
18
    print "Upgrade to $DBversion done (Bug 13766 - Make ean mediumtext and add ean indexes)\n";
19
    SetVersion($DBversion);
20
}
(-)a/installer/data/mysql/kohastructure.sql (-3 / +4 lines)
Lines 168-174 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
168
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
168
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
169
  `isbn` mediumtext, -- ISBN (MARC21 020$a)
169
  `isbn` mediumtext, -- ISBN (MARC21 020$a)
170
  `issn` mediumtext, -- ISSN (MARC21 022$a)
170
  `issn` mediumtext, -- ISSN (MARC21 022$a)
171
  `ean` varchar(13) default NULL,
171
  `ean` mediumtext default NULL,
172
  `publicationyear` text,
172
  `publicationyear` text,
173
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
173
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
174
  `volumedate` date default NULL,
174
  `volumedate` date default NULL,
Lines 199-204 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
199
  KEY `itemtype_idx` (`itemtype`),
199
  KEY `itemtype_idx` (`itemtype`),
200
  KEY `isbn` (`isbn`(255)),
200
  KEY `isbn` (`isbn`(255)),
201
  KEY `issn` (`issn`(255)),
201
  KEY `issn` (`issn`(255)),
202
  KEY `ean` (`ean`(255)),
202
  KEY `publishercode` (`publishercode`),
203
  KEY `publishercode` (`publishercode`),
203
  KEY `timestamp` (`timestamp`),
204
  KEY `timestamp` (`timestamp`),
204
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
205
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
Lines 525-531 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
525
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
526
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
526
  `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a)
527
  `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a)
527
  `issn` mediumtext default NULL, -- ISSN (MARC21 022$a)
528
  `issn` mediumtext default NULL, -- ISSN (MARC21 022$a)
528
  `ean` varchar(13) default NULL,
529
  `ean` mediumtext default NULL,
529
  `publicationyear` text,
530
  `publicationyear` text,
530
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
531
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
531
  `volumedate` date default NULL,
532
  `volumedate` date default NULL,
Lines 555-560 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
555
  KEY `bibnoidx` (`biblionumber`),
556
  KEY `bibnoidx` (`biblionumber`),
556
  KEY `itemtype_idx` (`itemtype`),
557
  KEY `itemtype_idx` (`itemtype`),
557
  KEY `isbn` (`isbn`(255)),
558
  KEY `isbn` (`isbn`(255)),
559
  KEY `ean` (`ean`(255)),
558
  KEY `publishercode` (`publishercode`),
560
  KEY `publishercode` (`publishercode`),
559
  KEY `timestamp` (`timestamp`)
561
  KEY `timestamp` (`timestamp`)
560
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
562
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
561
- 

Return to bug 13766