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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 993-999 CREATE TABLE `import_batches` ( -- information about batches of marc records tha Link Here
993
  `num_records` int(11) NOT NULL default 0, -- number of records in the file
993
  `num_records` int(11) NOT NULL default 0, -- number of records in the file
994
  `num_items` int(11) NOT NULL default 0, -- number of items in the file
994
  `num_items` int(11) NOT NULL default 0, -- number of items in the file
995
  `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded
995
  `upload_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- date and time the file was uploaded
996
  `overlay_action` enum('replace', 'create_new', 'use_template', 'ignore') NOT NULL default 'create_new', -- how to handle duplicate records
996
  `overlay_action` enum('replace', 'create_new', 'use_template', 'ignore','appendmarctag') NOT NULL default 'create_new', -- how to handle duplicate records
997
  `nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', -- how to handle records where no match is found
997
  `nomatch_action` enum('create_new', 'ignore') NOT NULL default 'create_new', -- how to handle records where no match is found
998
  `item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') NOT NULL default 'always_add', -- what to do with item records
998
  `item_action` enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') NOT NULL default 'always_add', -- what to do with item records
999
  `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file
999
  `import_status` enum('staging', 'staged', 'importing', 'imported', 'reverting', 'reverted', 'cleaned') NOT NULL default 'staging', -- the status of the imported file
Lines 1001-1006 CREATE TABLE `import_batches` ( -- information about batches of marc records tha Link Here
1001
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
1001
  `record_type` enum('biblio', 'auth', 'holdings') NOT NULL default 'biblio', -- type of record in the batch
1002
  `file_name` varchar(100), -- the name of the file uploaded
1002
  `file_name` varchar(100), -- the name of the file uploaded
1003
  `comments` mediumtext, -- any comments added when the file was uploaded
1003
  `comments` mediumtext, -- any comments added when the file was uploaded
1004
  `marctag` mediumtext, -- marc tag for ex: 100a, 700a
1004
  PRIMARY KEY (`import_batch_id`),
1005
  PRIMARY KEY (`import_batch_id`),
1005
  KEY `branchcode` (`branchcode`)
1006
  KEY `branchcode` (`branchcode`)
1006
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1007
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7912-7917 if ( CheckVersion($DBversion) ) { Link Here
7912
    SetVersion($DBversion);
7912
    SetVersion($DBversion);
7913
}
7913
}
7914
7914
7915
$DBversion = "3.15.00.XXX";
7916
if ( CheckVersion($DBversion) ) {
7917
    $dbh->do("ALTER TABLE import_batches MODIFY overlay_action  enum('replace', 'create_new', 'use_template', 'ignore', 'appendmarctag') NOT NULL default 'create_new'");
7918
    $dbh->do("ALTER TABLE import_batches ADD COLUMN marctag mediumtext");
7919
    print "Upgrade to $DBversion done (Bug 10477: Alter table import_batches )\n";
7920
    SetVersion ($DBversion);
7921
}
7922
7915
=head1 FUNCTIONS
7923
=head1 FUNCTIONS
7916
7924
7917
=head2 TableExists($table)
7925
=head2 TableExists($table)
7918
- 

Return to bug 10477