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 795-800 CREATE TABLE `import_biblios` ( Link Here
795
  `author` varchar(80) default NULL,
795
  `author` varchar(80) default NULL,
796
  `isbn` varchar(30) default NULL,
796
  `isbn` varchar(30) default NULL,
797
  `issn` varchar(9) default NULL,
797
  `issn` varchar(9) default NULL,
798
  `lccn` varchar(25) default NULL,
799
  `pubdate` smallint(5) default NULL,
798
  `has_items` tinyint(1) NOT NULL default 0,
800
  `has_items` tinyint(1) NOT NULL default 0,
799
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
801
  CONSTRAINT `import_biblios_ibfk_1` FOREIGN KEY (`import_record_id`)
800
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
802
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
801
- 

Return to bug 19269