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

(-)a/installer/data/mysql/atomicupdate/001-26853-update-import_biblios.perl (+15 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do("DROP INDEX title ON import_biblios");
5
    $dbh->do("DROP INDEX isbn ON import_biblios");
6
    $dbh->do("ALTER TABLE import_biblios MODIFY title LONGTEXT");
7
    $dbh->do("ALTER TABLE import_biblios MODIFY author LONGTEXT");
8
    $dbh->do("ALTER TABLE import_biblios MODIFY isbn LONGTEXT");
9
    $dbh->do("ALTER TABLE import_biblios MODIFY issn LONGTEXT");
10
    $dbh->do("CREATE INDEX title ON import_biblios (title(191));");
11
    $dbh->do("CREATE INDEX isbn ON import_biblios (isbn(191));");
12
13
    # Always end with this (adjust the bug info)
14
    NewVersion( $DBversion, 26853, "Update import_biblios columns and indexes");
15
}
(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 792-807 CREATE TABLE `import_biblios` ( Link Here
792
  `matched_biblionumber` int(11) default NULL,
792
  `matched_biblionumber` int(11) default NULL,
793
  `control_number` varchar(25) default NULL,
793
  `control_number` varchar(25) default NULL,
794
  `original_source` varchar(25) default NULL,
794
  `original_source` varchar(25) default NULL,
795
  `title` varchar(128) default NULL,
795
  `title` LONGTEXT default NULL,
796
  `author` varchar(80) default NULL,
796
  `author` LONGTEXT default NULL,
797
  `isbn` varchar(30) default NULL,
797
  `isbn` LONGTEXT default NULL,
798
  `issn` varchar(9) default NULL,
798
  `issn` LONGTEXT default NULL,
799
  `has_items` tinyint(1) NOT NULL default 0,
799
  `has_items` tinyint(1) NOT NULL default 0,
800
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
800
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
801
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
801
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
802
  KEY `matched_biblionumber` (`matched_biblionumber`),
802
  KEY `matched_biblionumber` (`matched_biblionumber`),
803
  KEY `title` (`title`),
803
  KEY `title` (`title`(191)),
804
  KEY `isbn` (`isbn`)
804
  KEY `isbn` (`isbn`(191))
805
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
805
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
806
806
807
--
807
--
808
- 

Return to bug 26853