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

(-)a/installer/data/mysql/atomicupdate/bug19269-add-lccn-pubdate-to-import-records.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
3
if( CheckVersion( $DBversion ) ) {
4
    $dbh->do( "ALTER TABLE import_biblios ADD COLUMN lccn varchar(25)" );
5
    $dbh->do( "ALTER TABLE import_biblios ADD COLUMN pubdate smallint(5)" );
6
7
    # Always end with this (adjust the bug info)
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug XXXXX - Add lccn and pubdate columns to import_biblios)\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 819-824 CREATE TABLE `import_biblios` ( Link Here
819
  `author` varchar(80) default NULL,
819
  `author` varchar(80) default NULL,
820
  `isbn` varchar(30) default NULL,
820
  `isbn` varchar(30) default NULL,
821
  `issn` varchar(9) default NULL,
821
  `issn` varchar(9) default NULL,
822
  `lccn` varchar(25) default NULL,
823
  `pubdate` smallint(5) default NULL,
822
  `has_items` tinyint(1) NOT NULL default 0,
824
  `has_items` tinyint(1) NOT NULL default 0,
823
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
825
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
824
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
826
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
825
- 

Return to bug 19269